/// <summary> /// 更新一条数据 /// </summary> public bool Update(CLDC_Dispatcher.Model.DSPTCH_TASKS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DSPTCH_TASKS set "); //strSql.Append(" TASK_NO = @TASK_NO , "); //strSql.Append(" AVR_DEVICE_ID = @AVR_DEVICE_ID , "); //strSql.Append(" AVR_END_FLAG = @AVR_END_FLAG , "); //strSql.Append(" AVR_START_TIME = @AVR_START_TIME , "); //strSql.Append(" AVR_END_TIME = @AVR_END_TIME , "); strSql.Append(" AVR_HANDLE_FLAG = @AVR_HANDLE_FLAG , "); //strSql.Append(" AVR_SCHEME_ID = @AVR_SCHEME_ID , "); strSql.Append(" AVR_WRITE_TIME = @AVR_WRITE_TIME "); strSql.Append(" where AVR_DEVICE_ID = @AVR_DEVICE_ID and AVR_END_FLAG='0'"); SqlParameter[] parameters = { //new SqlParameter("@ID", SqlDbType.Int,4) , //new SqlParameter("@TASK_NO", SqlDbType.Char,32) , new SqlParameter("@AVR_DEVICE_ID", SqlDbType.Char, 32), //new SqlParameter("@AVR_END_FLAG", SqlDbType.Char,8) , //new SqlParameter("@AVR_START_TIME", SqlDbType.Char,32) , //new SqlParameter("@AVR_END_TIME", SqlDbType.Char,32) , new SqlParameter("@AVR_HANDLE_FLAG", SqlDbType.Char, 8), //new SqlParameter("@AVR_SCHEME_ID", SqlDbType.Char,32) , new SqlParameter("@AVR_WRITE_TIME", SqlDbType.Char, 32) }; //parameters[0].Value = model.ID; //parameters[1].Value = model.TASK_NO; //parameters[2].Value = model.AVR_DEVICE_ID; //parameters[3].Value = model.AVR_END_FLAG; //parameters[4].Value = model.AVR_START_TIME; //parameters[5].Value = model.AVR_END_TIME; //parameters[6].Value = model.AVR_HANDLE_FLAG; //parameters[7].Value = model.AVR_SCHEME_ID; //parameters[8].Value = model.AVR_WRITE_TIME; parameters[0].Value = model.AVR_DEVICE_ID; parameters[1].Value = model.AVR_HANDLE_FLAG; parameters[2].Value = model.AVR_WRITE_TIME; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool SetTaskFlagError() { Model.DSPTCH_TASKS Mtask = new CLDC_Dispatcher.Model.DSPTCH_TASKS(); Mtask.AVR_DEVICE_ID = _EquipNo; Mtask.AVR_HANDLE_FLAG = "9"; Mtask.AVR_WRITE_TIME = DateTime.Now.ToString(_DateFormateStr); BLL.DSPTCH_TASKS Btask = new CLDC_Dispatcher.BLL.DSPTCH_TASKS(); if (Btask.Exists(_EquipNo)) { Btask.Update(Mtask); } return(true); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CLDC_Dispatcher.Model.DSPTCH_TASKS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DSPTCH_TASKS("); strSql.Append("TASK_NO,AVR_DEVICE_ID,AVR_END_FLAG,AVR_START_TIME,AVR_END_TIME,AVR_HANDLE_FLAG,AVR_SCHEME_ID,AVR_WRITE_TIME"); strSql.Append(") values ("); strSql.Append("@TASK_NO,@AVR_DEVICE_ID,@AVR_END_FLAG,@AVR_START_TIME,@AVR_END_TIME,@AVR_HANDLE_FLAG,@AVR_SCHEME_ID,@AVR_WRITE_TIME"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@TASK_NO", SqlDbType.Char, 32), new SqlParameter("@AVR_DEVICE_ID", SqlDbType.Char, 32), new SqlParameter("@AVR_END_FLAG", SqlDbType.Char, 8), new SqlParameter("@AVR_START_TIME", SqlDbType.Char, 32), new SqlParameter("@AVR_END_TIME", SqlDbType.Char, 32), new SqlParameter("@AVR_HANDLE_FLAG", SqlDbType.Char, 8), new SqlParameter("@AVR_SCHEME_ID", SqlDbType.Char, 32), new SqlParameter("@AVR_WRITE_TIME", SqlDbType.Char, 32) }; parameters[0].Value = model.TASK_NO; parameters[1].Value = model.AVR_DEVICE_ID; parameters[2].Value = model.AVR_END_FLAG; parameters[3].Value = model.AVR_START_TIME; parameters[4].Value = model.AVR_END_TIME; parameters[5].Value = model.AVR_HANDLE_FLAG; parameters[6].Value = model.AVR_SCHEME_ID; parameters[7].Value = model.AVR_WRITE_TIME; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获得数据列表 /// </summary> public List <CLDC_Dispatcher.Model.DSPTCH_TASKS> GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM DSPTCH_TASKS "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds == null) { return(null); } List <CLDC_Dispatcher.Model.DSPTCH_TASKS> lst_M = new List <CLDC_Dispatcher.Model.DSPTCH_TASKS>(); foreach (DataRow row in ds.Tables[0].Rows) { CLDC_Dispatcher.Model.DSPTCH_TASKS model = new CLDC_Dispatcher.Model.DSPTCH_TASKS(); if (row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } model.TASK_NO = row["TASK_NO"].ToString(); model.AVR_DEVICE_ID = row["AVR_DEVICE_ID"].ToString(); model.AVR_END_FLAG = row["AVR_END_FLAG"].ToString(); model.AVR_START_TIME = row["AVR_START_TIME"].ToString(); model.AVR_END_TIME = row["AVR_END_TIME"].ToString(); model.AVR_HANDLE_FLAG = row["AVR_HANDLE_FLAG"].ToString(); model.AVR_SCHEME_ID = row["AVR_SCHEME_ID"].ToString(); model.AVR_WRITE_TIME = row["AVR_WRITE_TIME"].ToString(); lst_M.Add(model); } return(lst_M); }
/// <summary> /// 得到一个对象实体 /// </summary> public CLDC_Dispatcher.Model.DSPTCH_TASKS GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, TASK_NO, AVR_DEVICE_ID, AVR_END_FLAG, AVR_START_TIME, AVR_END_TIME, AVR_HANDLE_FLAG, AVR_SCHEME_ID, AVR_WRITE_TIME "); strSql.Append(" from DSPTCH_TASKS "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; CLDC_Dispatcher.Model.DSPTCH_TASKS model = new CLDC_Dispatcher.Model.DSPTCH_TASKS(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.TASK_NO = ds.Tables[0].Rows[0]["TASK_NO"].ToString(); model.AVR_DEVICE_ID = ds.Tables[0].Rows[0]["AVR_DEVICE_ID"].ToString(); model.AVR_END_FLAG = ds.Tables[0].Rows[0]["AVR_END_FLAG"].ToString(); model.AVR_START_TIME = ds.Tables[0].Rows[0]["AVR_START_TIME"].ToString(); model.AVR_END_TIME = ds.Tables[0].Rows[0]["AVR_END_TIME"].ToString(); model.AVR_HANDLE_FLAG = ds.Tables[0].Rows[0]["AVR_HANDLE_FLAG"].ToString(); model.AVR_SCHEME_ID = ds.Tables[0].Rows[0]["AVR_SCHEME_ID"].ToString(); model.AVR_WRITE_TIME = ds.Tables[0].Rows[0]["AVR_WRITE_TIME"].ToString(); return(model); } else { return(null); } }