//查詢營業所 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; } }