void assignMent( )
{
model = bll.GetModel(model.IDX);
comboBox1.Text = model.LZ015;
textBox12.Text = model.LZ016;
comboBox2.Text = model.LZ017;
textBox11.Text = model.LZ018;
textBox13.Text = model.LZ019;
textBox14.Text = model.LZ020.ToString( );
textBox19.Text = model.LZ021.ToString( );
textBox20.Text = model.LZ022.ToString( );
//textBox15.Text = model.LZ025.ToString( );
//textBox21.Text = model.LZ024.ToString( );
textBox16.Text = model.LZ023.ToString( );
textBox22.Text = model.LZ026.ToString( );
textBox17.Text = model.LZ029;
textBox18.Text = model.LZ031;
textBox15.Text = model.LZ033;
textBox21.Text = model.LZ034.ToString( );
comboBox3.Text = model.LZ035;
partName = comboBox1.Text;
product = comboBox2.Text;
wages = textBox11.Text;
colorNum = textBox13.Text;
brand = textBox18.Text;
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(MulaolaoLibrary.GunQiChengLanJiaGongLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQLZ ("); //LZ025,
strSql.Append("LZ001,LZ002,LZ006,LZ015,LZ016,LZ017,LZ018,LZ019,LZ020,LZ021,LZ022,LZ023,LZ024,LZ026,LZ029,LZ031,LZ032,LZ033,LZ034,LZ035)");
strSql.Append(" VALUES ("); //@LZ025,
strSql.Append("@LZ001,@LZ002,@LZ006,@LZ015,@LZ016,@LZ017,@LZ018,@LZ019,@LZ020,@LZ021,@LZ022,@LZ023,@LZ024,@LZ026,@LZ029,@LZ031,@LZ032,@LZ033,@LZ034,@LZ035);");
strSql.Append("SELECT SCOPE_IDENTITY();");
SqlParameter[] parameter =
{
new SqlParameter("@LZ001", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ015", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ016", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ017", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ018", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ019", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ020", SqlDbType.Decimal, 1),
new SqlParameter("@LZ021", SqlDbType.Int),
new SqlParameter("@LZ022", SqlDbType.Decimal, 7),
//new SqlParameter("@LZ025",SqlDbType.Decimal,6),
new SqlParameter("@LZ024", SqlDbType.Decimal, 6),
new SqlParameter("@LZ023", SqlDbType.Decimal, 6),
new SqlParameter("@LZ026", SqlDbType.Int),
new SqlParameter("@LZ006", SqlDbType.BigInt),
new SqlParameter("@LZ029", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ002", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ031", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ032", SqlDbType.Decimal, 4),
new SqlParameter("@LZ033", SqlDbType.NVarChar, 255),
new SqlParameter("@LZ034", SqlDbType.Decimal, 6),
new SqlParameter("@LZ035", SqlDbType.NVarChar, 4)
};
parameter[0].Value = model.LZ001;
parameter[1].Value = model.LZ015;
parameter[2].Value = model.LZ016;
parameter[3].Value = model.LZ017;
parameter[4].Value = model.LZ018;
parameter[5].Value = model.LZ019;
parameter[6].Value = model.LZ020;
parameter[7].Value = model.LZ021;
parameter[8].Value = model.LZ022;
//parameter[9].Value = model.LZ025;
parameter[9].Value = model.LZ024;
parameter[10].Value = model.LZ023;
parameter[11].Value = model.LZ026;
parameter[12].Value = model.LZ006;
parameter[13].Value = model.LZ029;
parameter[14].Value = model.LZ002;
parameter[15].Value = model.LZ031;
parameter[16].Value = model.LZ032;
parameter[17].Value = model.LZ033;
parameter[18].Value = model.LZ034;
parameter[19].Value = model.LZ035;
int row = SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter);
return(row);
}
protected override void select( )
{
base.select( );
model = new MulaolaoLibrary.GunQiChengLanJiaGongLibrary( );
SelectAll.GunQiChengLanAll query = new SelectAll.GunQiChengLanAll( );
query.StartPosition = FormStartPosition.CenterScreen;
query.PassDataBetweenForm += new SelectAll.GunQiChengLanAll.PassDataBetweenFormHandler(query_PassDataBetweenForm);
query.ShowDialog( );
if (model.LZ001 != null && model.LZ001 != "")
{
autoQuery( );
}
else
{
MessageBox.Show("您没有选择任何内容");
}
}
void queryContent( )
{
model = bll.GetModel(model.LZ001);
textBox1.Text = model.LZ002;
textBox2.Text = model.LZ003;
textBox4.Text = model.LZ004;
textBox3.Text = model.LZ005;
textBox5.Text = model.LZ006.ToString( );
if (model.LZ007 != null && model.LZ007 > DateTime.MinValue && model.LZ007 < DateTime.MaxValue)
{
dateTimePicker1.Value = model.LZ007;
}
if (model.LZ008 != null && model.LZ008 > DateTime.MinValue && model.LZ008 < DateTime.MaxValue)
{
dateTimePicker2.Value = model.LZ008;
}
textBox17.Text = model.LZ029;
textBox6.Text = model.LZ009;
if (model.LZ010 != null && model.LZ010 > DateTime.MinValue && model.LZ010 < DateTime.MaxValue)
{
dateTimePicker3.Value = model.LZ010;
}
textBox7.Text = model.LZ011;
if (model.LZ012 != null && model.LZ012 > DateTime.MinValue && model.LZ012 < DateTime.MaxValue)
{
dateTimePicker4.Value = model.LZ012;
}
textBox9.Text = model.LZ013;
if (model.LZ014 != null && model.LZ014 > DateTime.MinValue && model.LZ014 < DateTime.MaxValue)
{
dateTimePicker5.Value = model.LZ014;
}
textBox8.Text = model.LZ030;
textBox10.Text = model.LZ027;
textBox18.Text = model.LZ031;
button10_Click(null, null);
}
/// <summary>
/// 删除一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Delete(MulaolaoLibrary.GunQiChengLanJiaGongLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("DELETE FROM R_PQLZ");
strSql.Append(" WHERE idx=@idx");
SqlParameter[] parameter =
{
new SqlParameter("@idx", SqlDbType.Int)
};
parameter[0].Value = model.IDX;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 是否存在一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(MulaolaoLibrary.GunQiChengLanJiaGongLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) FROM R_PQLZ");
strSql.Append(" WHERE LZ002=@LZ002 AND LZ015=@LZ015 AND LZ017=@LZ017 AND LZ018=@LZ018 AND LZ019=@LZ019 AND LZ031=@LZ031");
SqlParameter[] parameter =
{
new SqlParameter("@LZ002", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ015", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ017", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ018", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ019", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ031", SqlDbType.NVarChar, 20)
};
parameter[0].Value = model.LZ002;
parameter[1].Value = model.LZ015;
parameter[2].Value = model.LZ017;
parameter[3].Value = model.LZ018;
parameter[4].Value = model.LZ019;
parameter[5].Value = model.LZ031;
return(SqlHelper.Exists(strSql.ToString( ), parameter));
}
/// <summary>
/// 删除一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Delete(MulaolaoLibrary.GunQiChengLanJiaGongLibrary model)
{
return(dao.Delete(model));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(MulaolaoLibrary.GunQiChengLanJiaGongLibrary model)
{
return(dao.Insert(model));
}
/// <summary>
/// 是否存在一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(MulaolaoLibrary.GunQiChengLanJiaGongLibrary model)
{
return(dao.Exists(model));
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateAll(MulaolaoLibrary.GunQiChengLanJiaGongLibrary model)
{
return(dao.UpdateAll(model));
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateAll(MulaolaoLibrary.GunQiChengLanJiaGongLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQLZ SET ");
strSql.Append("LZ002=@LZ002,");
strSql.Append("LZ003=@LZ003,");
strSql.Append("LZ004=@LZ004,");
strSql.Append("LZ005=@LZ005,");
strSql.Append("LZ006=@LZ006,");
strSql.Append("LZ007=@LZ007,");
strSql.Append("LZ008=@LZ008,");
strSql.Append("LZ009=@LZ009,");
strSql.Append("LZ010=@LZ010,");
strSql.Append("LZ011=@LZ011,");
strSql.Append("LZ012=@LZ012,");
strSql.Append("LZ013=@LZ013,");
strSql.Append("LZ014=@LZ014,");
strSql.Append("LZ027=@LZ027,");
strSql.Append("LZ028=@LZ028,");
strSql.Append("LZ029=@LZ029,");
strSql.Append("LZ030=@LZ030");
strSql.Append(" WHERE LZ001=@LZ001");
SqlParameter[] parameter =
{
new SqlParameter("@LZ001", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ002", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ003", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ004", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ005", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ006", SqlDbType.BigInt),
new SqlParameter("@LZ007", SqlDbType.Date),
new SqlParameter("@LZ008", SqlDbType.Date),
new SqlParameter("@LZ009", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ010", SqlDbType.Date),
new SqlParameter("@LZ011", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ012", SqlDbType.Date),
new SqlParameter("@LZ013", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ014", SqlDbType.Date),
new SqlParameter("@LZ028", SqlDbType.NVarChar, 2000),
new SqlParameter("@LZ029", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ030", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ027", SqlDbType.NVarChar, 2000)
};
parameter[0].Value = model.LZ001;
parameter[1].Value = model.LZ002;
parameter[2].Value = model.LZ003;
parameter[3].Value = model.LZ004;
parameter[4].Value = model.LZ005;
parameter[5].Value = model.LZ006;
parameter[6].Value = model.LZ007;
parameter[7].Value = model.LZ008;
parameter[8].Value = model.LZ009;
parameter[9].Value = model.LZ010;
parameter[10].Value = model.LZ011;
parameter[11].Value = model.LZ012;
parameter[12].Value = model.LZ013;
parameter[13].Value = model.LZ014;
parameter[14].Value = model.LZ028;
parameter[15].Value = model.LZ029;
parameter[16].Value = model.LZ030;
parameter[17].Value = model.LZ027;
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.GunQiChengLanJiaGongLibrary GetDataRow(DataRow row)
{
MulaolaoLibrary.GunQiChengLanJiaGongLibrary model = new MulaolaoLibrary.GunQiChengLanJiaGongLibrary( );
if (row != null)
{
if (row["idx"] != null && row["idx"].ToString( ) != "")
{
model.IDX = int.Parse(row["idx"].ToString( ));
}
if (row["LZ001"] != null && row["LZ001"].ToString( ) != "")
{
model.LZ001 = row["LZ001"].ToString( );
}
if (row["LZ002"] != null && row["LZ002"].ToString( ) != "")
{
model.LZ002 = row["LZ002"].ToString( );
}
if (row["LZ003"] != null && row["LZ003"].ToString( ) != "")
{
model.LZ003 = row["LZ003"].ToString( );
}
if (row["LZ004"] != null && row["LZ004"].ToString( ) != "")
{
model.LZ004 = row["LZ004"].ToString( );
}
if (row["LZ005"] != null && row["LZ005"].ToString( ) != "")
{
model.LZ005 = row["LZ005"].ToString( );
}
if (row["LZ006"] != null && row["LZ006"].ToString( ) != "")
{
model.LZ006 = long.Parse(row["LZ006"].ToString( ));
}
if (row["LZ007"] != null && row["LZ007"].ToString( ) != "")
{
model.LZ007 = DateTime.Parse(row["LZ007"].ToString( ));
}
if (row["LZ008"] != null && row["LZ008"].ToString( ) != "")
{
model.LZ008 = DateTime.Parse(row["LZ008"].ToString( ));
}
if (row["LZ009"] != null && row["LZ009"].ToString( ) != "")
{
model.LZ009 = row["LZ009"].ToString( );
}
if (row["LZ010"] != null && row["LZ010"].ToString( ) != "")
{
model.LZ010 = DateTime.Parse(row["LZ010"].ToString( ));
}
if (row["LZ011"] != null && row["LZ011"].ToString( ) != "")
{
model.LZ011 = row["LZ011"].ToString( );
}
if (row["LZ012"] != null && row["LZ012"].ToString( ) != "")
{
model.LZ012 = DateTime.Parse(row["LZ012"].ToString( ));
}
if (row["LZ013"] != null && row["LZ013"].ToString( ) != "")
{
model.LZ013 = row["LZ013"].ToString( );
}
if (row["LZ014"] != null && row["LZ014"].ToString( ) != "")
{
model.LZ014 = DateTime.Parse(row["LZ014"].ToString( ));
}
if (row["LZ015"] != null && row["LZ015"].ToString( ) != "")
{
model.LZ015 = row["LZ015"].ToString( );
}
if (row["LZ016"] != null && row["LZ016"].ToString( ) != "")
{
model.LZ016 = row["LZ016"].ToString( );
}
if (row["LZ017"] != null && row["LZ017"].ToString( ) != "")
{
model.LZ017 = row["LZ017"].ToString( );
}
if (row["LZ018"] != null && row["LZ018"].ToString( ) != "")
{
model.LZ018 = row["LZ018"].ToString( );
}
if (row["LZ019"] != null && row["LZ019"].ToString( ) != "")
{
model.LZ019 = row["LZ019"].ToString( );
}
if (row["LZ020"] != null && row["LZ020"].ToString( ) != "")
{
model.LZ020 = decimal.Parse(row["LZ020"].ToString( ));
}
if (row["LZ021"] != null && row["LZ021"].ToString( ) != "")
{
model.LZ021 = int.Parse(row["LZ021"].ToString( ));
}
if (row["LZ022"] != null && row["LZ022"].ToString( ) != "")
{
model.LZ022 = decimal.Parse(row["LZ022"].ToString( ));
}
if (row["LZ023"] != null && row["LZ023"].ToString( ) != "")
{
model.LZ023 = decimal.Parse(row["LZ023"].ToString( ));
}
if (row["LZ024"] != null && row["LZ024"].ToString( ) != "")
{
model.LZ024 = decimal.Parse(row["LZ024"].ToString( ));
}
//if ( row["LZ025"] != null && row["LZ025"].ToString( ) != "" )
// model.LZ025 = decimal.Parse( row["LZ025"].ToString( ) );
if (row["LZ026"] != null && row["LZ026"].ToString( ) != "")
{
model.LZ026 = int.Parse(row["LZ026"].ToString( ));
}
if (row["LZ027"] != null && row["LZ027"].ToString( ) != "")
{
model.LZ027 = row["LZ027"].ToString( );
}
if (row["LZ029"] != null && row["LZ029"].ToString( ) != "")
{
model.LZ029 = row["LZ029"].ToString( );
}
if (row["LZ030"] != null && row["LZ030"].ToString( ) != "")
{
model.LZ030 = row["LZ030"].ToString( );
}
if (row["LZ031"] != null && row["LZ031"].ToString( ) != "")
{
model.LZ031 = row["LZ031"].ToString( );
}
if (row["LZ032"] != null && row["LZ032"].ToString( ) != "")
{
model.LZ032 = decimal.Parse(row["LZ032"].ToString( ));
}
if (row["LZ033"] != null && row["LZ033"].ToString( ) != "")
{
model.LZ033 = row["LZ033"].ToString( );
}
if (row["LZ034"] != null && row["LZ034"].ToString( ) != "")
{
model.LZ034 = decimal.Parse(row["LZ034"].ToString( ));
}
if (row["LZ035"] != null && row["LZ035"].ToString( ) != "")
{
model.LZ035 = row["LZ035"].ToString( );
}
}
return(model);
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(MulaolaoLibrary.GunQiChengLanJiaGongLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQLZ SET ");
strSql.Append("LZ006=@LZ006,");
strSql.Append("LZ015=@LZ015,");
strSql.Append("LZ016=@LZ016,");
strSql.Append("LZ017=@LZ017,");
strSql.Append("LZ018=@LZ018,");
strSql.Append("LZ019=@LZ019,");
strSql.Append("LZ020=@LZ020,");
strSql.Append("LZ021=@LZ021,");
strSql.Append("LZ022=@LZ022,");
strSql.Append("LZ023=@LZ023,");
strSql.Append("LZ024=@LZ024,");
//strSql.Append( "LZ025=@LZ025," );
strSql.Append("LZ026=@LZ026,");
strSql.Append("LZ029=@LZ029,");
strSql.Append("LZ031=@LZ031,");
strSql.Append("LZ032=@LZ032,");
strSql.Append("LZ033=@LZ033,");
strSql.Append("LZ034=@LZ034,");
strSql.Append("LZ035=@LZ035");
strSql.Append(" WHERE idx=@idx");
SqlParameter[] parameter =
{
new SqlParameter("@LZ016", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ020", SqlDbType.Decimal, 5),
new SqlParameter("@LZ021", SqlDbType.Int),
new SqlParameter("@LZ022", SqlDbType.Decimal, 7),
//new SqlParameter("@LZ025",SqlDbType.Decimal,6),
new SqlParameter("@LZ024", SqlDbType.Decimal, 6),
new SqlParameter("@LZ023", SqlDbType.Decimal, 6),
new SqlParameter("@LZ026", SqlDbType.Int),
new SqlParameter("@idx", SqlDbType.Int),
new SqlParameter("@LZ006", SqlDbType.BigInt),
new SqlParameter("@LZ015", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ017", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ018", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ019", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ029", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ031", SqlDbType.NVarChar, 20),
new SqlParameter("@LZ032", SqlDbType.Decimal, 4),
new SqlParameter("@LZ033", SqlDbType.NVarChar, 255),
new SqlParameter("@LZ034", SqlDbType.Decimal, 6),
new SqlParameter("@LZ035", SqlDbType.NVarChar, 4)
};
parameter[0].Value = model.LZ016;
parameter[1].Value = model.LZ020;
parameter[2].Value = model.LZ021;
parameter[3].Value = model.LZ022;
//parameter[4].Value = model.LZ025;
parameter[4].Value = model.LZ024;
parameter[5].Value = model.LZ023;
parameter[6].Value = model.LZ026;
parameter[7].Value = model.IDX;
parameter[8].Value = model.LZ006;
parameter[9].Value = model.LZ015;
parameter[10].Value = model.LZ017;
parameter[11].Value = model.LZ018;
parameter[12].Value = model.LZ019;
parameter[13].Value = model.LZ029;
parameter[14].Value = model.LZ031;
parameter[15].Value = model.LZ032;
parameter[16].Value = model.LZ033;
parameter[17].Value = model.LZ034;
parameter[18].Value = model.LZ035;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
