public bool Update(Model_SendSMSRecord model) { StringBuilder builder = new StringBuilder(); builder.Append("update SendSMSRecord set "); builder.Append("Mobile=@Mobile,"); builder.Append("Content=@Content,"); builder.Append("Status=@Status,"); builder.Append("SType=@SType,"); builder.Append("CTime=@CTime,"); builder.Append("ReturnContent=@ReturnContent,"); builder.Append("ReturnStatus=@ReturnStatus,"); builder.Append("SchoolId=@SchoolId"); builder.Append(" where SendSMSRecordId=@SendSMSRecordId "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Mobile", SqlDbType.VarChar, 50), new SqlParameter("@Content", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@Status", SqlDbType.NVarChar, 100), new SqlParameter("@SType", SqlDbType.VarChar, 50), new SqlParameter("@CTime", SqlDbType.DateTime), new SqlParameter("@ReturnContent", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@ReturnStatus", SqlDbType.VarChar, 100), new SqlParameter("@SchoolId", SqlDbType.VarChar, 50), new SqlParameter("@SendSMSRecordId", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.Mobile; cmdParms[1].Value = model.Content; cmdParms[2].Value = model.Status; cmdParms[3].Value = model.SType; cmdParms[4].Value = model.CTime; cmdParms[5].Value = model.ReturnContent; cmdParms[6].Value = model.ReturnStatus; cmdParms[7].Value = model.SchoolId; cmdParms[8].Value = model.SendSMSRecordId; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public Model_SendSMSRecord DataRowToModel(DataRow row) { Model_SendSMSRecord record = new Model_SendSMSRecord(); if (row != null) { if (row["SendSMSRecordId"] != null) { record.SendSMSRecordId = row["SendSMSRecordId"].ToString(); } if (row["Mobile"] != null) { record.Mobile = row["Mobile"].ToString(); } if (row["Content"] != null) { record.Content = row["Content"].ToString(); } if (row["Status"] != null) { record.Status = row["Status"].ToString(); } if (row["SType"] != null) { record.SType = row["SType"].ToString(); } if ((row["CTime"] != null) && (row["CTime"].ToString() != "")) { record.CTime = DateTime.Parse(row["CTime"].ToString()); } if (row["ReturnContent"] != null) { record.ReturnContent = row["ReturnContent"].ToString(); } if (row["ReturnStatus"] != null) { record.ReturnStatus = row["ReturnStatus"].ToString(); } if (row["SchoolId"] != null) { record.SchoolId = row["SchoolId"].ToString(); } } return(record); }
public List <Model_SendSMSRecord> DataTableToList(DataTable dt) { List <Model_SendSMSRecord> list = new List <Model_SendSMSRecord>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_SendSMSRecord item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Add(Model_SendSMSRecord model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SendSMSRecord("); builder.Append("SendSMSRecordId,Mobile,Content,Status,SType,CTime,ReturnContent,ReturnStatus,SchoolId)"); builder.Append(" values ("); builder.Append("@SendSMSRecordId,@Mobile,@Content,@Status,@SType,@CTime,@ReturnContent,@ReturnStatus,@SchoolId)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SendSMSRecordId", SqlDbType.Char, 0x24), new SqlParameter("@Mobile", SqlDbType.VarChar, 50), new SqlParameter("@Content", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@Status", SqlDbType.NVarChar, 100), new SqlParameter("@SType", SqlDbType.VarChar, 50), new SqlParameter("@CTime", SqlDbType.DateTime), new SqlParameter("@ReturnContent", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@ReturnStatus", SqlDbType.VarChar, 100), new SqlParameter("@SchoolId", SqlDbType.VarChar, 50) }; cmdParms[0].Value = model.SendSMSRecordId; cmdParms[1].Value = model.Mobile; cmdParms[2].Value = model.Content; cmdParms[3].Value = model.Status; cmdParms[4].Value = model.SType; cmdParms[5].Value = model.CTime; cmdParms[6].Value = model.ReturnContent; cmdParms[7].Value = model.ReturnStatus; cmdParms[8].Value = model.SchoolId; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Add(Model_SendSMSRecord model) { return(this.dal.Add(model)); }
public bool Update(Model_SendSMSRecord model) { return(this.dal.Update(model)); }