//查詢營業所
private void get_ZO(string dis_no)
{
try
{
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(dis_no); //配本序號
DataTable dt = new DataTable();
BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
dt = bco.QueryDisQtyForZO(ParameterList);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
switch (dr["Z_O"].ToString())
{
case "A":
txtZO_A.Text = dr["Z_O_SUM_DIS_QTY"].ToString().Trim().Length == 0 ? "0" : dr["Z_O_SUM_DIS_QTY"].ToString().Trim();
break;
case "B":
txtZO_B.Text = dr["Z_O_SUM_DIS_QTY"].ToString().Trim().Length == 0 ? "0" : dr["Z_O_SUM_DIS_QTY"].ToString().Trim();
break;
case "D":
txtZO_D.Text = dr["Z_O_SUM_DIS_QTY"].ToString().Trim().Length == 0 ? "0" : dr["Z_O_SUM_DIS_QTY"].ToString().Trim();
break;
case "E":
txtZO_E.Text = dr["Z_O_SUM_DIS_QTY"].ToString().Trim().Length == 0 ? "0" : dr["Z_O_SUM_DIS_QTY"].ToString().Trim();
break;
case "H":
txtZO_H.Text = dr["Z_O_SUM_DIS_QTY"].ToString().Trim().Length == 0 ? "0" : dr["Z_O_SUM_DIS_QTY"].ToString().Trim();
break;
case "C":
txtZO_C.Text = dr["Z_O_SUM_DIS_QTY"].ToString().Trim().Length == 0 ? "0" : dr["Z_O_SUM_DIS_QTY"].ToString().Trim();
break;
}
}
txtZO_Sum.Text = Convert.ToString(Int32.Parse(txtZO_A.Text) + Int32.Parse(txtZO_B.Text) + Int32.Parse(txtZO_C.Text) + Int32.Parse(txtZO_D.Text) + Int32.Parse(txtZO_E.Text) + Int32.Parse(txtZO_H.Text));
}
dt.Clear();
dt.Dispose();
}
catch (Exception ex) { this.lblErrorQ1.Text = ex.Message; lblErrorQ1.Visible = true; }
}
