Esempio n. 1
0
        private string getStringCZ(Model.ReceiveInfo offer)
        {
            string op = "";

            op += "<input type='button' value='修改' class='btn btn-success btn-sm' onclick=\"pcallhtml('/mobile/html/AddReceive.aspx?id=" + offer.Id + "', '新增收货人');\" /><br/>";
            op += "<input type='button' value='删除' class='btn btn-success btn-sm' onclick='delreceive(" + offer.Id + ")' /><br/>";
            return(op);
        }
Esempio n. 2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public static Hashtable Update(Model.ReceiveInfo model, Hashtable MyHs)
        {
            string        guid   = Guid.NewGuid().ToString();
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update ReceiveInfo set ");

            strSql.Append(" IsDeleted = @IsDeleted , ");
            strSql.Append(" Status = @Status , ");
            strSql.Append(" IsMain = @IsMain , ");
            strSql.Append(" ZipCode = @ZipCode , ");
            strSql.Append(" MID = @MID , ");
            strSql.Append(" Province = @Province , ");
            strSql.Append(" City = @City , ");
            strSql.Append(" Zone = @Zone , ");
            strSql.Append(" Tel = @Tel , ");
            strSql.Append(" Receiver = @Receiver , ");
            strSql.Append(" Phone = @Phone , ");
            strSql.Append(" Address = @Address  ");
            strSql.Append(" where Id=@Id ");
            strSql.AppendFormat(" ;select '{0}'", guid);

            SqlParameter[] parameters =
            {
                new SqlParameter("@Id",        SqlDbType.Int,       4),
                new SqlParameter("@IsDeleted", SqlDbType.Bit,       1),
                new SqlParameter("@Status",    SqlDbType.Int,       4),
                new SqlParameter("@IsMain",    SqlDbType.Bit,       1),
                new SqlParameter("@ZipCode",   SqlDbType.NChar,    10),
                new SqlParameter("@MID",       SqlDbType.VarChar,  50),
                new SqlParameter("@Province",  SqlDbType.NVarChar, 50),
                new SqlParameter("@City",      SqlDbType.NVarChar, 50),
                new SqlParameter("@Zone",      SqlDbType.NVarChar, 50),
                new SqlParameter("@Tel",       SqlDbType.VarChar,  20),
                new SqlParameter("@Receiver",  SqlDbType.VarChar,  20),
                new SqlParameter("@Phone",     SqlDbType.VarChar,  20),
                new SqlParameter("@Address",   SqlDbType.NVarChar, 500)
            };

            parameters[0].Value  = model.Id;
            parameters[1].Value  = model.IsDeleted;
            parameters[2].Value  = model.Status;
            parameters[3].Value  = model.IsMain;
            parameters[4].Value  = model.ZipCode;
            parameters[5].Value  = model.MID;
            parameters[6].Value  = model.Province;
            parameters[7].Value  = model.City;
            parameters[8].Value  = model.Zone;
            parameters[9].Value  = model.Tel;
            parameters[10].Value = model.Receiver;
            parameters[11].Value = model.Phone;
            parameters[12].Value = model.Address;
            MyHs.Add(strSql.ToString(), parameters);
            return(MyHs);
        }
