/// <summary> /// 更新一条数据 /// </summary> public bool Update(ShortMsgTempModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_ShortMessage_Template set "); strSql.Append("flag=@flag,"); strSql.Append("templateCode=@templateCode,"); strSql.Append("templateParam=@templateParam,"); strSql.Append("supplierId=@supplierId,"); strSql.Append("supplierFlag=@supplierFlag,"); strSql.Append("isUse=@isUse"); strSql.Append(" where templateId=@templateId"); SqlParameter[] parameters = { new SqlParameter("@templateId", SqlDbType.VarChar, 50), new SqlParameter("@flag", SqlDbType.NVarChar, 50), new SqlParameter("@templateCode", SqlDbType.NVarChar, 50), new SqlParameter("@templateParam", SqlDbType.NText), new SqlParameter("@supplierId", SqlDbType.VarChar, 50), new SqlParameter("@supplierFlag", SqlDbType.VarChar, 50), new SqlParameter("@isUse", SqlDbType.Int, 4) }; parameters[0].Value = model.templateId; parameters[1].Value = model.flag; parameters[2].Value = model.templateCode; parameters[3].Value = model.templateParam; parameters[4].Value = model.supplierId; parameters[5].Value = model.supplierFlag; parameters[6].Value = model.isUse; int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ShortMsgTempModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_ShortMessage_Template("); strSql.Append("templateId,flag,templateCode,templateParam,supplierId,supplierFlag,isUse)"); strSql.Append(" values ("); strSql.Append("@templateId,@flag,@templateCode,@templateParam,@supplierId,@supplierFlag,@isUse)"); SqlParameter[] parameters = { new SqlParameter("@templateId", SqlDbType.VarChar, 50), new SqlParameter("@flag", SqlDbType.NVarChar, 50), new SqlParameter("@templateCode", SqlDbType.NVarChar, 50), new SqlParameter("@templateParam", SqlDbType.NText), new SqlParameter("@supplierId", SqlDbType.VarChar, 50), new SqlParameter("@supplierFlag", SqlDbType.VarChar, 50), new SqlParameter("@isUse", SqlDbType.Int, 4) }; parameters[0].Value = model.templateId; parameters[1].Value = model.flag; parameters[2].Value = model.templateCode; parameters[3].Value = model.templateParam; parameters[4].Value = model.supplierId; parameters[5].Value = model.supplierFlag; parameters[6].Value = model.isUse; int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ShortMsgTempModel DataRowToModel(DataRow row) { ShortMsgTempModel model = new ShortMsgTempModel(); if (row != null) { if (row["templateId"] != null) { model.templateId = row["templateId"].ToString(); } if (row["flag"] != null) { model.flag = row["flag"].ToString(); } if (row["templateCode"] != null) { model.templateCode = row["templateCode"].ToString(); } if (row["templateParam"] != null) { model.templateParam = row["templateParam"].ToString(); } if (row["supplierId"] != null) { model.supplierId = row["supplierId"].ToString(); } if (row["supplierFlag"] != null) { model.supplierFlag = row["supplierFlag"].ToString(); } if (row["isUse"] != null && row["isUse"].ToString() != "") { model.isUse = int.Parse(row["isUse"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ShortMsgTempModel GetModel(string templateId) { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 templateId,flag,templateCode,templateParam,supplierId,supplierFlag,isUse from T_ShortMessage_Template "); strSql.Append(" where templateId=@templateId"); SqlParameter[] parameters = { new SqlParameter("@templateId", SqlDbType.VarChar, 50) }; parameters[0].Value = templateId; ShortMsgTempModel model = new ShortMsgTempModel(); DataSet ds = adoHelper.ExecuteSqlDataset(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 补充字段 /// </summary> /// <param name="SMS"></param> private static void FillFeild(this ShortMsgModel SMS) { ShortMsgSupBll supBll = new ShortMsgSupBll(); ShortMsgSupModel supMod = supBll.GetDefault(); if (supMod != null) //数据库没有数据 { List <ShortMsgTempModel> tmpList = supMod.tempList; SMS.smsSign = supMod.smsSign; SMS.supplier = supMod.flag; SMS.sysnumber = Guid.NewGuid().ToString(); SMS.statu = "sending"; SMS.accessKeyID = supMod.accessKeyID; SMS.accessKeySecret = supMod.accessKeySecret; //sms.flag 为 reg or login 注册登陆 ShortMsgTempModel tmpMod = tmpList.Find(a => a.isUse == 1 && a.flag == SMS.flag); if (tmpMod != null) { SMS.template = tmpMod.templateCode; SMS.templateParam = tmpMod.templateParam; } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ShortMsgTempModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ShortMsgTempModel model) { return(dal.Add(model)); }