public bool ZoomSetDicCheckID() { if (null != _MParm.In_MDicCheck) { BLL.DSPTCH_DIC_CHECK BDicCheck = new BLL.DSPTCH_DIC_CHECK(); foreach (string[] item in _MParm.In_MDicCheck.Values) { Model.DSPTCH_DIC_CHECK MDicCheck = new CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK(); MDicCheck.AVR_CHECK_NAME = item[0]; MDicCheck.AVR_CHECK_NO = item[1]; MDicCheck.AVR_CHECK_TYPE = item[2]; MDicCheck.AVR_NEED_TIME = item[3]; MDicCheck.FK_VIEW_NO = item[4]; if (BDicCheck.Exists(MDicCheck.AVR_CHECK_NO) == false) { BDicCheck.Add(MDicCheck); } else { BDicCheck.Update(MDicCheck); } } return(true); } return(false); }
/// <summary> /// 获得数据列表 /// </summary> public List <CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK> GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM DSPTCH_DIC_CHECK "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds == null) { return(null); } List <CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK> lst_M = new List <CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK>(); foreach (DataRow row in ds.Tables[0].Rows) { CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK model = new CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK(); model.AVR_CHECK_NO = row["AVR_CHECK_NO"].ToString(); model.AVR_CHECK_NAME = row["AVR_CHECK_NAME"].ToString(); model.AVR_CHECK_TYPE = row["AVR_CHECK_TYPE"].ToString(); model.AVR_NEED_TIME = row["AVR_NEED_TIME"].ToString(); model.FK_VIEW_NO = row["FK_VIEW_NO"].ToString(); lst_M.Add(model); } return(lst_M); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DSPTCH_DIC_CHECK("); strSql.Append("AVR_CHECK_NO,AVR_CHECK_NAME,AVR_CHECK_TYPE,AVR_NEED_TIME,FK_VIEW_NO"); // strSql.Append(") values ("); strSql.Append("@AVR_CHECK_NO,@AVR_CHECK_NAME,@AVR_CHECK_TYPE,@AVR_NEED_TIME,@FK_VIEW_NO"); // strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@AVR_CHECK_NO", SqlDbType.Char, 32), new SqlParameter("@AVR_CHECK_NAME", SqlDbType.Char, 200), new SqlParameter("@AVR_CHECK_TYPE", SqlDbType.Char, 32), new SqlParameter("@AVR_NEED_TIME", SqlDbType.Char, 8), new SqlParameter("@FK_VIEW_NO", SqlDbType.Char, 32) }; parameters[0].Value = model.AVR_CHECK_NO; parameters[1].Value = model.AVR_CHECK_NAME; parameters[2].Value = model.AVR_CHECK_TYPE; parameters[3].Value = model.AVR_NEED_TIME; parameters[4].Value = model.FK_VIEW_NO; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK GetModel(string AVR_CHECK_NO) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AVR_CHECK_NO, AVR_CHECK_NAME, AVR_CHECK_TYPE, AVR_NEED_TIME, FK_VIEW_NO "); strSql.Append(" from DSPTCH_DIC_CHECK "); strSql.Append(" where AVR_CHECK_NO=@AVR_CHECK_NO "); SqlParameter[] parameters = { new SqlParameter("@AVR_CHECK_NO", SqlDbType.Char, 32) }; parameters[0].Value = AVR_CHECK_NO; CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK model = new CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.AVR_CHECK_NO = ds.Tables[0].Rows[0]["AVR_CHECK_NO"].ToString(); model.AVR_CHECK_NAME = ds.Tables[0].Rows[0]["AVR_CHECK_NAME"].ToString(); model.AVR_CHECK_TYPE = ds.Tables[0].Rows[0]["AVR_CHECK_TYPE"].ToString(); model.AVR_NEED_TIME = ds.Tables[0].Rows[0]["AVR_NEED_TIME"].ToString(); model.FK_VIEW_NO = ds.Tables[0].Rows[0]["FK_VIEW_NO"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(CLDC_Dispatcher.Model.DSPTCH_DIC_CHECK model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DSPTCH_DIC_CHECK set "); //strSql.Append(" AVR_CHECK_NO = @AVR_CHECK_NO , "); strSql.Append(" AVR_CHECK_NAME = @AVR_CHECK_NAME , "); strSql.Append(" AVR_CHECK_TYPE = @AVR_CHECK_TYPE , "); strSql.Append(" AVR_NEED_TIME = @AVR_NEED_TIME "); //strSql.Append(" FK_VIEW_NO = @FK_VIEW_NO "); strSql.Append(" where AVR_CHECK_NO = @AVR_CHECK_NO "); SqlParameter[] parameters = { new SqlParameter("@AVR_CHECK_NO", SqlDbType.Char, 32), new SqlParameter("@AVR_CHECK_NAME", SqlDbType.Char, 200), new SqlParameter("@AVR_CHECK_TYPE", SqlDbType.Char, 32), new SqlParameter("@AVR_NEED_TIME", SqlDbType.Char, 8), //new SqlParameter("@FK_VIEW_NO", SqlDbType.Char,32) }; parameters[0].Value = model.AVR_CHECK_NO; parameters[1].Value = model.AVR_CHECK_NAME; parameters[2].Value = model.AVR_CHECK_TYPE; parameters[3].Value = model.AVR_NEED_TIME; //parameters[4].Value = model.FK_VIEW_NO; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }