/// <summary> /// 是否存在 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Exists(MulaolaoLibrary.OtherExpenseStatementLibrary _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("SELECT COUNT(1) FROM R_PQBE WHERE BE002=@BE002 AND BE007=@BE007 AND BE008=@BE008 AND BE009=@BE009 AND BE010=@BE010 AND BE011=@BE011 AND BE012=@BE012 AND BE016=@BE016"); SqlParameter [] parameter = { new SqlParameter("@BE002", SqlDbType.NVarChar, 20), new SqlParameter("@BE007", SqlDbType.Decimal, 11), new SqlParameter("@BE008", SqlDbType.Decimal, 11), new SqlParameter("@BE009", SqlDbType.Decimal, 11), new SqlParameter("@BE010", SqlDbType.Decimal, 11), new SqlParameter("@BE011", SqlDbType.Decimal, 11), new SqlParameter("@BE012", SqlDbType.Decimal, 11), new SqlParameter("@BE016", SqlDbType.NVarChar, 20) }; parameter [0].Value = _model.BE002; parameter [1].Value = _model.BE007; parameter [2].Value = _model.BE008; parameter [3].Value = _model.BE009; parameter [4].Value = _model.BE010; parameter [5].Value = _model.BE011; parameter [6].Value = _model.BE012; parameter [7].Value = _model.BE016; return(SqlHelper.Exists(strSql.ToString( ), parameter)); }
protected override void select( ) { base.select( ); _model = new MulaolaoLibrary.OtherExpenseStatementLibrary( ); SelectAll.OtherExpenseStatementAll query = new SelectAll.OtherExpenseStatementAll( ); if (query.ShowDialog( ) == DialogResult.OK) { _model.BE015 = query.getOdd; idxList = query.getAdd; autoQuery( ); } }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public int Insert(MulaolaoLibrary.OtherExpenseStatementLibrary _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQBE ("); strSql.Append("BE001,BE002,BE003,BE004,BE005,BE006,BE007,BE008,BE009,BE010,BE011,BE012,BE015,BE016,BE017)"); strSql.Append(" VALUES ("); strSql.Append("@BE001,@BE002,@BE003,@BE004,@BE005,@BE006,@BE007,@BE008,@BE009,@BE010,@BE011,@BE012,@BE015,@BE016,@BE017);"); strSql.Append("SELECT SCOPE_IDENTITY();"); SqlParameter [] parameter = { new SqlParameter("@BE001", SqlDbType.NVarChar, 20), new SqlParameter("@BE002", SqlDbType.NVarChar, 20), new SqlParameter("@BE003", SqlDbType.NVarChar, 20), new SqlParameter("@BE004", SqlDbType.NVarChar, 20), new SqlParameter("@BE005", SqlDbType.Int), new SqlParameter("@BE006", SqlDbType.NVarChar, 20), new SqlParameter("@BE007", SqlDbType.Decimal, 11), new SqlParameter("@BE008", SqlDbType.Decimal, 11), new SqlParameter("@BE009", SqlDbType.Decimal, 11), new SqlParameter("@BE010", SqlDbType.Decimal, 11), new SqlParameter("@BE011", SqlDbType.Decimal, 11), new SqlParameter("@BE012", SqlDbType.Decimal, 11), new SqlParameter("@BE015", SqlDbType.NVarChar, 20), new SqlParameter("@BE016", SqlDbType.NVarChar, 20), new SqlParameter("@BE017", SqlDbType.NVarChar, 200) }; parameter [0].Value = _model.BE001; parameter [1].Value = _model.BE002; parameter [2].Value = _model.BE003; parameter [3].Value = _model.BE004; parameter [4].Value = _model.BE005; parameter [5].Value = _model.BE006; parameter [6].Value = _model.BE007; parameter [7].Value = _model.BE008; parameter [8].Value = _model.BE009; parameter [9].Value = _model.BE010; parameter [10].Value = _model.BE011; parameter [11].Value = _model.BE012; parameter [12].Value = _model.BE015; parameter [13].Value = _model.BE016; parameter [14].Value = _model.BE017; return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter)); }
void build(MulaolaoLibrary.OtherExpenseStatementLibrary _model) { row["BE001"] = _model.BE001; row["BE002"] = _model.BE002; row["BE003"] = _model.BE003; row["BE004"] = _model.BE004; row["BE005"] = _model.BE005; row["BE006"] = _model.BE006; row["BE007"] = _model.BE007; row["BE008"] = _model.BE008; row["BE009"] = _model.BE009; row["BE010"] = _model.BE010; row["BE011"] = _model.BE011; row["BE012"] = _model.BE012; row["BE015"] = _model.BE015; row["BE016"] = _model.BE016; row["DGA003"] = comboBox1.Text; }
void assignMent( ) { _model = _bll.GetDataTable(_model.idx); if (_model == null) { return; } textBox1.Text = _model.BE001; textBox2.Text = _model.BE002; textBox3.Text = _model.BE003; textBox4.Text = _model.BE004; textBox5.Text = _model.BE005.ToString( ); textBox12.Text = _model.BE006; textBox6.Text = _model.BE007.ToString( ); textBox7.Text = _model.BE008.ToString( ); textBox8.Text = _model.BE009.ToString( ); textBox9.Text = _model.BE010.ToString( ); textBox10.Text = _model.BE011.ToString( ); textBox11.Text = _model.BE012.ToString( ); textBox13.Text = _model.BE017; changeIndex( ); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="row"></param> /// <returns></returns> public MulaolaoLibrary.OtherExpenseStatementLibrary GetModel(DataRow row) { MulaolaoLibrary.OtherExpenseStatementLibrary model = new MulaolaoLibrary.OtherExpenseStatementLibrary( ); if (row != null) { if (row["idx"] != null && row["idx"].ToString( ) != "") { model.idx = int.Parse(row["idx"].ToString( )); } if (row["BE001"] != null && row["BE001"].ToString( ) != "") { model.BE001 = row["BE001"].ToString( ); } if (row["BE002"] != null && row["BE002"].ToString( ) != "") { model.BE002 = row["BE002"].ToString( ); } if (row["BE003"] != null && row["BE003"].ToString( ) != "") { model.BE003 = row["BE003"].ToString( ); } if (row["BE004"] != null && row["BE004"].ToString( ) != "") { model.BE004 = row["BE004"].ToString( ); } if (row["BE005"] != null && row["BE005"].ToString( ) != "") { model.BE005 = int.Parse(row["BE005"].ToString( )); } if (row["BE006"] != null && row["BE006"].ToString( ) != "") { model.BE006 = row["BE006"].ToString( ); } if (row["BE007"] != null && row["BE007"].ToString( ) != "") { model.BE007 = decimal.Parse(row["BE007"].ToString( )); } if (row["BE008"] != null && row["BE008"].ToString( ) != "") { model.BE008 = decimal.Parse(row["BE008"].ToString( )); } if (row["BE009"] != null && row["BE009"].ToString( ) != "") { model.BE009 = decimal.Parse(row["BE009"].ToString( )); } if (row["BE010"] != null && row["BE010"].ToString( ) != "") { model.BE010 = decimal.Parse(row["BE010"].ToString( )); } if (row["BE011"] != null && row["BE011"].ToString( ) != "") { model.BE011 = decimal.Parse(row["BE011"].ToString( )); } if (row["BE012"] != null && row["BE012"].ToString( ) != "") { model.BE012 = decimal.Parse(row["BE012"].ToString( )); } if (row["BE015"] != null && row["BE015"].ToString( ) != "") { model.BE015 = row["BE015"].ToString( ); } if (row["BE016"] != null && row["BE016"].ToString( ) != "") { model.BE016 = row["BE016"].ToString( ); } if (row ["BE017"] != null && row ["BE017"].ToString( ) != "") { model.BE017 = row ["BE017"].ToString( ); } } return(model); }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Update(MulaolaoLibrary.OtherExpenseStatementLibrary _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQBE SET "); strSql.Append("BE002=@BE002,"); strSql.Append("BE003=@BE003,"); strSql.Append("BE004=@BE004,"); strSql.Append("BE005=@BE005,"); strSql.Append("BE006=@BE006,"); strSql.Append("BE007=@BE007,"); strSql.Append("BE008=@BE008,"); strSql.Append("BE009=@BE009,"); strSql.Append("BE010=@BE010,"); strSql.Append("BE011=@BE011,"); strSql.Append("BE012=@BE012,"); strSql.Append("BE001=@BE001,"); strSql.Append("BE016=@BE016,"); strSql.Append("BE017=@BE017 "); strSql.Append(" WHERE idx=@idx"); SqlParameter [] parameter = { new SqlParameter("@BE002", SqlDbType.NVarChar, 20), new SqlParameter("@BE003", SqlDbType.NVarChar, 20), new SqlParameter("@BE004", SqlDbType.NVarChar, 20), new SqlParameter("@BE005", SqlDbType.Int), new SqlParameter("@BE006", SqlDbType.NVarChar, 20), new SqlParameter("@BE007", SqlDbType.Decimal, 11), new SqlParameter("@BE008", SqlDbType.Decimal, 11), new SqlParameter("@BE009", SqlDbType.Decimal, 11), new SqlParameter("@BE010", SqlDbType.Decimal, 11), new SqlParameter("@BE011", SqlDbType.Decimal, 11), new SqlParameter("@BE012", SqlDbType.Decimal, 11), new SqlParameter("@BE001", SqlDbType.NVarChar, 20), new SqlParameter("@BE016", SqlDbType.NVarChar, 20), new SqlParameter("@BE017", SqlDbType.NVarChar, 200), new SqlParameter("@idx", SqlDbType.Int) }; parameter [0].Value = _model.BE002; parameter [1].Value = _model.BE003; parameter [2].Value = _model.BE004; parameter [3].Value = _model.BE005; parameter [4].Value = _model.BE006; parameter [5].Value = _model.BE007; parameter [6].Value = _model.BE008; parameter [7].Value = _model.BE009; parameter [8].Value = _model.BE010; parameter [9].Value = _model.BE011; parameter [10].Value = _model.BE012; parameter [11].Value = _model.BE001; parameter [12].Value = _model.BE016; parameter [13].Value = _model.BE017; parameter [14].Value = _model.idx; int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter); if (row > 0) { return(true); } else { return(false); } }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Update(MulaolaoLibrary.OtherExpenseStatementLibrary _model) { return(_dao.Update(_model)); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public int Insert(MulaolaoLibrary.OtherExpenseStatementLibrary _model) { return(_dao.Insert(_model)); }
/// <summary> /// 是否存在 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Exists(MulaolaoLibrary.OtherExpenseStatementLibrary _model) { return(_dao.Exists(_model)); }