/// <summary>
/// 得到一个对象实体
/// </summary>
public WxSendInfoModel GetModel(decimal WxSendId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select WxSendId, FmImgId, WxSuCaiId, SendContent, InputCode, WxSendTitle, CreateTime, CreateUser, WxSendType, WxSendClassId, WxPtId, Memo ");
strSql.Append(" from CORE.dbo.WxSendInfo ");
strSql.Append(" where WxSendId=@WxSendId");
SqlParameter[] parameters =
{
new SqlParameter("@WxSendId", SqlDbType.Decimal)
};
parameters[0].Value = WxSendId;
WxSendInfoModel model = new WxSendInfoModel();
DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["WxSendId"].ToString() != "")
{
model.WxSendId = decimal.Parse(ds.Tables[0].Rows[0]["WxSendId"].ToString());
}
model.FmImgId = ds.Tables[0].Rows[0]["FmImgId"].ToString();
if (ds.Tables[0].Rows[0]["WxSuCaiId"].ToString() != "")
{
model.WxSuCaiId = decimal.Parse(ds.Tables[0].Rows[0]["WxSuCaiId"].ToString());
}
model.SendContent = ds.Tables[0].Rows[0]["SendContent"].ToString();
model.InputCode = ds.Tables[0].Rows[0]["InputCode"].ToString();
model.WxSendTitle = ds.Tables[0].Rows[0]["WxSendTitle"].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();
model.WxSendType = ds.Tables[0].Rows[0]["WxSendType"].ToString();
if (ds.Tables[0].Rows[0]["WxSendClassId"].ToString() != "")
{
model.WxSendClassId = int.Parse(ds.Tables[0].Rows[0]["WxSendClassId"].ToString());
}
if (ds.Tables[0].Rows[0]["WxPtId"].ToString() != "")
{
model.WxPtId = decimal.Parse(ds.Tables[0].Rows[0]["WxPtId"].ToString());
}
model.Memo = ds.Tables[0].Rows[0]["Memo"].ToString();
return(model);
}
else
{
return(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WxSendInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CORE.dbo.WxSendInfo (");
strSql.Append("FmImgId,WxSuCaiId,SendContent,InputCode,WxSendTitle,CreateTime,CreateUser,WxSendType,WxSendClassId,WxPtId,Memo");
strSql.Append(") values (");
strSql.Append("@FmImgId,@WxSuCaiId,@SendContent,@InputCode,@WxSendTitle,@CreateTime,@CreateUser,@WxSendType,@WxSendClassId,@WxPtId,@Memo");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@FmImgId", SqlDbType.VarChar, 50),
new SqlParameter("@WxSuCaiId", SqlDbType.Decimal, 9),
new SqlParameter("@SendContent", SqlDbType.NText),
new SqlParameter("@InputCode", SqlDbType.VarChar, 500),
new SqlParameter("@WxSendTitle", SqlDbType.VarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.VarChar, 50),
new SqlParameter("@WxSendType", SqlDbType.VarChar, 50),
new SqlParameter("@WxSendClassId", SqlDbType.Int, 4),
new SqlParameter("@WxPtId", SqlDbType.Decimal, 9),
new SqlParameter("@Memo", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.FmImgId;
parameters[1].Value = model.WxSuCaiId;
parameters[2].Value = model.SendContent;
parameters[3].Value = model.InputCode;
parameters[4].Value = model.WxSendTitle;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateUser;
parameters[7].Value = model.WxSendType;
parameters[8].Value = model.WxSendClassId;
parameters[9].Value = model.WxPtId;
parameters[10].Value = model.Memo;
bool result = false;
try
{
model.WxSendId = decimal.Parse(helper.ExecuteNonQueryBackId(strSql.ToString(), "WxSendId", parameters));
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
private void SaveSendInfo()
{
#region 事务开启
TransactionOptions transactionOption = new TransactionOptions();
transactionOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOption))
{
#endregion
Model.WxSendInfoModel model = new WxSendInfoModel();
BLL.WxBLL bll = new BLL.WxBLL();
model.WxSendId = ReDecimal("WxSendId", 0);
if (model.WxSendId == 0)
{
model.WxPtId = ReDecimal("WxPtId");
}
else
{
//如果是修改, 选取出原来的数据
model = bll.GetWxSendModel(model.WxSendId);
}
model.WxSendTitle = ReStr("WxSendTitle");
model.WxSendType = ReStr("WxSendType");
model.WxSendClassId = ReInt("WxSendClassId");
model.Memo = ReStr("Memo");
model.FmImgId = ReStr("FmImgId");
model.WxSuCaiId = ReDecimal("WxSuCaiId", 0);
model.SendContent = ReStrDeCode("SendContent");
bll.SaveSendInfo(model);
DataTable dtKeys = ReTable("KeysAreray");
if (dtKeys.Rows.Count == 0)
{
throw new Exception("没有添加激发时间, 这个回应没有触发将没有意义!");
}
DAL.WxKeyDAL keyDal = new DAL.WxKeyDAL();
keyDal.DeleteList(" WxSendId='" + model.WxSendId + "' "); //首先删除所有的key关联关系
foreach (DataRow drKeys in dtKeys.Rows)
{
if (model.WxSendId == 0)
{
throw new Exception("在执行插入之后,WxSendId不能为0!");
}
Model.WxKeyModel KeyModel = new WxKeyModel();
KeyModel.WxSendId = model.WxSendId;
KeyModel.KeyTitle = drKeys["KeyTitle"].ToString();
KeyModel.KeyTypeId = drKeys["KeyTypeId"].ToString();
KeyModel.KeyTypeDetailId = drKeys["KeyTypeDetailId"].ToString();
keyDal.Add(KeyModel); //逐个添加新的关联关系
}
ReDict.Add("WxSendId", model.WxSendId);
#region 事务关闭
transactionScope.Complete();
}
#endregion
ReTrue();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WxSendInfoModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update CORE.dbo.WxSendInfo set ");
strSql.Append(" FmImgId = @FmImgId , ");
strSql.Append(" WxSuCaiId = @WxSuCaiId , ");
strSql.Append(" SendContent = @SendContent , ");
strSql.Append(" InputCode = @InputCode , ");
strSql.Append(" WxSendTitle = @WxSendTitle , ");
strSql.Append(" CreateTime = @CreateTime , ");
strSql.Append(" CreateUser = @CreateUser , ");
strSql.Append(" WxSendType = @WxSendType , ");
strSql.Append(" WxSendClassId = @WxSendClassId , ");
strSql.Append(" WxPtId = @WxPtId , ");
strSql.Append(" Memo = @Memo ");
strSql.Append(" where WxSendId=@WxSendId ");
SqlParameter[] parameters =
{
new SqlParameter("@WxSendId", SqlDbType.Decimal, 9),
new SqlParameter("@FmImgId", SqlDbType.VarChar, 50),
new SqlParameter("@WxSuCaiId", SqlDbType.Decimal, 9),
new SqlParameter("@SendContent", SqlDbType.NText),
new SqlParameter("@InputCode", SqlDbType.VarChar, 500),
new SqlParameter("@WxSendTitle", SqlDbType.VarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.VarChar, 50),
new SqlParameter("@WxSendType", SqlDbType.VarChar, 50),
new SqlParameter("@WxSendClassId", SqlDbType.Int, 4),
new SqlParameter("@WxPtId", SqlDbType.Decimal, 9),
new SqlParameter("@Memo", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.WxSendId;
parameters[1].Value = model.FmImgId;
parameters[2].Value = model.WxSuCaiId;
parameters[3].Value = model.SendContent;
parameters[4].Value = model.InputCode;
parameters[5].Value = model.WxSendTitle;
parameters[6].Value = model.CreateTime;
parameters[7].Value = model.CreateUser;
parameters[8].Value = model.WxSendType;
parameters[9].Value = model.WxSendClassId;
parameters[10].Value = model.WxPtId;
parameters[11].Value = model.Memo; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
