/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Update(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQRZ SET ");
strSql.Append("RZ002=@RZ002,");
strSql.Append("RZ006=@RZ006");
strSql.Append(" WHERE RZ001=@RZ001");
SqlParameter[] parameter =
{
new SqlParameter("@RZ002", SqlDbType.Decimal, 6),
new SqlParameter("@RZ006", SqlDbType.Decimal, 6),
new SqlParameter("@RZ001", SqlDbType.Int)
};
parameter[0].Value = _model.RZ002;
parameter[1].Value = _model.RZ006;
parameter[2].Value = _model.RZ001;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public string AddTwo(MulaolaoLibrary.ContractUncollectUnpaid _model, string column)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQRZ (");
if (column.Equals("RZ016"))
{
strSql.Append("RZ001,RZ003,RZ016,RZ018)");
strSql.Append(" VALUES (");
strSql.AppendFormat("{0},{1},{2},{3})", _model.RZ001, _model.RZ003, _model.RZ016, _model.RZ018);
}
else if (column.Equals("RZ017"))
{
strSql.Append("RZ001,RZ003,RZ017,RZ018)");
strSql.Append(" VALUES (");
strSql.AppendFormat("{0},{1},{2},{3})", _model.RZ001, _model.RZ003, _model.RZ017, _model.RZ018);
}
else if (column.Equals("RZ019"))
{
strSql.Append("RZ001,RZ003,RZ018,RZ019)");
strSql.Append(" VALUES (");
strSql.AppendFormat("{0},{1},{2},{3})", _model.RZ001, _model.RZ003, _model.RZ018, _model.RZ019);
}
return(strSql.ToString( ));
}
/// <summary>
/// 录入一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Insert(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQRZ (");
strSql.Append("RZ001,RZ002)");
strSql.Append(" VALUES (");
strSql.Append("@RZ001,@RZ002);");
SqlParameter[] parameter =
{
new SqlParameter("@RZ001", SqlDbType.Int),
new SqlParameter("@RZ002", SqlDbType.Decimal, 6)
};
parameter[0].Value = _model.RZ001;
parameter[1].Value = _model.RZ002;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateOther(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQRZ SET ");
strSql.Append("RZ005=@RZ005,");
strSql.Append("RZ008=@RZ008,");
strSql.Append("RZ016=@RZ016,");
strSql.Append("RZ017=@RZ017");
strSql.Append(" WHERE idx=@idx");
SqlParameter[] parameter =
{
new SqlParameter("@RZ005", SqlDbType.Int),
new SqlParameter("@RZ008", SqlDbType.Int),
new SqlParameter("@RZ016", SqlDbType.Int),
new SqlParameter("@RZ017", SqlDbType.Int),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter[0].Value = _model.RZ005;
parameter[1].Value = _model.RZ008;
parameter[2].Value = _model.RZ016;
parameter[3].Value = _model.RZ017;
parameter[4].Value = _model.IDX;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public string UpdateFor(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQRZ SET ");
strSql.AppendFormat("RZ004={0}", _model.RZ004);
strSql.AppendFormat(" WHERE RZ001={0} AND RZ003={1}", _model.RZ001, _model.RZ003);
return(strSql.ToString( ));
}
public string AddFor(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQRZ (");
strSql.Append("RZ001,RZ003,RZ004)");
strSql.Append(" VALUES (");
strSql.AppendFormat("{0},{1},{2})", _model.RZ001, _model.RZ003, _model.RZ004);
return(strSql.ToString( ));
}
public string AddOne(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQRZ (");
strSql.Append("RZ001,RZ003,RZ009,RZ010,RZ011,RZ012,RZ013,RZ014,RZ015,RZ020,RZ021,RZ022,RZ023,RZ024)");
strSql.Append(" VALUES (");
strSql.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13})", _model.RZ001, _model.RZ003, _model.RZ009, _model.RZ010, _model.RZ011, _model.RZ012, _model.RZ013, _model.RZ014, _model.RZ015, _model.RZ020, _model.RZ021, _model.RZ022, _model.RZ023, _model.RZ024);
return(strSql.ToString( ));
}
void assign( )
{
_model = _bll.GetModel(_model.IDX);
if (!string.IsNullOrEmpty(_model.RZ001.ToString( )) && !string.IsNullOrEmpty(_model.RZ003.ToString( )))
{
dateTimePicker1.Value = Convert.ToDateTime(_model.RZ001 + "年" + _model.RZ003 + "月" + "01日");
}
textBox1.Text = _model.RZ002.ToString( );
textBox2.Text = _model.RZ006.ToString( );
textBox3.Text = _model.RZ005.ToString( );
textBox4.Text = _model.RZ008.ToString( );
textBox5.Text = _model.RZ016.ToString( );
textBox6.Text = _model.RZ017.ToString( );
}
/// <summary>
/// 获取数据集
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public MulaolaoLibrary.ContractUncollectUnpaid GetDataRow(DataRow row)
{
MulaolaoLibrary.ContractUncollectUnpaid _model = new MulaolaoLibrary.ContractUncollectUnpaid( );
if (row != null)
{
if (row["idx"] != null && row["idx"].ToString( ) != "")
{
_model.IDX = int.Parse(row["idx"].ToString( ));
}
if (row["RZ001"] != null && row["RZ001"].ToString( ) != "")
{
_model.RZ001 = int.Parse(row["RZ001"].ToString( ));
}
if (row["RZ002"] != null && row["RZ002"].ToString( ) != "")
{
_model.RZ002 = decimal.Parse(row["RZ002"].ToString( ));
}
if (row["RZ003"] != null && row["RZ003"].ToString( ) != "")
{
_model.RZ003 = int.Parse(row["RZ003"].ToString( ));
}
if (row["RZ005"] != null && row["RZ005"].ToString( ) != "")
{
_model.RZ005 = int.Parse(row["RZ005"].ToString( ));
}
if (row["RZ006"] != null && row["RZ006"].ToString( ) != "")
{
_model.RZ006 = decimal.Parse(row["RZ006"].ToString( ));
}
if (row["RZ008"] != null && row["RZ008"].ToString( ) != "")
{
_model.RZ008 = int.Parse(row["RZ008"].ToString( ));
}
if (row["RZ016"] != null && row["RZ016"].ToString( ) != "")
{
_model.RZ016 = int.Parse(row["RZ016"].ToString( ));
}
if (row["RZ017"] != null && row["RZ017"].ToString( ) != "")
{
_model.RZ017 = int.Parse(row["RZ017"].ToString( ));
}
}
return(_model);
}
public string UpdateOne(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQRZ SET ");
strSql.AppendFormat("RZ009={0},", _model.RZ009);
strSql.AppendFormat("RZ010={0},", _model.RZ010);
strSql.AppendFormat("RZ011={0},", _model.RZ011);
strSql.AppendFormat("RZ012={0},", _model.RZ012);
strSql.AppendFormat("RZ013={0},", _model.RZ013);
strSql.AppendFormat("RZ014={0},", _model.RZ014);
strSql.AppendFormat("RZ015={0},", _model.RZ015);
strSql.AppendFormat("RZ020={0},", _model.RZ020);
strSql.AppendFormat("RZ021={0},", _model.RZ021);
strSql.AppendFormat("RZ022={0},", _model.RZ022);
strSql.AppendFormat("RZ023={0},", _model.RZ023);
strSql.AppendFormat("RZ024={0}", _model.RZ024);
strSql.AppendFormat(" WHERE RZ001={0} AND RZ003={1}", _model.RZ001, _model.RZ003);
return(strSql.ToString( ));
}
public string UpdateTwo(MulaolaoLibrary.ContractUncollectUnpaid _model, string column)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQRZ SET ");
if (column.Equals("RZ016"))
{
strSql.AppendFormat("RZ016={0},", _model.RZ016);
}
else if (column.Equals("RZ017"))
{
strSql.AppendFormat("RZ017={0},", _model.RZ017);
}
else if (column.Equals("RZ019"))
{
strSql.AppendFormat("RZ019={0},", _model.RZ019);
}
strSql.AppendFormat("RZ018={0} ", _model.RZ018);
strSql.AppendFormat(" WHERE RZ001={0} AND RZ003={1}", _model.RZ001, _model.RZ003);
return(strSql.ToString( ));
}
/// <summary>
/// Generate
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Add(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
ArrayList SQLString = new ArrayList( );
bool result = false;
DataTable da = GetDataTableOne(_model.RZ001);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
_model.RZ003 = string.IsNullOrEmpty(da.Rows[i]["AE14"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[i]["AE14"].ToString( ));
_model.RZ009 = string.IsNullOrEmpty(da.Rows[i]["AE06"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[i]["AE06"].ToString( ));
_model.RZ010 = string.IsNullOrEmpty(da.Rows[i]["AE19"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[i]["AE19"].ToString( ));
_model.RZ011 = string.IsNullOrEmpty(da.Rows[i]["AE37"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[i]["AE37"].ToString( ));
_model.RZ012 = string.IsNullOrEmpty(da.Rows[i]["AE3"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[i]["AE3"].ToString( ));
_model.RZ013 = string.IsNullOrEmpty(da.Rows[i]["AE26"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[i]["AE26"].ToString( ));
_model.RZ014 = string.IsNullOrEmpty(da.Rows[i]["AE2"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[i]["AE2"].ToString( ));
_model.RZ015 = string.IsNullOrEmpty(da.Rows[i]["AE28"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[i]["AE28"].ToString( ));
_model.RZ020 = _model.RZ010 - (string.IsNullOrEmpty(da.Rows [i] ["AE8"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["AE8"].ToString( )));
_model.RZ021 = (string.IsNullOrEmpty(da.Rows [i] ["U12"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["U12"].ToString( )));
_model.RZ022 = (string.IsNullOrEmpty(da.Rows [i] ["U13"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["U13"].ToString( )));
_model.RZ023 = string.IsNullOrEmpty(da.Rows [i] ["AE610"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["AE610"].ToString( ));
_model.RZ024 = string.IsNullOrEmpty(da.Rows [i] ["AE611"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["AE611"].ToString( ));
if (Exists(_model.RZ001, _model.RZ003))
{
SQLString.Add(UpdateOne(_model));
}
else
{
SQLString.Add(AddOne(_model));
}
}
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
da = GetDataTableOneOther(_model.RZ001);
if (da != null && da.Rows.Count > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
_model.RZ003 = string.IsNullOrEmpty(da.Rows [i] ["AE14"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["AE14"].ToString( ));
_model.RZ010 = string.IsNullOrEmpty(da.Rows [i] ["AE19"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["AE19"].ToString( ));
_model.RZ015 = string.IsNullOrEmpty(da.Rows [i] ["AE28"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["AE28"].ToString( ));
_model.RZ020 = _model.RZ010 - (string.IsNullOrEmpty(da.Rows [i] ["AE8"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["AE8"].ToString( )));
_model.RZ021 = (string.IsNullOrEmpty(da.Rows [i] ["U12"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["U12"].ToString( )));
_model.RZ022 = (string.IsNullOrEmpty(da.Rows [i] ["U13"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["U13"].ToString( )));
if (Exists(_model.RZ001, _model.RZ003))
{
SQLString.Add(UpdateOneOther(_model));
}
}
}
}
else
{
return(false);
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable de = GetDataTableTwo(_model.RZ001);
if (de != null && de.Rows.Count > 0)
{
for (int i = 0; i < de.Rows.Count; i++)
{
_model.RZ003 = string.IsNullOrEmpty(de.Rows[i]["monthP"].ToString( )) == true ? 0 : Convert.ToInt32(de.Rows[i]["monthP"].ToString( ));
int x = string.IsNullOrEmpty(de.Rows[i]["yearP"].ToString( )) == true ? 0 : Convert.ToInt32(de.Rows[i]["yearP"].ToString( ));
if (x == _model.RZ001 - 2)
{
_model.RZ016 = string.IsNullOrEmpty(de.Rows [i] ["QZ021"].ToString( )) == true ? 0 : Convert.ToInt32(de.Rows [i] ["QZ021"].ToString( ));
//if ( x == _model.RZ001 - 1 )
// _model.RZ017 = string.IsNullOrEmpty( de.Rows[i]["QZ021"].ToString( ) ) == true ? 0 : Convert.ToInt32( de.Rows[i]["QZ021"].ToString( ) );
//else
// _model.RZ017 = 0;
_model.RZ018 = 0;
//_model.RZ019 = string.IsNullOrEmpty( de.Rows[i]["QZ021"].ToString( ) ) == true ? 0 : Convert.ToInt32( de.Rows[i]["QZ021"].ToString( ) );
if (Exists(_model.RZ001, _model.RZ003))
{
SQLString.Add(UpdateTwo(_model, "RZ016"));
}
else
{
SQLString.Add(AddTwo(_model, "RZ016"));
}
}
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString = new ArrayList( );
for (int i = 0; i < de.Rows.Count; i++)
{
_model.RZ003 = string.IsNullOrEmpty(de.Rows [i] ["monthP"].ToString( )) == true ? 0 : Convert.ToInt32(de.Rows [i] ["monthP"].ToString( ));
int x = string.IsNullOrEmpty(de.Rows [i] ["yearP"].ToString( )) == true ? 0 : Convert.ToInt32(de.Rows [i] ["yearP"].ToString( ));
//if ( x == _model . RZ001 - 2 )
// _model . RZ016 = string . IsNullOrEmpty ( de . Rows [ i ] [ "QZ021" ] . ToString ( ) ) == true ? 0 : Convert . ToInt32 ( de . Rows [ i ] [ "QZ021" ] . ToString ( ) );
//else
// _model . RZ016 = 0;
if (x == _model.RZ001 - 1)
{
_model.RZ017 = string.IsNullOrEmpty(de.Rows [i] ["QZ021"].ToString( )) == true ? 0 : Convert.ToInt32(de.Rows [i] ["QZ021"].ToString( ));
_model.RZ018 = 0;
//_model . RZ019 = string . IsNullOrEmpty ( de . Rows [ i ] [ "QZ021" ] . ToString ( ) ) == true ? 0 : Convert . ToInt32 ( de . Rows [ i ] [ "QZ021" ] . ToString ( ) );
if (Exists(_model.RZ001, _model.RZ003))
{
SQLString.Add(UpdateTwo(_model, "RZ017"));
}
else
{
SQLString.Add(AddTwo(_model, "RZ017"));
}
}
}
}
else
{
return(false);
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString = new ArrayList( );
for (int i = 0; i < de.Rows.Count; i++)
{
_model.RZ003 = string.IsNullOrEmpty(de.Rows [i] ["monthP"].ToString( )) == true ? 0 : Convert.ToInt32(de.Rows [i] ["monthP"].ToString( ));
//int x = string . IsNullOrEmpty ( de . Rows [ i ] [ "yearP" ] . ToString ( ) ) == true ? 0 : Convert . ToInt32 ( de . Rows [ i ] [ "yearP" ] . ToString ( ) );
//if ( x == _model . RZ001 - 2 )
// _model . RZ016 = string . IsNullOrEmpty ( de . Rows [ i ] [ "QZ021" ] . ToString ( ) ) == true ? 0 : Convert . ToInt32 ( de . Rows [ i ] [ "QZ021" ] . ToString ( ) );
//else
// _model . RZ016 = 0;
//if ( x == _model . RZ001 - 1 )
// _model . RZ017 = string . IsNullOrEmpty ( de . Rows [ i ] [ "QZ021" ] . ToString ( ) ) == true ? 0 : Convert . ToInt32 ( de . Rows [ i ] [ "QZ021" ] . ToString ( ) );
//else
// _model . RZ017 = 0;
_model.RZ018 = 0;
_model.RZ019 = string.IsNullOrEmpty(de.Rows [i] ["QZ021"].ToString( )) == true ? 0 : Convert.ToInt32(de.Rows [i] ["QZ021"].ToString( ));
if (Exists(_model.RZ001, _model.RZ003))
{
SQLString.Add(UpdateTwo(_model, "RZ019"));
}
else
{
SQLString.Add(AddTwo(_model, "RZ019"));
}
}
}
else
{
return(false);
}
}
}
else
{
result = false;
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable dl = GetDataTableTre(_model.RZ001);
if (dl != null && dl.Rows.Count > 0)
{
for (int i = 0; i < dl.Rows.Count; i++)
{
_model.RZ003 = string.IsNullOrEmpty(dl.Rows[i]["GZ24"].ToString( )) == true ? 0 : Convert.ToInt32(dl.Rows[i]["GZ24"].ToString( ));
_model.RZ007 = string.IsNullOrEmpty(dl.Rows[i]["GZ"].ToString( )) == true ? 0 : Convert.ToInt32(dl.Rows[i]["GZ"].ToString( ));
if (Exists(_model.RZ001, _model.RZ003))
{
SQLString.Add(UpdateTre(_model));
}
else
{
SQLString.Add(AddTre(_model));
}
}
}
}
else
{
result = false;
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable dk = GetDataTableFor(_model.RZ001);
if (dk != null && dk.Rows.Count > 0)
{
_model.RZ003 = 3;
_model.RZ004 = string.IsNullOrEmpty(dk.Rows[0]["AC"].ToString( )) == true ? 0 : Convert.ToInt32(dk.Rows[0]["AC"].ToString( ));
if (Exists(_model.RZ001, _model.RZ003))
{
SQLString.Add(UpdateFor(_model));
}
else
{
SQLString.Add(AddFor(_model));
}
}
}
result = SqlHelper.ExecuteSqlTran(SQLString);
return(result);
}
/// <summary>
/// Generate
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Add(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
return(_dao.Add(_model));
}
/// <summary>
/// 录入一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Insert(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
return(_dao.Insert(_model));
}
public bool UpdateOther(MulaolaoLibrary.ContractUncollectUnpaid _model)
{
return(_dao.UpdateOther(_model));
}
