private void frm_原材料编辑_Load(object sender, EventArgs e)
{
MinimizeBox = false;
MaximizeBox = false;
FormBorderStyle = FormBorderStyle.Fixed3D;
txt_gonghao.set_title("工号");
txt_money.set_title("金额");
txt_weight.set_title("重量");
txt_money.set_type(2);
txt_weight.set_type(2);
Text = "原材料编辑 部门：" + deptname + " 代码：" + deptcode;
lab_pzh.Text = "凭证号：" + 凭证.凭证号;
材质类别表DAL dal = new 材质类别表DAL();
cmb_type.DataSource = dal.GetDataTable(); //GetDataTable
cmb_type.DisplayMember = "材质名称";
cmb_type.ValueMember = "材质类别";
if (!addflag)
{
txt_gonghao.set_value(凭证.工作令号);
txt_weight.set_value(凭证.重量.ToString());
txt_money.set_value(凭证.金额.ToString());
cmb_type.SelectedValue = 凭证.材质;
}
}
private void frm_import_excel_Load(object sender, EventArgs e)
{
System.Data.DataTable tb;
材质类别表DAL dal = new 材质类别表DAL();
if (_isSale)
{
tb = dal.GetDataTableForSale();
}
else
{
tb = dal.GetDataTable();
}
clsItem mycls1;
foreach (DataRow myrow in tb.Rows)
{
mycls1 = new clsItem();
mycls1.name = myrow["材质名称"].ToString();
mycls1.value = myrow["材质类别"].ToString();
cmb_type.Items.Add(mycls1);
}
cmb_type.ValueMember = "value";
cmb_type.DisplayMember = "name";
Text = "数据导入 部门：" + deptname + " 部门代码：" + deptcode;
}
private void frm_otherCost_Load(object sender, EventArgs e)
{
this.Text = "其它费用导入";
dal.材质类别表DAL dal = new 材质类别表DAL();
System.Data.DataTable tb = dal.GetDataTableForSale();
clsItem mycls1;
foreach (DataRow myrow in tb.Rows)
{
mycls1 = new clsItem();
mycls1.name = myrow["材质名称"].ToString();
mycls1.value = myrow["材质类别"].ToString();
cmb_type.Items.Add(mycls1);
}
cmb_type.ValueMember = "value";
cmb_type.DisplayMember = "name";
Text = "销售部门数据导入";
//dal.OtherCostDal dal = new OtherCostDal();
//this.FormBorderStyle = FormBorderStyle.Fixed3D;
//SqlDataReader dr = dal.getOtherCostName();
//while (dr.Read())
//{
// cmb_type.Items.Add(dr.GetString(0));
//}
}
private void frm_OtherCostModify_Load(object sender, EventArgs e)
{
材质类别表DAL dal = new 材质类别表DAL();
label1.Text = workno;
typename = dal.getMaterialType(workno);
label2.Text = typename;
}
