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