public Rain.Model.sms_template DataRowToModel(DataRow row)
{
Rain.Model.sms_template smsTemplate = new Rain.Model.sms_template();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
smsTemplate.id = int.Parse(row["id"].ToString());
}
if (row["title"] != null)
{
smsTemplate.title = row["title"].ToString();
}
if (row["call_index"] != null)
{
smsTemplate.call_index = row["call_index"].ToString();
}
if (row["content"] != null)
{
smsTemplate.content = row["content"].ToString();
}
if (row["is_sys"] != null && row["is_sys"].ToString() != "")
{
smsTemplate.is_sys = int.Parse(row["is_sys"].ToString());
}
}
return(smsTemplate);
}
public bool Update(Rain.Model.sms_template model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update " + this.databaseprefix + "sms_template set ");
stringBuilder.Append("title=@title,");
stringBuilder.Append("call_index=@call_index,");
stringBuilder.Append("content=@content,");
stringBuilder.Append("is_sys=@is_sys");
stringBuilder.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[5]
{
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@call_index", OleDbType.VarChar, 50),
new OleDbParameter("@content", (object)SqlDbType.NText),
new OleDbParameter("@is_sys", OleDbType.Integer, 4),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)model.title;
oleDbParameterArray[1].Value = (object)model.call_index;
oleDbParameterArray[2].Value = (object)model.content;
oleDbParameterArray[3].Value = (object)model.is_sys;
oleDbParameterArray[4].Value = (object)model.id;
return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0);
}
private bool DoAdd()
{
Rain.Model.sms_template model = new Rain.Model.sms_template();
Rain.BLL.sms_template smsTemplate = new Rain.BLL.sms_template();
model.title = this.txtTitle.Text.Trim();
model.call_index = this.txtCallIndex.Text.Trim();
model.content = this.txtContent.Text;
if (smsTemplate.Add(model) <= 0)
{
return(false);
}
this.AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加短信模板:" + model.title);
return(true);
}
private bool DoEdit(int _id)
{
bool flag = false;
Rain.BLL.sms_template smsTemplate = new Rain.BLL.sms_template();
Rain.Model.sms_template model = smsTemplate.GetModel(_id);
model.title = this.txtTitle.Text.Trim();
model.call_index = this.txtCallIndex.Text.Trim();
model.content = this.txtContent.Text;
if (smsTemplate.Update(model))
{
this.AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改短信模板:" + model.title);
flag = true;
}
return(flag);
}
public int Add(Rain.Model.sms_template model)
{
int maxId;
using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString))
{
oleDbConnection.Open();
using (OleDbTransaction trans = oleDbConnection.BeginTransaction())
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into " + this.databaseprefix + "sms_template(");
stringBuilder.Append("title,call_index,content,is_sys)");
stringBuilder.Append(" values (");
stringBuilder.Append("@title,@call_index,@content,@is_sys)");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[4]
{
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@call_index", OleDbType.VarChar, 50),
new OleDbParameter("@content", (object)SqlDbType.NText),
new OleDbParameter("@is_sys", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)model.title;
oleDbParameterArray[1].Value = (object)model.call_index;
oleDbParameterArray[2].Value = (object)model.content;
oleDbParameterArray[3].Value = (object)model.is_sys;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder.ToString(), oleDbParameterArray);
maxId = this.GetMaxId(oleDbConnection, trans);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(maxId);
}
public bool Update(Rain.Model.sms_template model)
{
return(this.dal.Update(model));
}
public int Add(Rain.Model.sms_template model)
{
return(this.dal.Add(model));
}
