Beispiel #1
0
        /// <summary>
        /// 通过IDataReader创建ShipCompanyInfo
        /// </summary>
        public static ShipCompanyInfo BuildShipCompanyFromReader(IDataReader reader)
        {
            ShipCompanyInfo shipCompanyInfo = new ShipCompanyInfo();

            shipCompanyInfo.ShipCoId = TypeHelper.ObjectToInt(reader["shipcoid"]);
            shipCompanyInfo.Name = reader["name"].ToString();
            shipCompanyInfo.DisplayOrder = TypeHelper.ObjectToInt(reader["displayorder"]);

            return shipCompanyInfo;
        }
Beispiel #2
0
 /// <summary>
 /// 更新配送公司
 /// </summary>
 public void UpdateShipCompany(ShipCompanyInfo shipCompanyInfo)
 {
     DbParameter[] param = {
                             GenerateInParam("@name",SqlDbType.NChar, 30, shipCompanyInfo.Name),
                             GenerateInParam("@displayorder",SqlDbType.Int,4,shipCompanyInfo.DisplayOrder),
                             GenerateInParam("@shipcoid", SqlDbType.SmallInt, 2, shipCompanyInfo.ShipCoId)
                            };
     string commandText = String.Format("UPDATE [{0}shipcompanies] SET [name]=@name,[displayorder]=@displayorder WHERE [shipcoid]=@shipcoid",
                                         RDBSHelper.RDBSTablePre);
     RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, param);
 }
Beispiel #3
0
 /// <summary>
 /// 创建配送公司
 /// </summary>
 public void CreateShipCompany(ShipCompanyInfo shipCompanyInfo)
 {
     DbParameter[] param = {
                             GenerateInParam("@name",SqlDbType.NChar, 30, shipCompanyInfo.Name),
                             GenerateInParam("@displayorder",SqlDbType.Int,4,shipCompanyInfo.DisplayOrder)
                            };
     string commandText = String.Format("INSERT INTO [{0}shipcompanies] ([name],[displayorder]) VALUES(@name,@displayorder)",
                                         RDBSHelper.RDBSTablePre);
     RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, param);
 }
        public ActionResult Add(ShipCompanyModel model)
        {
            if (AdminShipCompanies.GetShipCoIdByName(model.CompanyName) > 0)
                ModelState.AddModelError("CompanyName", "名称已经存在");

            if (ModelState.IsValid)
            {
                ShipCompanyInfo shipCompanyInfo = new ShipCompanyInfo()
                {
                    Name = model.CompanyName,
                    DisplayOrder = model.DisplayOrder
                };

                AdminShipCompanies.CreateShipCompany(shipCompanyInfo);
                AddMallAdminLog("添加配送公司", "添加配送公司,配送公司为:" + model.CompanyName);
                return PromptView("配送公司添加成功");
            }
            ViewData["referer"] = MallUtils.GetMallAdminRefererCookie();
            return View(model);
        }
Beispiel #5
0
 /// <summary>
 /// 更新配送公司
 /// </summary>
 public static void UpdateShipCompany(ShipCompanyInfo shipCompanyInfo)
 {
     BrnMall.Core.BMAData.RDBS.UpdateShipCompany(shipCompanyInfo);
 }