/// <summary>
/// 删除一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Delete(MulaolaoLibrary.WagesContrastTableLibrary _model)
{
StringBuilder strSq = new StringBuilder( );
strSq.Append("DELETE FROM R_PQVZ");
strSq.Append(" WHERE VZ001=@VZ001 AND VZ002=@VZ002");
SqlParameter[] parameter =
{
new SqlParameter("@VZ001", SqlDbType.Int),
new SqlParameter("@VZ002", SqlDbType.Int)
};
parameter[0].Value = _model.VZ001;
parameter[1].Value = _model.VZ002;
int row = SqlHelper.ExecuteNonQuery(strSq.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public string EditNin(MulaolaoLibrary.WagesContrastTableLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQVZ SET ");
strSql.AppendFormat("VZ009={0}", _model.VZ009);
strSql.AppendFormat(" WHERE VZ001={0} AND VZ002={1} AND VZ003='{2}'", _model.VZ001, _model.VZ002, _model.VZ003);
return(strSql.ToString( ));
}
public string AddNin(MulaolaoLibrary.WagesContrastTableLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQVZ (");
strSql.Append("VZ001,VZ002,VZ003,VZ009)");
strSql.Append(" VALUES (");
strSql.AppendFormat("{0},{1},'{2}',{3})", _model.VZ001, _model.VZ002, _model.VZ003, _model.VZ009);
return(strSql.ToString( ));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public DataTable GetDataTable(MulaolaoLibrary.WagesContrastTableLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT * FROM R_PQVZ");
strSql.Append(" WHERE VZ001=@VZ001 AND VZ002=@VZ002");
SqlParameter[] parameter =
{
new SqlParameter("@VZ001", SqlDbType.Int),
new SqlParameter("@VZ002", SqlDbType.Int)
};
parameter[0].Value = _model.VZ001;
parameter[1].Value = _model.VZ002;
return(SqlHelper.ExecuteDataTable(strSql.ToString( ), parameter));
}
/// <summary>
/// 是否存在记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Exists(MulaolaoLibrary.WagesContrastTableLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) FROM R_PQVZ");
strSql.Append(" WHERE VZ001=@VZ001 AND VZ002=@VZ002 AND VZ003=@VZ003");
SqlParameter[] parameter =
{
new SqlParameter("@VZ001", SqlDbType.Int),
new SqlParameter("@VZ002", SqlDbType.Int),
new SqlParameter("@VZ003", SqlDbType.NChar, 20)
};
parameter[0].Value = _model.VZ001;
parameter[1].Value = _model.VZ002;
parameter[2].Value = _model.VZ003;
return(SqlHelper.Exists(strSql.ToString( ), parameter));
}
/// <summary>
/// 删除一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Delete(MulaolaoLibrary.WagesContrastTableLibrary _model)
{
return(_dao.Delete(_model));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public DataTable GetDataTable(MulaolaoLibrary.WagesContrastTableLibrary _model)
{
return(_dao.GetDataTable(_model));
}
/// <summary>
/// Generate
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Insert(MulaolaoLibrary.WagesContrastTableLibrary _model)
{
return(_dao.Insert(_model));
}
/// <summary>
/// Generate
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Insert(MulaolaoLibrary.WagesContrastTableLibrary _model)
{
bool result = false;
ArrayList SQLString = new ArrayList( );
DataTable tableOne = GetDataTableOne(_model.VZ001, _model.VZ002);
if (tableOne != null && tableOne.Rows.Count > 0)
{
_model.VZ003 = "R_317";
_model.VZ004 = string.IsNullOrEmpty(tableOne.Rows[0]["GZ1"].ToString( )) == true ? 0 : Convert.ToDecimal(tableOne.Rows[0]["GZ1"].ToString( ));
if (Exists(_model))
{
SQLString.Add(EditOne(_model));
}
else
{
SQLString.Add(AddOne(_model));
}
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable tableTwo = GetDataTableTwo(_model.VZ001, _model.VZ002);
if (tableTwo != null && tableTwo.Rows.Count > 0)
{
_model.VZ003 = "R_317";
_model.VZ005 = string.IsNullOrEmpty(tableTwo.Rows[0]["GZ1"].ToString( )) == true ? 0 : Convert.ToDecimal(tableTwo.Rows[0]["GZ1"].ToString( ));
_model.VZ006 = string.IsNullOrEmpty(tableTwo.Rows[0]["GZ2"].ToString( )) == true ? 0 : Convert.ToDecimal(tableTwo.Rows[0]["GZ2"].ToString( ));
if (Exists(_model))
{
SQLString.Add(EditTwo(_model));
}
else
{
SQLString.Add(AddTwo(_model));
}
}
}
else
{
result = false;
return(result);
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable tableTre = GetDataTableTre(_model.VZ001, _model.VZ002);
if (tableTre != null && tableTre.Rows.Count > 0)
{
_model.VZ003 = "R_317";
_model.VZ007 = string.IsNullOrEmpty(tableTre.Rows[0]["GZ3"].ToString( )) == true ? 0 : Convert.ToDecimal(tableTre.Rows[0]["GZ3"].ToString( ));
if (Exists(_model))
{
SQLString.Add(EditTre(_model));
}
else
{
SQLString.Add(AddTre(_model));
}
}
}
else
{
result = false;
return(result);
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable tableFor = GetDataTableFor(_model.VZ001, _model.VZ002);
if (tableFor != null && tableFor.Rows.Count > 0)
{
_model.VZ003 = "R_317";
_model.VZ008 = string.IsNullOrEmpty(tableFor.Rows[0]["GZ1"].ToString( )) == true ? 0 : Convert.ToDecimal(tableFor.Rows[0]["GZ1"].ToString( ));
_model.VZ009 = string.IsNullOrEmpty(tableFor.Rows[0]["GZ2"].ToString( )) == true ? 0 : Convert.ToDecimal(tableFor.Rows[0]["GZ2"].ToString( ));
if (Exists(_model))
{
SQLString.Add(EditFor(_model));
}
else
{
SQLString.Add(AddFor(_model));
}
}
}
else
{
result = false;
return(result);
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable tableFiv = GetDataTableFiv(_model.VZ001, _model.VZ002);
if (tableFiv != null && tableFiv.Rows.Count > 0)
{
_model.VZ003 = "R_323";
_model.VZ005 = string.IsNullOrEmpty(tableFiv.Rows[0]["GZ1"].ToString( )) == true ? 0 : Convert.ToDecimal(tableFiv.Rows[0]["GZ1"].ToString( ));
_model.VZ006 = string.IsNullOrEmpty(tableFiv.Rows[0]["GZ2"].ToString( )) == true ? 0 : Convert.ToDecimal(tableFiv.Rows[0]["GZ2"].ToString( ));
if (Exists(_model))
{
SQLString.Add(EditFiv(_model));
}
else
{
SQLString.Add(AddFiv(_model));
}
}
}
else
{
result = false;
return(result);
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable tableSix = GetDataTableSix(_model.VZ001, _model.VZ002);
if (tableSix != null && tableSix.Rows.Count > 0)
{
_model.VZ003 = "R_323";
_model.VZ008 = string.IsNullOrEmpty(tableSix.Rows[0]["GZ1"].ToString( )) == true ? 0 : Convert.ToDecimal(tableSix.Rows[0]["GZ1"].ToString( ));
_model.VZ009 = string.IsNullOrEmpty(tableSix.Rows[0]["GZ2"].ToString( )) == true ? 0 : Convert.ToDecimal(tableSix.Rows[0]["GZ2"].ToString( ));
if (Exists(_model))
{
SQLString.Add(EditSix(_model));
}
else
{
SQLString.Add(AddSix(_model));
}
}
}
else
{
result = false;
return(result);
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable tableSev = GetDataTableSev(_model.VZ001, _model.VZ002);
if (tableSev != null && tableSev.Rows.Count > 0)
{
_model.VZ003 = "R_324";
//_model.VZ004 = string.IsNullOrEmpty( tableSev.Rows[0]["GZ1"].ToString( ) ) == true ? 0 : Convert.ToDecimal( tableSev.Rows[0]["GZ1"].ToString( ) );
//_model.VZ005 = string.IsNullOrEmpty( tableSev.Rows[0]["GZ2"].ToString( ) ) == true ? 0 : Convert.ToDecimal( tableSev.Rows[0]["GZ2"].ToString( ) );
//_model.VZ006 = string.IsNullOrEmpty( tableSev.Rows[0]["GZ3"].ToString( ) ) == true ? 0 : Convert.ToInt32( tableSev.Rows[0]["GZ3"].ToString( ) );
_model.VZ007 = string.IsNullOrEmpty(tableSev.Rows[0]["GZ4"].ToString( )) == true ? 0 : Convert.ToDecimal(tableSev.Rows[0]["GZ4"].ToString( ));
//_model.VZ008 = string.IsNullOrEmpty( tableSev.Rows[0]["GZ5"].ToString( ) ) == true ? 0 : Convert.ToDecimal( tableSev.Rows[0]["GZ5"].ToString( ) );
//_model.VZ009 = string.IsNullOrEmpty( tableSev.Rows[0]["GZ6"].ToString( ) ) == true ? 0 : Convert.ToInt32( tableSev.Rows[0]["GZ6"].ToString( ) );
if (Exists(_model))
{
SQLString.Add(EditSev(_model));
}
else
{
SQLString.Add(AddSev(_model));
}
}
}
else
{
result = false;
return(result);
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable tableSevS = GetDataTableSevS(_model.VZ001, _model.VZ002);
if (tableSevS != null && tableSevS.Rows.Count > 0)
{
_model.VZ003 = "R_324";
_model.VZ004 = string.IsNullOrEmpty(tableSevS.Rows [0] ["GZ1"].ToString( )) == true ? 0 : Convert.ToDecimal(tableSevS.Rows [0] ["GZ1"].ToString( ));
_model.VZ005 = string.IsNullOrEmpty(tableSevS.Rows [0] ["GZ2"].ToString( )) == true ? 0 : Convert.ToDecimal(tableSevS.Rows [0] ["GZ2"].ToString( ));
_model.VZ006 = string.IsNullOrEmpty(tableSevS.Rows [0] ["GZ3"].ToString( )) == true ? 0 : Convert.ToDecimal(tableSevS.Rows [0] ["GZ3"].ToString( ));
_model.VZ008 = string.IsNullOrEmpty(tableSevS.Rows [0] ["GZ5"].ToString( )) == true ? 0 : Convert.ToDecimal(tableSevS.Rows [0] ["GZ5"].ToString( ));
_model.VZ009 = string.IsNullOrEmpty(tableSevS.Rows [0] ["GZ6"].ToString( )) == true ? 0 : Convert.ToDecimal(tableSevS.Rows [0] ["GZ6"].ToString( ));
if (Exists(_model))
{
SQLString.Add(EditSevS(_model));
}
else
{
SQLString.Add(AddSevS(_model));
}
}
}
else
{
result = false;
return(result);
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable tableEgi = GetDataTableEgi(_model.VZ001, _model.VZ002);
if (tableEgi != null && tableEgi.Rows.Count > 0)
{
_model.VZ003 = "R_325";
_model.VZ006 = string.IsNullOrEmpty(tableEgi.Rows[0]["UZ"].ToString( )) == true ? 0 : Convert.ToDecimal(tableEgi.Rows[0]["UZ"].ToString( ));
if (Exists(_model))
{
SQLString.Add(EditEgi(_model));
}
else
{
SQLString.Add(AddEgi(_model));
}
}
}
else
{
result = false;
return(result);
}
if (SQLString != null && SqlHelper.ExecuteSqlTran(SQLString))
{
result = true;
SQLString = new ArrayList( );
DataTable tableNin = GetDataTableNin(_model.VZ001, _model.VZ002);
if (tableNin != null && tableNin.Rows.Count > 0)
{
_model.VZ003 = "R_325";
_model.VZ009 = string.IsNullOrEmpty(tableNin.Rows[0]["UZ"].ToString( )) == true ? 0 : Convert.ToDecimal(tableNin.Rows[0]["UZ"].ToString( ));
if (Exists(_model))
{
SQLString.Add(EditNin(_model));
}
else
{
SQLString.Add(AddNin(_model));
}
}
}
else
{
result = false;
return(result);
}
result = SqlHelper.ExecuteSqlTran(SQLString);
return(result);
}
