void Edit(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.ContCheckTableEntity _model) { strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQEA SET "); strSql.Append("EA003=@EA003,"); strSql.Append("EA004=@EA004,"); strSql.Append("EA005=@EA005 "); strSql.Append(" WHERE EA001=@EA001"); strSql.Append(" AND EA002=@EA002"); SqlParameter [] parameter = { new SqlParameter("@EA001", SqlDbType.NVarChar, 50), new SqlParameter("@EA002", SqlDbType.NVarChar, 255), new SqlParameter("@EA003", SqlDbType.Date), new SqlParameter("@EA004", SqlDbType.Bit), new SqlParameter("@EA005", SqlDbType.Bit) }; parameter [0].Value = _model.EA001; parameter [1].Value = _model.EA002; parameter [2].Value = _model.EA003; parameter [3].Value = _model.EA004; parameter [4].Value = _model.EA005; SQLString.Add(strSql, parameter); }
/// <summary> /// 保存数据 /// </summary> /// <param name="table"></param> /// <returns></returns> public bool Update(DataTable table) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); if (table != null && table.Rows.Count > 0) { MulaolaoLibrary.ContCheckTableEntity _model = new MulaolaoLibrary.ContCheckTableEntity( ); for (int i = 0; i < table.Rows.Count; i++) { _model.EA001 = table.Rows [i] ["CP03"].ToString( ); _model.EA002 = table.Rows [i] ["CP01"].ToString( ); if (string.IsNullOrEmpty(table.Rows [i] ["RES04"].ToString( ))) { _model.EA003 = null; } else { _model.EA003 = Convert.ToDateTime(table.Rows [i] ["RES04"].ToString( )); } _model.EA004 = string.IsNullOrEmpty(table.Rows [i] ["AK"].ToString( )) == true ? false : (table.Rows [i] ["AK"].ToString( ).Equals("已结") ? true : false); _model.EA005 = string.IsNullOrEmpty(table.Rows [i] ["EA005"].ToString( )) == true ? false : true; if (!Exists(_model)) { Add(SQLString, strSql, _model); } else { Edit(SQLString, strSql, _model); } } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
bool Exists(MulaolaoLibrary.ContCheckTableEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("SELECT COUNT(1) FROM R_PQEA WHERE EA001='{0}' AND EA002='{1}'", _model.EA001, _model.EA002); return(SqlHelper.Exists(strSql.ToString( ))); }
public FormContCheckTable( ) { InitializeComponent( ); GridViewMoHuSelect.SetFilter(gridView1); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 }); MulaolaoBll.UserInfoMation.tableName = this.Name; GridViewMoHuSelect.SetFilter(gridView1); _bll = new MulaolaoBll.Bll.ContCheckTablBll( ); _model = new MulaolaoLibrary.ContCheckTableEntity( ); toolAdd.Text = "查询全部"; }
/// <summary> /// 删除数据 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Delete(MulaolaoLibrary.ContCheckTableEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("DELETE FROM R_PQEA WHERE EA001='{0}' AND EA002='{1}'", _model.EA001, _model.EA002); int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( )); if (rows > 0) { return(true); } else { return(false); } }
void Add(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.ContCheckTableEntity _model) { strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQEA ("); strSql.Append("EA001,EA002,EA003,EA004,EA005) "); strSql.Append("VALUES ("); strSql.Append("@EA001,@EA002,@EA003,@EA004,@EA005)"); SqlParameter [] parameter = { new SqlParameter("@EA001", SqlDbType.NVarChar, 50), new SqlParameter("@EA002", SqlDbType.NVarChar, 255), new SqlParameter("@EA003", SqlDbType.Date), new SqlParameter("@EA004", SqlDbType.Bit), new SqlParameter("@EA005", SqlDbType.Bit) }; parameter [0].Value = _model.EA001; parameter [1].Value = _model.EA002; parameter [2].Value = _model.EA003; parameter [3].Value = _model.EA004; parameter [4].Value = _model.EA005; SQLString.Add(strSql, parameter); }
/// <summary> /// 删除数据 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Delete(MulaolaoLibrary.ContCheckTableEntity _model) { return(_dal.Delete(_model)); }