public int Add(AlarmNumModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Sm_AlarmNum(");
builder.Append("said,scode,AlarmNum,settime,tcode,InfoCode)");
builder.Append(" values (");
builder.Append("@said,@scode,@AlarmNum,@settime,@tcode,@InfoCode)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@said", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.NVarChar, 0x40), new SqlParameter("@AlarmNum", SqlDbType.Decimal, 9), new SqlParameter("@settime", SqlDbType.SmallDateTime), new SqlParameter("@tcode", SqlDbType.NVarChar, 50), new SqlParameter("@InfoCode", SqlDbType.NVarChar, 10) };
commandParameters[0].Value = model.said;
commandParameters[1].Value = model.scode;
commandParameters[2].Value = model.AlarmNum;
commandParameters[3].Value = model.settime;
commandParameters[4].Value = model.tcode;
commandParameters[5].Value = model.InfoCode;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public AlarmNumModel GetModel(string scode, string tcode)
{
StringBuilder builder = new StringBuilder();
builder.Append("select said,scode,AlarmNum,settime,tcode,InfoCode from Sm_AlarmNum ");
builder.Append(" where scode=@scode and tcode=@tcode ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@scode", scode), new SqlParameter("@tcode", tcode) };
AlarmNumModel model = null;
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), commandParameters))
{
if (reader.Read())
{
model = this.ReaderBind(reader);
}
}
return(model);
}
public int Update(AlarmNumModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Sm_AlarmNum set ");
builder.Append("said=@said,");
builder.Append("AlarmNum=@AlarmNum,");
builder.Append("settime=@settime,");
builder.Append("InfoCode=@InfoCode");
builder.Append(" where scode=@scode and tcode=@tcode ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@said", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.NVarChar, 0x40), new SqlParameter("@AlarmNum", SqlDbType.Decimal, 9), new SqlParameter("@settime", SqlDbType.SmallDateTime), new SqlParameter("@tcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@InfoCode", SqlDbType.NVarChar, 10) };
commandParameters[0].Value = model.said;
commandParameters[1].Value = model.scode;
commandParameters[2].Value = model.AlarmNum;
commandParameters[3].Value = model.settime;
commandParameters[4].Value = model.tcode;
commandParameters[5].Value = model.InfoCode;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
protected void Add()
{
string[] array = JsonHelper.GetListFromJson(this.hfldResourceCode.Value).ToArray();
string[] array2 = array;
for (int i = 0; i < array2.Length; i++)
{
string text = array2[i];
AlarmNumModel alarmNumModel = new AlarmNumModel();
alarmNumModel.AlarmNum = 0m;
alarmNumModel.said = System.Guid.NewGuid().ToString();
alarmNumModel.scode = text.Replace("'", "");
alarmNumModel.settime = System.DateTime.Now;
alarmNumModel.InfoCode = "0";
alarmNumModel.tcode = base.Request.QueryString["tcode"];
if (this.alarmNumBll.GetModel(alarmNumModel.scode, alarmNumModel.tcode) == null && !string.IsNullOrEmpty(text))
{
this.alarmNumBll.Add(alarmNumModel);
}
}
}
public AlarmNumModel ReaderBind(IDataReader dataReader)
{
AlarmNumModel model = new AlarmNumModel {
said = dataReader["said"].ToString(),
scode = dataReader["scode"].ToString()
};
object obj2 = dataReader["AlarmNum"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.AlarmNum = (decimal)obj2;
}
obj2 = dataReader["settime"];
if ((obj2 != null) && (obj2 != DBNull.Value))
{
model.settime = (DateTime)obj2;
}
model.tcode = dataReader["tcode"].ToString();
model.InfoCode = dataReader["InfoCode"].ToString();
return(model);
}
public int Update(AlarmNumModel model)
{
return(this.dal.Update(model));
}
public int Add(AlarmNumModel model)
{
return(this.dal.Add(model));
}
