public string AddOf(MulaolaoLibrary.MaterialPurchaseCompariaseLibrary _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQAU ("); strSql.Append("AU001,AU002,AU003,AU004)"); strSql.Append(" VALUES ("); strSql.AppendFormat("'{0}','{1}','{2}','{3}')", _model.AU001, _model.AU002, _model.AU003, _model.AU004); return(strSql.ToString( )); }
public string UpdateOf(MulaolaoLibrary.MaterialPurchaseCompariaseLibrary _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQAU SET "); strSql.AppendFormat("AU002='{0}',", _model.AU002); strSql.AppendFormat("AU003='{0}',", _model.AU003); strSql.AppendFormat("AU004='{0}'", _model.AU004); strSql.AppendFormat(" WHERE AU001='{0}'", _model.AU001); return(strSql.ToString( )); }
/// <summary> /// 生成数据 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Generate(MulaolaoLibrary.MaterialPurchaseCompariaseLibrary _model, string year) { ArrayList SQLString = new ArrayList( ); DataTable da = new DataTable( ); da = GetDataTableOfCost(year.Substring(2, 2)); if (da != null && da.Rows.Count > 0) { _model.AU001 = "R_241"; _model.AU002 = string.IsNullOrEmpty(da.Rows[0]["U14"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[0]["U14"].ToString( )); _model.AU003 = string.IsNullOrEmpty(da.Rows[0]["U16"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[0]["U16"].ToString( )); _model.AU004 = string.IsNullOrEmpty(da.Rows[0]["U17"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[0]["U17"].ToString( )); if (Exists(_model.AU001)) { SQLString.Add(UpdateOf(_model)); } else { SQLString.Add(AddOf(_model)); } } else { return(false); } if (SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); _model.AU001 = "R_526"; _model.AU002 = _model.AU003 = 0; da = GetDataTableOfCount(year.Substring(2, 2)); if (da != null && da.Rows.Count > 0) { _model.AU003 = string.IsNullOrEmpty(da.Rows [0] ["R"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [0] ["R"].ToString( )); } da = GetDataTableOfY(year.Substring(2, 2)); if (da != null && da.Rows.Count > 0) { _model.AU002 = string.IsNullOrEmpty(da.Rows [0] ["R"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [0] ["R"].ToString( )); } _model.AU004 = _model.AU002 - _model.AU003; if (Exists(_model.AU001)) { SQLString.Add(UpdateOf(_model)); } else { SQLString.Add(AddOf(_model)); } } if (SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); GetDataTableOfPayMent(year.Substring(2, 2)); _model.AU001 = "R_231"; _model.AU002 = Convert.ToInt32(sumOne); _model.AU003 = Convert.ToInt32(sumTwo); _model.AU004 = _model.AU002 - _model.AU003; if (Exists(_model.AU001)) { SQLString.Add(UpdateOf(_model)); } else { SQLString.Add(AddOf(_model)); } } if (SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); GetDataTableOfPayMent323(year.Substring(2, 2)); _model.AU001 = "R_323"; _model.AU002 = Convert.ToInt32(sumOne); _model.AU003 = Convert.ToInt32(sumTwo); _model.AU004 = _model.AU002 - _model.AU003; if (Exists(_model.AU001)) { SQLString.Add(UpdateOf(_model)); } else { SQLString.Add(AddOf(_model)); } } if (SqlHelper.ExecuteSqlTran(SQLString)) { SQLString.Clear( ); GetDataTableOfPayMent243(year.Substring(2, 2)); _model.AU001 = "R_243"; _model.AU002 = Convert.ToInt32(sumOne); _model.AU003 = Convert.ToInt32(sumTwo); _model.AU004 = _model.AU002 - _model.AU003; if (Exists(_model.AU001)) { SQLString.Add(UpdateOf(_model)); } else { SQLString.Add(AddOf(_model)); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 生成数据 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Generate(MulaolaoLibrary.MaterialPurchaseCompariaseLibrary _model, string year) { return(_dao.Generate(_model, year)); }