/// <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; }
/// <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); }
/// <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); }
/// <summary> /// 更新配送公司 /// </summary> public static void UpdateShipCompany(ShipCompanyInfo shipCompanyInfo) { BrnMall.Core.BMAData.RDBS.UpdateShipCompany(shipCompanyInfo); }