/// <summary> /// 修改商家配置 /// </summary> /// <param name="info"></param> /// <returns></returns> public bool UpdateSupplierCfg(SupplierConfigInfo info) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update Ecshop_SupplierConfig set "); stringBuilder.Append("ShortDesc=@ShortDesc,"); stringBuilder.Append("ImageUrl=@ImageUrl,"); stringBuilder.Append("DisplaySequence=@DisplaySequence,"); stringBuilder.Append("Type=@Type,"); stringBuilder.Append("Client=@Client,"); stringBuilder.Append("IsDisable=@IsDisable,"); stringBuilder.Append("SupplierId=@SupplierId"); stringBuilder.Append(" where Id=@Id "); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString()); this.database.AddInParameter(sqlStringCommand, "Id", DbType.Int32, info.Id); this.database.AddInParameter(sqlStringCommand, "ShortDesc", DbType.String, info.ShortDesc); this.database.AddInParameter(sqlStringCommand, "ImageUrl", DbType.String, info.ImageUrl); this.database.AddInParameter(sqlStringCommand, "DisplaySequence", DbType.String, info.DisplaySequence); this.database.AddInParameter(sqlStringCommand, "Type", DbType.Int32, info.Type); this.database.AddInParameter(sqlStringCommand, "Client", DbType.Int32, info.Client); this.database.AddInParameter(sqlStringCommand, "IsDisable", DbType.Boolean, info.IsDisable); this.database.AddInParameter(sqlStringCommand, "SupplierId", DbType.Int32, info.SupplierId); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
private void SetSupplierCfg(int id) { SupplierConfigInfo info = SupplierConfigHelper.GetSupplierCfgById(this.id); this.ddlSupplier.SelectedValue = info.SupplierId.ToString(); this.txtDesc.Text = info.ShortDesc; this.littlepic.Src = info.ImageUrl; this.fmSrc.Value = info.ImageUrl; }
/// <summary> /// 获取商家配置 /// </summary> /// <param name="id"></param> /// <returns></returns> public SupplierConfigInfo GetSupplierCfgById(int id) { StringBuilder stringBuilder = new StringBuilder(" select * from Ecshop_SupplierConfig where Id=@Id"); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString()); this.database.AddInParameter(sqlStringCommand, "Id", DbType.Int32, id); SupplierConfigInfo result = null; using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { result = ReaderConvert.ReaderToModel <SupplierConfigInfo>(dataReader); } return(result); }
public static void SwapSupplierCfgSequence(int Id, int replaceId) { SupplierConfigDao supplierConfigDao = new SupplierConfigDao(); SupplierConfigInfo info = supplierConfigDao.GetSupplierCfgById(Id); SupplierConfigInfo replaceInfo = supplierConfigDao.GetSupplierCfgById(replaceId); if (info != null && replaceInfo != null) { int displaySequence = info.DisplaySequence; info.DisplaySequence = replaceInfo.DisplaySequence; replaceInfo.DisplaySequence = displaySequence; supplierConfigDao.UpdateSupplierCfg(info); supplierConfigDao.UpdateSupplierCfg(replaceInfo); } }
protected void btnAddSupplier_Click(object sender, System.EventArgs e) { if (this.id == 0) { SupplierConfigInfo info = new SupplierConfigInfo(); info.IsDisable = false; info.ImageUrl = this.fmSrc.Value; info.ShortDesc = this.txtDesc.Text; info.Client = (int)ClientType.App; info.Type = (int)SupplierCfgType.Hot; info.SupplierId = int.Parse(this.ddlSupplier.SelectedValue); if (string.IsNullOrWhiteSpace(info.ImageUrl)) { this.ShowMsg("请上传图片!", false); return; } if (SupplierConfigHelper.SaveSupplierCfg(info) > 0) { this.CloseWindow(); return; } this.ShowMsg("添加错误!", false); } else { SupplierConfigInfo info = SupplierConfigHelper.GetSupplierCfgById(this.id); info.IsDisable = false; info.ImageUrl = this.fmSrc.Value; info.ShortDesc = this.txtDesc.Text; info.SupplierId = int.Parse(this.ddlSupplier.SelectedValue); if (SupplierConfigHelper.UpdateSupplierCfg(info)) { this.CloseWindow(); return; } this.ShowMsg("修改失败!", false); } }
/// <summary> /// 添加商家配置 /// </summary> /// <param name="info"></param> /// <returns></returns> public int SaveSupplierCfg(SupplierConfigInfo info) { int result; int displaySequence = this.GetMaxSupplierCfgSequence(); StringBuilder stringBuilder = new StringBuilder("insert into Ecshop_SupplierConfig (ShortDesc,ImageUrl,DisplaySequence,Client,IsDisable,SupplierId,Type)"); stringBuilder.Append("values (@ShortDesc,@ImageUrl,@DisplaySequence,@Client,@IsDisable,@SupplierId,@Type);select @@IDENTITY"); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString()); this.database.AddInParameter(sqlStringCommand, "ShortDesc", DbType.String, info.ShortDesc); this.database.AddInParameter(sqlStringCommand, "ImageUrl", DbType.String, info.ImageUrl); this.database.AddInParameter(sqlStringCommand, "DisplaySequence", DbType.String, displaySequence); this.database.AddInParameter(sqlStringCommand, "Client", DbType.Int32, info.Client); this.database.AddInParameter(sqlStringCommand, "IsDisable", DbType.Boolean, info.IsDisable); this.database.AddInParameter(sqlStringCommand, "SupplierId", DbType.Int32, info.SupplierId); this.database.AddInParameter(sqlStringCommand, "Type", DbType.Int32, info.Type); if (!int.TryParse(this.database.ExecuteScalar(sqlStringCommand).ToString(), out result)) { result = 0; } return(result); }
/// <summary> /// 修改商家配置 /// </summary> /// <param name="info"></param> /// <returns></returns> public static bool UpdateSupplierCfg(SupplierConfigInfo info) { return(new SupplierConfigDao().UpdateSupplierCfg(info)); }
/// <summary> /// 添加商家配置 /// </summary> /// <param name="info"></param> /// <returns></returns> public static int SaveSupplierCfg(SupplierConfigInfo info) { return(new SupplierConfigDao().SaveSupplierCfg(info)); }