/// <summary>
/// 是否存在
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Exists(MulaolaoLibrary.ManagePayrollLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) FROM R_PQXZ");
strSql.Append(" WHERE XZ001=@XZ001 AND XZ014=@XZ014 AND XZ002=@XZ002 AND XZ003=@XZ003 AND XZ004=@XZ004");
SqlParameter[] parameter =
{
new SqlParameter("@XZ001", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ002", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ003", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ004", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ014", SqlDbType.NVarChar, 20)
};
parameter[0].Value = _model.XZ001;
parameter[1].Value = _model.XZ002;
parameter[2].Value = _model.XZ003;
parameter[3].Value = _model.XZ004;
parameter[4].Value = _model.XZ014;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
protected override void select( )
{
base.select( );
_model = new MulaolaoLibrary.ManagePayrollLibrary( );
SelectAll.ManagePayrollAll query = new SelectAll.ManagePayrollAll( );
query.PassDataBetweenForm += new SelectAll.ManagePayrollAll.PassDataBetweenFormHandler(query_PassDataBetweenForm);
query.StartPosition = FormStartPosition.CenterScreen;
query.ShowDialog( );
if (_model.XZ001 != null)
{
autoQuery( );
}
}
/// <summary>
/// 编辑一单记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Update(MulaolaoLibrary.ManagePayrollLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQXZ SET ");
strSql.Append("XZ013=@XZ013,");
strSql.Append("XZ015=@XZ015,");
strSql.Append("XZ016=@XZ016,");
strSql.Append("XZ017=@XZ017,");
strSql.Append("XZ018=@XZ018,");
strSql.Append("XZ019=@XZ019,");
strSql.Append("XZ020=@XZ020");
strSql.Append(" WHERE XZ001=@XZ001");
SqlParameter [] parameter =
{
new SqlParameter("@XZ015", SqlDbType.NVarChar, 2000),
new SqlParameter("@XZ016", SqlDbType.NVarChar, 255),
new SqlParameter("@XZ017", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ018", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ019", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ020", SqlDbType.Date),
new SqlParameter("@XZ001", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ013", SqlDbType.Date)
};
parameter [0].Value = _model.XZ015;
parameter [1].Value = _model.XZ016;
parameter [2].Value = _model.XZ017;
parameter [3].Value = _model.XZ018;
parameter [4].Value = _model.XZ019;
parameter [5].Value = _model.XZ020;
parameter [6].Value = _model.XZ001;
parameter [7].Value = _model.XZ013;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
void queryContent( )
{
_model = _bll.GetModel(_model.XZ001);
if (_model == null)
{
return;
}
textBox9.Text = _model.XZ017;
textBox10.Text = _model.XZ018;
textBox11.Text = _model.XZ019;
if (_model.XZ020 > DateTime.MinValue && _model.XZ020 < DateTime.MaxValue)
{
dateTimePicker2.Value = _model.XZ020;
}
if (_model.XZ013 > DateTime.MinValue && _model.XZ013 < DateTime.MaxValue)
{
dateTimePicker1.Value = _model.XZ013;
}
textBox8.Text = _model.XZ016;
strWhere = "1=1";
strWhere = strWhere + " AND XZ001='" + _model.XZ001 + "'";
button4_Click(null, null);
}
void assignMent( )
{
_model = _bll.GetModel(_model.IDX);
if (_model == null)
{
return;
}
lookUpEdit2.Text = _model.XZ002;
comboBox2.Text = _model.XZ003;
lookUpEdit4.Text = _model.XZ004;
textBox1.Text = _model.XZ005.ToString( );
textBox2.Text = _model.XZ006.ToString( );
textBox3.Text = _model.XZ007.ToString( );
textBox4.Text = _model.XZ008.ToString( );
textBox5.Text = _model.XZ009.ToString( );
textBox6.Text = _model.XZ010.ToString( );
textBox7.Text = _model.XZ011.ToString( );
if (_model.XZ013 > DateTime.MinValue && _model.XZ013 < DateTime.MaxValue)
{
dateTimePicker1.Value = _model.XZ013;
}
textBox12.Text = _model.XZ021.ToString( );
textBox13.Text = _model.XZ023.ToString( );
textBox14.Text = _model.XZ024.ToString( );
comboBox1.Text = _model.XZ014;
textBox15.Text = _model.XZ027;
textBox16.Text = _model.XZ028;
textBox17.Text = _model.XZ029.ToString( );
textBox18.Text = _model.XZ030.ToString("f2");
textBox19.Text = _model.XZ031.ToString("f2");
checkBox1.Checked = _model.XZ032;
category = comboBox1.Text;
personInCharge = lookUpEdit2.Text;
company = comboBox2.Text;
names = lookUpEdit4.Text;
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Updates(MulaolaoLibrary.ManagePayrollLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQXZ SET ");
strSql.Append("XZ002=@XZ002,");
strSql.Append("XZ003=@XZ003,");
strSql.Append("XZ004=@XZ004,");
strSql.Append("XZ005=@XZ005,");
strSql.Append("XZ006=@XZ006,");
strSql.Append("XZ007=@XZ007,");
strSql.Append("XZ008=@XZ008,");
strSql.Append("XZ009=@XZ009,");
strSql.Append("XZ010=@XZ010,");
strSql.Append("XZ011=@XZ011,");
strSql.Append("XZ012=@XZ012,");
strSql.Append("XZ013=@XZ013,");
strSql.Append("XZ014=@XZ014,");
strSql.Append("XZ021=@XZ021,");
strSql.Append("XZ023=@XZ023,");
strSql.Append("XZ024=@XZ024,");
strSql.Append("XZ027=@XZ027,");
strSql.Append("XZ028=@XZ028,");
strSql.Append("XZ029=@XZ029,");
strSql.Append("XZ030=@XZ030,");
strSql.Append("XZ031=@XZ031,");
strSql.Append("XZ032=@XZ032 ");
strSql.Append(" WHERE idx=@idx");
SqlParameter [] parameter =
{
new SqlParameter("@XZ002", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ003", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ004", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ005", SqlDbType.Decimal, 8),
new SqlParameter("@XZ006", SqlDbType.Decimal, 5),
new SqlParameter("@XZ007", SqlDbType.Decimal, 5),
new SqlParameter("@XZ008", SqlDbType.Decimal, 6),
new SqlParameter("@XZ009", SqlDbType.Decimal, 6),
new SqlParameter("@XZ010", SqlDbType.Decimal, 6),
new SqlParameter("@XZ011", SqlDbType.Decimal, 6),
new SqlParameter("@XZ012", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ013", SqlDbType.Date),
new SqlParameter("@XZ014", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ021", SqlDbType.Decimal, 7),
new SqlParameter("@XZ023", SqlDbType.Decimal, 7),
new SqlParameter("@XZ024", SqlDbType.Decimal, 7),
new SqlParameter("@XZ027", SqlDbType.NVarChar, 100),
new SqlParameter("@XZ028", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ029", SqlDbType.Decimal, 7),
new SqlParameter("@XZ030", SqlDbType.Decimal, 18),
new SqlParameter("@XZ031", SqlDbType.Decimal, 18),
new SqlParameter("@XZ032", SqlDbType.Bit),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter [0].Value = _model.XZ002;
parameter [1].Value = _model.XZ003;
parameter [2].Value = _model.XZ004;
parameter [3].Value = _model.XZ005;
parameter [4].Value = _model.XZ006;
parameter [5].Value = _model.XZ007;
parameter [6].Value = _model.XZ008;
parameter [7].Value = _model.XZ009;
parameter [8].Value = _model.XZ010;
parameter [9].Value = _model.XZ011;
parameter [10].Value = _model.XZ012;
parameter [11].Value = _model.XZ013;
parameter [12].Value = _model.XZ014;
parameter [13].Value = _model.XZ021;
parameter [14].Value = _model.XZ023;
parameter [15].Value = _model.XZ024;
parameter [16].Value = _model.XZ027;
parameter [17].Value = _model.XZ028;
parameter [18].Value = _model.XZ029;
parameter [19].Value = _model.XZ030;
parameter [20].Value = _model.XZ031;
parameter [21].Value = _model.XZ032;
parameter [22].Value = _model.IDX;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取数据集
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public MulaolaoLibrary.ManagePayrollLibrary GetDataRow(DataRow row)
{
MulaolaoLibrary.ManagePayrollLibrary _model = new MulaolaoLibrary.ManagePayrollLibrary( );
if (row != null)
{
if (row["idx"] != null && row["idx"].ToString( ) != "")
{
_model.IDX = int.Parse(row["idx"].ToString( ));
}
if (row["XZ001"] != null && row["XZ001"].ToString( ) != "")
{
_model.XZ001 = row["XZ001"].ToString( );
}
if (row["XZ002"] != null && row["XZ002"].ToString( ) != "")
{
_model.XZ002 = row["XZ002"].ToString( );
}
if (row["XZ003"] != null && row["XZ003"].ToString( ) != "")
{
_model.XZ003 = row["XZ003"].ToString( );
}
if (row["XZ004"] != null && row["XZ004"].ToString( ) != "")
{
_model.XZ004 = row["XZ004"].ToString( );
}
if (row["XZ005"] != null && row["XZ005"].ToString( ) != "")
{
_model.XZ005 = decimal.Parse(row["XZ005"].ToString( ));
}
if (row["XZ006"] != null && row["XZ006"].ToString( ) != "")
{
_model.XZ006 = decimal.Parse(row["XZ006"].ToString( ));
}
if (row["XZ007"] != null && row["XZ007"].ToString( ) != "")
{
_model.XZ007 = decimal.Parse(row["XZ007"].ToString( ));
}
if (row["XZ008"] != null && row["XZ008"].ToString( ) != "")
{
_model.XZ008 = decimal.Parse(row["XZ008"].ToString( ));
}
if (row["XZ009"] != null && row["XZ009"].ToString( ) != "")
{
_model.XZ009 = decimal.Parse(row["XZ009"].ToString( ));
}
if (row["XZ010"] != null && row["XZ010"].ToString( ) != "")
{
_model.XZ010 = decimal.Parse(row["XZ010"].ToString( ));
}
if (row["XZ011"] != null && row["XZ011"].ToString( ) != "")
{
_model.XZ011 = decimal.Parse(row["XZ011"].ToString( ));
}
if (row["XZ012"] != null && row["XZ012"].ToString( ) != "")
{
_model.XZ012 = row["XZ012"].ToString( );
}
if (row["XZ013"] != null && row["XZ013"].ToString( ) != "")
{
_model.XZ013 = DateTime.Parse(row["XZ013"].ToString( ));
}
if (row["XZ014"] != null && row["XZ014"].ToString( ) != "")
{
_model.XZ014 = row["XZ014"].ToString( );
}
if (row["XZ015"] != null && row["XZ015"].ToString( ) != "")
{
_model.XZ015 = row["XZ015"].ToString( );
}
if (row["XZ016"] != null && row["XZ016"].ToString( ) != "")
{
_model.XZ016 = row["XZ016"].ToString( );
}
if (row["XZ017"] != null && row["XZ017"].ToString( ) != "")
{
_model.XZ017 = row["XZ017"].ToString( );
}
if (row["XZ018"] != null && row["XZ018"].ToString( ) != "")
{
_model.XZ018 = row["XZ018"].ToString( );
}
if (row["XZ019"] != null && row["XZ019"].ToString( ) != "")
{
_model.XZ019 = row["XZ019"].ToString( );
}
if (row["XZ020"] != null && row["XZ020"].ToString( ) != "")
{
_model.XZ020 = DateTime.Parse(row["XZ020"].ToString( ));
}
if (row["XZ021"] != null && row["XZ021"].ToString( ) != "")
{
_model.XZ021 = decimal.Parse(row["XZ021"].ToString( ));
}
if (row["XZ023"] != null && row["XZ023"].ToString( ) != "")
{
_model.XZ023 = decimal.Parse(row["XZ023"].ToString( ));
}
if (row["XZ024"] != null && row["XZ024"].ToString( ) != "")
{
_model.XZ024 = decimal.Parse(row["XZ024"].ToString( ));
}
if (row["XZ027"] != null && row["XZ027"].ToString( ) != "")
{
_model.XZ027 = row["XZ027"].ToString( );
}
if (row["XZ028"] != null && row["XZ028"].ToString( ) != "")
{
_model.XZ028 = row["XZ028"].ToString( );
}
if (row ["XZ029"] != null && row ["XZ029"].ToString( ) != "")
{
_model.XZ029 = decimal.Parse(row ["XZ029"].ToString( ));
}
if (row ["XZ030"] != null && row ["XZ030"].ToString( ) != "")
{
_model.XZ030 = decimal.Parse(row ["XZ030"].ToString( ));
}
if (row ["XZ031"] != null && row ["XZ031"].ToString( ) != "")
{
_model.XZ031 = decimal.Parse(row ["XZ031"].ToString( ));
}
if (row ["XZ032"] != null && row ["XZ032"].ToString( ) != "")
{
_model.XZ032 = bool.Parse(row ["XZ032"].ToString( ));
}
}
return(_model);
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int Add(MulaolaoLibrary.ManagePayrollLibrary _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQXZ (");
strSql.Append("XZ001,XZ002,XZ003,XZ004,XZ005,XZ006,XZ007,XZ008,XZ009,XZ010,XZ011,XZ012,XZ013,XZ014,XZ021,XZ023,XZ024,XZ027,XZ028,XZ029,XZ030,XZ031,XZ032)");
strSql.Append(" VALUES (");
strSql.Append("@XZ001,@XZ002,@XZ003,@XZ004,@XZ005,@XZ006,@XZ007,@XZ008,@XZ009,@XZ010,@XZ011,@XZ012,@XZ013,@XZ014,@XZ021,@XZ024,@XZ024,@XZ027,@XZ028,@XZ029,@XZ030,@XZ031,@XZ032);");
strSql.Append("SELECT SCOPE_IDENTITY();");
SqlParameter [] parameter =
{
new SqlParameter("@XZ001", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ002", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ003", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ004", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ005", SqlDbType.Decimal, 8),
new SqlParameter("@XZ006", SqlDbType.Decimal, 5),
new SqlParameter("@XZ007", SqlDbType.Decimal, 5),
new SqlParameter("@XZ008", SqlDbType.Decimal, 6),
new SqlParameter("@XZ009", SqlDbType.Decimal, 6),
new SqlParameter("@XZ010", SqlDbType.Decimal, 6),
new SqlParameter("@XZ011", SqlDbType.Decimal, 6),
new SqlParameter("@XZ012", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ013", SqlDbType.Date),
new SqlParameter("@XZ014", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ021", SqlDbType.Decimal, 7),
new SqlParameter("@XZ023", SqlDbType.Decimal, 7),
new SqlParameter("@XZ024", SqlDbType.Decimal, 7),
new SqlParameter("@XZ027", SqlDbType.NVarChar, 100),
new SqlParameter("@XZ028", SqlDbType.NVarChar, 20),
new SqlParameter("@XZ029", SqlDbType.Decimal, 7),
new SqlParameter("@XZ030", SqlDbType.Decimal, 18),
new SqlParameter("@XZ031", SqlDbType.Decimal, 18),
new SqlParameter("@XZ032", SqlDbType.Decimal, 18)
};
parameter [0].Value = _model.XZ001;
parameter [1].Value = _model.XZ002;
parameter [2].Value = _model.XZ003;
parameter [3].Value = _model.XZ004;
parameter [4].Value = _model.XZ005;
parameter [5].Value = _model.XZ006;
parameter [6].Value = _model.XZ007;
parameter [7].Value = _model.XZ008;
parameter [8].Value = _model.XZ009;
parameter [9].Value = _model.XZ010;
parameter [10].Value = _model.XZ011;
parameter [11].Value = _model.XZ012;
parameter [12].Value = _model.XZ013;
parameter [13].Value = _model.XZ014;
parameter [14].Value = _model.XZ021;
parameter [15].Value = _model.XZ023;
parameter [16].Value = _model.XZ024;
parameter [17].Value = _model.XZ027;
parameter [18].Value = _model.XZ028;
parameter [19].Value = _model.XZ029;
parameter [20].Value = _model.XZ030;
parameter [21].Value = _model.XZ031;
parameter [22].Value = _model.XZ032;
return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int Add(MulaolaoLibrary.ManagePayrollLibrary _model)
{
return(_dao.Add(_model));
}
/// <summary>
/// 是否存在
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Exists(MulaolaoLibrary.ManagePayrollLibrary _model)
{
return(_dao.Exists(_model));
}
/// <summary>
/// 编辑一单记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Update(MulaolaoLibrary.ManagePayrollLibrary _model)
{
return(_dao.Update(_model));
}