Esempio n. 3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public static Hashtable Insert(Model.ReceiveInfo model, Hashtable MyHs)
        {
            string        guid   = Guid.NewGuid().ToString();
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ReceiveInfo(");
            strSql.Append("IsDeleted,Status,IsMain,ZipCode,MID,Province,City,Zone,Tel,Receiver,Phone,Address");
            strSql.Append(") values (");
            strSql.Append("@IsDeleted,@Status,@IsMain,@ZipCode,@MID,@Province,@City,@Zone,@Tel,@Receiver,@Phone,@Address");
            strSql.Append(") ");
            strSql.AppendFormat(";select '{0}'", guid);
            SqlParameter[] parameters =
            {
                new SqlParameter("@IsDeleted", SqlDbType.Bit,       1),
                new SqlParameter("@Status",    SqlDbType.Int,       4),
                new SqlParameter("@IsMain",    SqlDbType.Bit,       1),
                new SqlParameter("@ZipCode",   SqlDbType.NChar,    10),
                new SqlParameter("@MID",       SqlDbType.VarChar,  50),
                new SqlParameter("@Province",  SqlDbType.NVarChar, 50),
                new SqlParameter("@City",      SqlDbType.NVarChar, 50),
                new SqlParameter("@Zone",      SqlDbType.NVarChar, 50),
                new SqlParameter("@Tel",       SqlDbType.VarChar,  20),
                new SqlParameter("@Receiver",  SqlDbType.VarChar,  20),
                new SqlParameter("@Phone",     SqlDbType.VarChar,  20),
                new SqlParameter("@Address",   SqlDbType.NVarChar, 500)
            };

            parameters[0].Value  = model.IsDeleted;
            parameters[1].Value  = model.Status;
            parameters[2].Value  = model.IsMain;
            parameters[3].Value  = model.ZipCode;
            parameters[4].Value  = model.MID;
            parameters[5].Value  = model.Province;
            parameters[6].Value  = model.City;
            parameters[7].Value  = model.Zone;
            parameters[8].Value  = model.Tel;
            parameters[9].Value  = model.Receiver;
            parameters[10].Value = model.Phone;
            parameters[11].Value = model.Address;
            MyHs.Add(strSql.ToString(), parameters);
            return(MyHs);
        }
Esempio n. 4
0
        protected override void SetValue(string id)
        {
            string oid = HttpUtility.UrlDecode(Request["id"].Trim());//订单Id

            hidId.Value            = oid;
            orderModel             = BLL.Order.GetModel(oid);
            ReceiveInfoModel       = BLL.ReceiveInfo.GetModel(orderModel.ReceiveId);
            ViewState["OrderInfo"] = orderModel;
            Session["OrderId"]     = oid;

            List <Model.OrderDetail> listdetail = BLL.OrderDetail.GetList(" OrderCode='" + orderModel.Code + "';");

            foreach (Model.OrderDetail item in listdetail)
            {
                Model.Goods gs = BLL.Goods.GetModel(item.GId);
                if (gs != null)
                {
                    strgoods += gs.GName + "&nbsp;&nbsp;&nbsp;" + item.GCount + gs.Unit + ";<br/>";
                }
            }
        }
Esempio n. 5
0
        protected override void SetValue(string id)
        {
            string oid = HttpUtility.UrlDecode(Request["id"].Trim());//订单Id

            hidId.Value            = oid;
            orderModel             = BLL.Order.GetModel(oid);
            ReceiveInfoModel       = BLL.ReceiveInfo.GetModel(orderModel.ReceiveId);
            ViewState["OrderInfo"] = orderModel;
            Session["OrderId"]     = oid;
            string gids = "";

            foreach (Model.OrderDetail od in orderModel.OrderDetail)
            {
                gids += od.GId + ",";
            }
            gids = gids.TrimEnd(',');
            var listGood = BLL.Goods.GetList("GID in (" + gids + ")");

            repGoodList.DataSource = listGood;
            repGoodList.DataBind();
        }
Esempio n. 6
0
        //添加收货人,并保证只有一个默认收货人
        protected override string btnAdd_Click()
        {
            string    sid  = Request.Form["hidId"];
            Hashtable myHs = new Hashtable();

            Model.ReceiveInfo obj = null;
            if (string.IsNullOrEmpty(sid) || sid == "0")
            {
                //添加
                obj     = ReceiveInfoModel;
                obj.MID = TModel.MID;
                BLL.ReceiveInfo.Insert(obj, myHs);
                if (obj.IsMain == true)
                {
                    BLL.ReceiveInfo.UpdateToNoMian(TModel.MID, "0");
                }
            }
            else
            {
                obj = ReceiveInfoModel;
                BLL.ReceiveInfo.Update(obj, myHs);
                if (obj.IsMain == true)
                {
                    BLL.ReceiveInfo.UpdateToNoMian(TModel.MID, obj.Id.ToString());
                }
            }
            if (BLL.CommonBase.RunHashtable(myHs))
            {
                var list = BLL.ReceiveInfo.GetList("IsDeleted=0 and MID='" + TModel.MID + "'");
                if (list.Where(c => c.IsMain == true).Count() <= 0)
                {
                    Model.ReceiveInfo info = list[0];
                    info.IsMain = true;
                    BLL.ReceiveInfo.Update(info);
                }
                return("操作成功");
            }
            return("操作失败");
        }
Esempio n. 7
0
        /// <summary>
        ///  实体转换
        /// <summary>
        private static Model.ReceiveInfo TranEntity(DataRow dr)
        {
            if (dr != null)
            {
                Model.ReceiveInfo model = new Model.ReceiveInfo();

                if (!string.IsNullOrEmpty(dr["Id"].ToString()))
                {
                    model.Id = int.Parse(dr["Id"].ToString());
                }
                if (!string.IsNullOrEmpty(dr["IsDeleted"].ToString()))
                {
                    model.IsDeleted = bool.Parse(dr["IsDeleted"].ToString());
                }
                if (!string.IsNullOrEmpty(dr["Status"].ToString()))
                {
                    model.Status = int.Parse(dr["Status"].ToString());
                }
                if (!string.IsNullOrEmpty(dr["IsMain"].ToString()))
                {
                    model.IsMain = bool.Parse(dr["IsMain"].ToString());
                }
                model.ZipCode  = dr["ZipCode"].ToString();
                model.MID      = dr["MID"].ToString();
                model.Province = dr["Province"].ToString();
                model.City     = dr["City"].ToString();
                model.Zone     = dr["Zone"].ToString();
                model.Tel      = dr["Tel"].ToString();
                model.Receiver = dr["Receiver"].ToString();
                model.Phone    = dr["Phone"].ToString();
                model.Address  = dr["Address"].ToString();

                return(model);
            }
            else
            {
                return(null);
            }
        }
Esempio n. 8
0
 public static bool Update(Model.ReceiveInfo model)
 {
     return(yny_003.DAL.ReceiveInfo.Update(model));
 }
Esempio n. 9
0
 public static Hashtable Update(Model.ReceiveInfo model, Hashtable MyHs)
 {
     return(yny_003.DAL.ReceiveInfo.Update(model, MyHs));
 }
Esempio n. 10
0
 public static bool Insert(Model.ReceiveInfo model)
 {
     return(yny_003.DAL.ReceiveInfo.Insert(model));
 }
Esempio n. 11
0
 public static Hashtable Insert(Model.ReceiveInfo model, Hashtable MyHs)
 {
     return(yny_003.DAL.ReceiveInfo.Insert(model, MyHs));
 }
Esempio n. 12
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public static bool Insert(Model.ReceiveInfo model)
 {
     return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable())));
 }
Esempio n. 13
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public static bool Update(Model.ReceiveInfo model)
 {
     return(DAL.CommonBase.RunHashtable(Update(model, new Hashtable())));
 }