首页 > 代码库 > 【盟友88物通网——物流专线管理】jquery循环Reaper某一列的值

【盟友88物通网——物流专线管理】jquery循环Reaper某一列的值

VIEW

                <table id="table_list" width="720" class="tb2" cellpadding="0" cellspacing="0">                  <tr >                      <td class="dh strong" width="40"><input type="checkbox" ></td>                    <td class="dh strong" width="100">搬出省市</td>                    <td class="dh strong" width="100">搬入省市</td>                    <td class="dh strong" width="50">联系人</td>                    <td class="dh strong" width="80">联系电话</td>                    <td class="dh strong" width="80">发布日期</td>                @*    <td class="dh strong" width="80">信息竞价</td>*@                                       <td class="dh strong" width="50">搬家状态</td>                    <td class="dh strong" width="50">操作</td>                    <td class="dh strong" width="30">查看</td>                    <td class="dh strong" width="30">修改</td>                    <td class="dh strong" width="50">删除</td>                  </tr>                  @foreach (var item in Model)                  {                      <tr id="tr_list1" data="@item.Id" data1="@item.Type">                          <td width="40"><input type="checkbox" ></td>                        <td>@item.StartArea</td>                        <td>@item.EndArea</td>                        <td>@item.LinkName</td>                        <td style="line-height:15px;">@item.LinkPhone<br>@item.LinkMobile</td>                        <td>@String.Format("{0:yyyy-MM-dd}", item.AddDate)</td>                      @*  <td><input type="button" class="btn2"></td>*@                        <td >@((item.Type) == true ? "已搬" : "未搬")</td>                        <td><input type="button"  value="@((item.Type) == true ? "确认未搬" : "确认已搬")"  class="btnUpdateMoved" ></td>                        <td><a href="/MoveHouseInfo/@item.Id"><img src="/images/find.png" width="19" height="19"></a></td>                        <td><a href="/Member/PublishMoveHouseInfo/?type=get&id=@item.Id"><img src="/images/xg.png" width="16" height="16"></a></td>                        <td><a href="javascript:void" class="del"><img src="/images/del.png" width="19" height="19"></a></td>                      </tr>                  }                </table>
View Code
<script type="text/javascript">    $(function () {        $(".btnUpdateMoved").click(function () {            var $parent = $(this).parent().parent();            var _id = $parent.attr("data");            var _type = $parent.attr("data1");            $.post("/Member/UpdateType/", { id: _id, type: _type }, function (json) {                if (json.code == 0) {                    //成功                         location = location;                                                  return true;                }                else {                    //失败                    alert(json.msg);                    return false;                }            });            $parent.each(function () {                $parent.find("td:eq(6)").each(function () {                    if ($(this).html() == "已搬") {                        $(this).html("未搬");                    }                    else {                        $(this).html("已搬");                    }                });            });        });        $(".del").click(function () {            if (confirm("确实要删除此记录?")) {                var $this = $(this).parent().parent();                var _id = $this.attr("data");                $.post("/Member/DelMoveHouseInfo/", { id: _id }, function (json) {                    if (json.code == 0) {                        //成功                        $this.remove();                        return true;                    }                    else {                        //失败                        alert(json.msg);                        return false;                    }                });            }        });    });    </script>

Control

 //修改专线状态          public JsonResult UpdateSpecial(int id, bool special)        {            special = special == true ? false : true;            if (Models.DAL.ExpressLine.UpdateSpecial(id, special) > 0)            {                return Json(new { code = 0, msg = "" });            }            else            {                return Json(new { code = 1, msg = "修改失败" });            }        }      

SQLServerDAL

        #region 修改快递线路状态        /// <summary>        ///根据自动编号、快递线路状态修改快递线路信息        /// </summary>        /// <param name="Id">自动编号</param>        /// <param name="IsSpecial">是否专线</param>        /// <returns></returns>        public int UpdateSpecial(int Id, bool IsSpecial)        {                        string str = string.Format("update ExpressLine set IsSpecial={0} where Id={1}", Convert.ToInt32(IsSpecial), Id);            return DBUtility.SqlHelper.ExecuteNonQuery(ConnString.conn, CommandType.Text, str, null);        }        #endregion