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();
}
