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));
}
