/// <summary> /// 增加一条数据 /// </summary> public bool Add(WxSuCaiInfoModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CORE.dbo.WxSuCaiInfo ("); strSql.Append("Invalid,FmImgId,MerId,InputCode,WxSuCaiTitle,WxSuCaiContent,Memo,WxSuCaiTypeId,WxSuCaiClassId,CreateTime,CreateUser"); strSql.Append(") values ("); strSql.Append("@Invalid,@FmImgId,@MerId,@InputCode,@WxSuCaiTitle,@WxSuCaiContent,@Memo,@WxSuCaiTypeId,@WxSuCaiClassId,@CreateTime,@CreateUser"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Invalid", SqlDbType.Bit, 1), new SqlParameter("@FmImgId", SqlDbType.VarChar, 50), new SqlParameter("@MerId", SqlDbType.Decimal, 9), new SqlParameter("@InputCode", SqlDbType.VarChar, 500), new SqlParameter("@WxSuCaiTitle", SqlDbType.VarChar, 50), new SqlParameter("@WxSuCaiContent", SqlDbType.NText), new SqlParameter("@Memo", SqlDbType.VarChar, 500), new SqlParameter("@WxSuCaiTypeId", SqlDbType.Int, 4), new SqlParameter("@WxSuCaiClassId", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Invalid; parameters[1].Value = model.FmImgId; parameters[2].Value = model.MerId; parameters[3].Value = model.InputCode; parameters[4].Value = model.WxSuCaiTitle; parameters[5].Value = model.WxSuCaiContent; parameters[6].Value = model.Memo; parameters[7].Value = model.WxSuCaiTypeId; parameters[8].Value = model.WxSuCaiClassId; parameters[9].Value = model.CreateTime; parameters[10].Value = model.CreateUser; bool result = false; try { model.WxSuCaiInfoId = decimal.Parse(helper.ExecuteNonQueryBackId(strSql.ToString(), "WxSuCaiInfoId", parameters)); //反写 result = true; } catch (Exception ex) { this.helper.Close(); throw ex; } finally { } return(result); }
private void SaveSuCaiInfo() { Model.WxSuCaiInfoModel model = new WxSuCaiInfoModel(); BLL.WxBLL wbll = new BLL.WxBLL(); Model.CurrentMerModel cm = BLL.MerchantBLL.CurrentModel(); #region 事务开启 TransactionOptions transactionOption = new TransactionOptions(); transactionOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOption)) { #endregion model.WxSuCaiInfoId = ReDecimal("WxSuCaiInfoId", 0); if (model.WxSuCaiInfoId == 0) { //新增 } else { model = wbll.GetSuCaiInfoModel(model.WxSuCaiInfoId); } model.WxSuCaiTitle = ReStr("WxSuCaiTitle"); model.InputCode = ReStr("InputCode", Common.PinYin.GetCodstring(model.WxSuCaiTitle)); model.WxSuCaiContent = ReStrDeCode("WxSuCaiContent"); model.Memo = ReStr("Memo", ""); model.WxSuCaiTypeId = ReInt("WxSuCaiTypeId"); model.WxSuCaiClassId = ReInt("WxSuCaiClassId"); model.CreateUser = cm.CurrentUserId; model.Invalid = ReBool("Invalid", false); model.FmImgId = ReStr("FmImgId", ""); model.MerId = ReDecimal("MerId", cm.CurrentMerId); wbll.SaveSuCaiInfo(model); switch (model.WxSuCaiClassId) { case 2: //如果是图文 wbll.RemoveSuCaiDetail(" WxSuCaiInfoId='" + model.WxSuCaiInfoId + "' "); DataTable dtDetail = ReTable("detail"); if (dtDetail.Rows.Count == 0) { throw new Exception("图文回复需要至少一条明细!"); } foreach (DataRow drDetail in dtDetail.Rows) { Model.WxSuCaiDetailModel DetailModel = new WxSuCaiDetailModel(); DetailModel.ImgId = drDetail["ImgId"].ToString(); DetailModel.OrderNo = int.Parse(drDetail["OrderNo"].ToString()); DetailModel.OtherPara = drDetail["OtherPara"].ToString(); DetailModel.ReKey = drDetail["ReKey"].ToString(); DetailModel.Url = HttpUtility.UrlDecode(drDetail["Url"].ToString()); DetailModel.WxSuCaiInfoId = model.WxSuCaiInfoId; DetailModel.WxSuCaiDetailMemo = drDetail["WxSuCaiDetailMemo"].ToString(); try { DetailModel.WxSuCaiDetailClassId = int.Parse(drDetail["WxSuCaiDetailClassId"].ToString()); } catch { continue; } try { DetailModel.WxSuCaiDetailContent = drDetail["WxSuCaiDetailContent"].ToString(); } catch { DetailModel.WxSuCaiDetailContent = ""; } DetailModel.WxSuCaiDetailId = 0; //必须的,就靠它新增 DetailModel.WxSuCaiDetailTitle = drDetail["WxSuCaiDetailTitle"].ToString(); wbll.SaveSuCaiDetail(DetailModel); } break; default: //其他 break; } #region 事务关闭 transactionScope.Complete(); } #endregion ReDict2.Add("WxSuCaiInfoId", model.WxSuCaiInfoId.ToString()); ReTrue(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WxSuCaiInfoModel GetModel(decimal WxSuCaiInfoId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select WxSuCaiInfoId, Invalid, FmImgId, MerId, InputCode, WxSuCaiTitle, WxSuCaiContent, Memo, WxSuCaiTypeId, WxSuCaiClassId, CreateTime, CreateUser "); strSql.Append(" from CORE.dbo.WxSuCaiInfo "); strSql.Append(" where WxSuCaiInfoId=@WxSuCaiInfoId"); SqlParameter[] parameters = { new SqlParameter("@WxSuCaiInfoId", SqlDbType.Decimal) }; parameters[0].Value = WxSuCaiInfoId; WxSuCaiInfoModel model = new WxSuCaiInfoModel(); DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["WxSuCaiInfoId"].ToString() != "") { model.WxSuCaiInfoId = decimal.Parse(ds.Tables[0].Rows[0]["WxSuCaiInfoId"].ToString()); } if (ds.Tables[0].Rows[0]["Invalid"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Invalid"].ToString() == "1") || (ds.Tables[0].Rows[0]["Invalid"].ToString().ToLower() == "true")) { model.Invalid = true; } else { model.Invalid = false; } } model.FmImgId = ds.Tables[0].Rows[0]["FmImgId"].ToString(); if (ds.Tables[0].Rows[0]["MerId"].ToString() != "") { model.MerId = decimal.Parse(ds.Tables[0].Rows[0]["MerId"].ToString()); } model.InputCode = ds.Tables[0].Rows[0]["InputCode"].ToString(); model.WxSuCaiTitle = ds.Tables[0].Rows[0]["WxSuCaiTitle"].ToString(); model.WxSuCaiContent = ds.Tables[0].Rows[0]["WxSuCaiContent"].ToString(); model.Memo = ds.Tables[0].Rows[0]["Memo"].ToString(); if (ds.Tables[0].Rows[0]["WxSuCaiTypeId"].ToString() != "") { model.WxSuCaiTypeId = int.Parse(ds.Tables[0].Rows[0]["WxSuCaiTypeId"].ToString()); } if (ds.Tables[0].Rows[0]["WxSuCaiClassId"].ToString() != "") { model.WxSuCaiClassId = int.Parse(ds.Tables[0].Rows[0]["WxSuCaiClassId"].ToString()); } if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } model.CreateUser = ds.Tables[0].Rows[0]["CreateUser"].ToString(); return(model); } else { return(model); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WxSuCaiInfoModel model) { bool reValue = true; int reCount = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("update CORE.dbo.WxSuCaiInfo set "); strSql.Append(" Invalid = @Invalid , "); strSql.Append(" FmImgId = @FmImgId , "); strSql.Append(" MerId = @MerId , "); strSql.Append(" InputCode = @InputCode , "); strSql.Append(" WxSuCaiTitle = @WxSuCaiTitle , "); strSql.Append(" WxSuCaiContent = @WxSuCaiContent , "); strSql.Append(" Memo = @Memo , "); strSql.Append(" WxSuCaiTypeId = @WxSuCaiTypeId , "); strSql.Append(" WxSuCaiClassId = @WxSuCaiClassId , "); strSql.Append(" CreateTime = @CreateTime , "); strSql.Append(" CreateUser = @CreateUser "); strSql.Append(" where WxSuCaiInfoId=@WxSuCaiInfoId "); SqlParameter[] parameters = { new SqlParameter("@WxSuCaiInfoId", SqlDbType.Decimal, 9), new SqlParameter("@Invalid", SqlDbType.Bit, 1), new SqlParameter("@FmImgId", SqlDbType.VarChar, 50), new SqlParameter("@MerId", SqlDbType.Decimal, 9), new SqlParameter("@InputCode", SqlDbType.VarChar, 500), new SqlParameter("@WxSuCaiTitle", SqlDbType.VarChar, 50), new SqlParameter("@WxSuCaiContent", SqlDbType.NText), new SqlParameter("@Memo", SqlDbType.VarChar, 500), new SqlParameter("@WxSuCaiTypeId", SqlDbType.Int, 4), new SqlParameter("@WxSuCaiClassId", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.VarChar, 50) }; parameters[0].Value = model.WxSuCaiInfoId; parameters[1].Value = model.Invalid; parameters[2].Value = model.FmImgId; parameters[3].Value = model.MerId; parameters[4].Value = model.InputCode; parameters[5].Value = model.WxSuCaiTitle; parameters[6].Value = model.WxSuCaiContent; parameters[7].Value = model.Memo; parameters[8].Value = model.WxSuCaiTypeId; parameters[9].Value = model.WxSuCaiClassId; parameters[10].Value = model.CreateTime; parameters[11].Value = model.CreateUser; try {//异常处理 reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters); } catch (Exception ex) { this.helper.Close(); throw ex; } if (reCount <= 0) { reValue = false; } return(reValue); }