void init_data(string formno, string stepid) { string sql = @"exec [usp_app_Adjust_sign_init] '{0}','{1}'"; sql = string.Format(sql, formno, stepid); DataSet ds = SQLHelper.Query(sql); DataTable dt = ds.Tables[0]; listBxInfo.DataSource = dt; listBxInfo.DataBind(); if (dt.Rows.Count == 1) { lot_no.Text = dt.Rows[0]["lot_no"].ToString(); source.Text = dt.Rows[0]["source"].ToString(); flagwhere.Text = dt.Rows[0]["flagwhere"].ToString(); loc.Text = dt.Rows[0]["loc"].ToString(); from_qty.Text = dt.Rows[0]["from_qty"].ToString(); adj_qty_abs.Text = dt.Rows[0]["adj_qty_abs"].ToString(); } Repeater_sg.DataSource = ds.Tables[1]; Repeater_sg.DataBind(); }
void init_data(string formno) { string sql = @"exec [usp_app_Jiaju_Apply_init] '{0}','{1}'"; sql = string.Format(sql, formno, emp_code_name.Text); DataSet ds = SQLHelper.Query(sql); DataTable dt = ds.Tables[0]; if (dt.Rows.Count == 1) { _stepid = dt.Rows[0]["status"].ToString(); stepid.Text = _stepid; _times_t = dt.Rows[0]["times_t"].ToString(); _times_t_YN = dt.Rows[0]["times_t_YN"].ToString(); listBxInfo.DataSource = dt; listBxInfo.DataBind(); if (_stepid == "2")//检测结果确认,默认带出,上一步的 检测结果 { ng_ok_2.Text = ds.Tables[1].Rows[ds.Tables[1].Rows.Count - 1]["ng_ok"].ToString(); _sign_2_YN = dt.Rows[0]["sign_2_YN"].ToString(); } } DataTable dt_sg = ds.Tables[1]; Repeater_sg.DataSource = dt_sg; Repeater_sg.DataBind(); ViewState["dt_sg"] = dt_sg.Rows.Count.ToString(); }
void init_data(string formno, string stepid) { string sql = @"exec [usp_app_Adjust_Apply_init_V1] '{0}','{1}'"; sql = string.Format(sql, formno, stepid); DataSet ds = SQLHelper.Query(sql); DataTable dt = ds.Tables[0]; if (dt.Rows.Count == 1) { emp_code_name_db.Text = dt.Rows[0]["emp_code"].ToString() + dt.Rows[0]["emp_name"].ToString(); source.Text = dt.Rows[0]["source"].ToString(); dh.Text = dt.Rows[0]["lot_no"].ToString(); pgino.Text = dt.Rows[0]["pgino"].ToString(); pn.Text = dt.Rows[0]["pn"].ToString(); from_qty_db.Text = "原数量" + dt.Rows[0]["from_qty"].ToString(); from_qty_db.Visible = true; adj_qty.Text = dt.Rows[0]["adj_qty"].ToString(); comment.Value = dt.Rows[0]["remark"].ToString(); //改三个字段proc重新复制喽 if (dt.Rows[0]["flagwhere"].ToString() != "QAD") { from_qty.Text = dt.Rows[0]["from_qty_cur"].ToString(); need_no.Text = dt.Rows[0]["need_no"].ToString(); flagwhere.Text = dt.Rows[0]["flagwhere"].ToString(); loc.Text = dt.Rows[0]["loc"].ToString(); } else { DataTable ldt = new DataTable(); string sqlStr = @"select ld_part,ld_loc,cast(cast(ld_qty_oh as numeric(18,4)) as float) ld_qty_oh from pub.ld_det where ld_ref='{0}' and ld_domain='200' and ld_loc='{1}' with (nolock)"; sqlStr = string.Format(sqlStr, dt.Rows[0]["lot_no"].ToString(), dt.Rows[0]["loc"].ToString()); ldt = QadOdbcHelper.GetODBCRows(sqlStr); if (ldt == null) { } else if (ldt.Rows.Count <= 0) { } else//QAD存在 { from_qty.Text = ldt.Rows[0]["ld_qty_oh"].ToString(); flagwhere.Text = "QAD"; need_no.Text = ""; loc.Text = ldt.Rows[0]["ld_loc"].ToString(); } } } DataTable dt_sg = ds.Tables[1]; Repeater_sg.DataSource = dt_sg; Repeater_sg.DataBind(); }