private void InitializeData()
{
TunnelManageBll bll = new TunnelManageBll();
cmbMachine.DataSource = bll.GetMachines();
cmbMachine.DisplayMember = "machine_name";
cmbMachine.ValueMember = "id";
cmbMaterial.DataSource = bll.GetMaterials();
cmbMaterial.DisplayMember = "material_name";
cmbMaterial.ValueMember = "material_num";
if (!Common.IsNew)
{
DataTable dt = bll.GetItemById(Common.Id);
if (dt != null && dt.Rows.Count > 0)
{
cmbMachine.SelectedValue = dt.Rows[0]["machine_num"].ToString();
txtNumber.Text = dt.Rows[0]["tunnel_num"].ToString();
txtMaxStock.Value = int.Parse(dt.Rows[0]["tunnel_max_stock"].ToString());
txtAlertStock.Value = int.Parse(dt.Rows[0]["min_stock_alert"].ToString());
txtCurStock.Value = int.Parse(dt.Rows[0]["cur_stock"].ToString());
cmbMaterial.SelectedValue = dt.Rows[0]["material_num"].ToString();
}
}
else
{
Common.Id = Guid.NewGuid().ToString();
}
}
//分布绑定
private void bindPager()
{
int count = 0;
switch (Common.NowMobule)
{
case "peoplemanage":
PeopleManageBll bll = new PeopleManageBll();
count = bll.GetTotalCount(((ToolStripTextBox)this.tools.Items["peopleName"]).Text);
break;
case "machinemanage":
MachineManageBll machineBll = new MachineManageBll();
count = machineBll.GetTotalCount();
break;
case "materialmanage":
MaterialManageBll materialBll = new MaterialManageBll();
count = materialBll.GetTotalCount(((ToolStripTextBox)this.tools.Items["material_num"]).Text, ((ToolStripTextBox)this.tools.Items["material_name"]).Text);
break;
case "tunnelmanage":
TunnelManageBll tunnelBll = new TunnelManageBll();
count = tunnelBll.GetTotalCount(((ToolStripTextBox)this.tools.Items["machine_num"]).Text);
break;
case "materialrecord":
MaterialRecordBll materialRecordBll = new MaterialRecordBll();
count = materialRecordBll.GetTotalCount(((ToolStripTextBox)this.tools.Items["card_num"]).Text, ((ToolStripTextBox)this.tools.Items["material_num"]).Text, Convert.ToDateTime(this.tools.Items[5].Text));
break;
}
((ToolStripLabel)this.pager.Items["totalCount"]).Text = count.ToString();
int nowPageSize = Convert.ToInt32(((ToolStripComboBox)this.pager.Items["pageSize"]).SelectedItem);
int totalPage = 0;
if (count % nowPageSize == 0)
{
totalPage = count / nowPageSize;
}
else
{
totalPage = (int)Math.Ceiling((double)count / nowPageSize);
}
((ToolStripLabel)this.pager.Items["totalPage"]).Text = totalPage.ToString();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cmbMachine.SelectedValue.ToString()))
{
MessageBox.Show("机器必选");
return;
}
if (string.IsNullOrEmpty(txtNumber.Text))
{
MessageBox.Show("货道号必填");
return;
}
TunnelManageBll bll = new TunnelManageBll();
int result = bll.CreateTunnel(Common.Id, cmbMachine.SelectedValue.ToString(), txtNumber.Text, int.Parse(txtMaxStock.Value.ToString()), int.Parse(txtAlertStock.Value.ToString()), int.Parse(txtCurStock.Value.ToString()), cmbMaterial.SelectedValue.ToString());
if (result > 0)
{
this.Hide();
f1.callBack();
}
}
//数据绑定
private void bindData()
{
gv.Columns.Clear();
DataTable dt = new DataTable();
switch (Common.NowMobule)
{
case "peoplemanage":
PeopleManageBll bll = new PeopleManageBll();
dt = bll.GetAll(((ToolStripTextBox)this.tools.Items["peopleName"]).Text, Convert.ToInt32(((ToolStripLabel)this.pager.Items["pageIndex"]).Text), Convert.ToInt32(((ToolStripComboBox)this.pager.Items["pageSize"]).SelectedItem));
break;
case "machinemanage":
MachineManageBll machineBll = new MachineManageBll();
dt = machineBll.GetAll(Convert.ToInt32(((ToolStripLabel)this.pager.Items["pageIndex"]).Text), Convert.ToInt32(((ToolStripComboBox)this.pager.Items["pageSize"]).SelectedItem));
break;
case "materialmanage":
MaterialManageBll materialBll = new MaterialManageBll();
dt = materialBll.GetAll(((ToolStripTextBox)this.tools.Items["material_num"]).Text, ((ToolStripTextBox)this.tools.Items["material_name"]).Text, Convert.ToInt32(((ToolStripLabel)this.pager.Items["pageIndex"]).Text), Convert.ToInt32(((ToolStripComboBox)this.pager.Items["pageSize"]).SelectedItem));
break;
case "tunnelmanage":
TunnelManageBll tunnelBll = new TunnelManageBll();
dt = tunnelBll.GetAll(((ToolStripTextBox)this.tools.Items["machine_num"]).Text, Convert.ToInt32(((ToolStripLabel)this.pager.Items["pageIndex"]).Text), Convert.ToInt32(((ToolStripComboBox)this.pager.Items["pageSize"]).SelectedItem));
break;
case "materialrecord":
MaterialRecordBll materialRecordBll = new MaterialRecordBll();
dt = materialRecordBll.GetAll(((ToolStripTextBox)this.tools.Items["card_num"]).Text, ((ToolStripTextBox)this.tools.Items["material_num"]).Text, Convert.ToDateTime(this.tools.Items[5].Text), Convert.ToInt32(((ToolStripLabel)this.pager.Items["pageIndex"]).Text), Convert.ToInt32(((ToolStripComboBox)this.pager.Items["pageSize"]).SelectedItem));
break;
}
gv.DataSource = dt;
gvGenerate();
}
