private void loadData(string print_type, string file_str)
{
if (txtDep.Text.Trim() == "")
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "alert", " alert('部門不能為空!');", true);
return;
}
user_id = getUserName();
//System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
string filename = file_str + ".xls";
DataTable dt = new DataTable();
string dat1, dat2;
dat1 = Convert.ToDateTime(dateStart.Value).ToString("yyyy/MM/dd");
dat2 = Convert.ToDateTime(dateEnd.Value).AddDays(1).ToString("yyyy/MM/dd");
SqlParameter[] parameters1 = { new SqlParameter("@print_type", print_type)
, new SqlParameter("@dep", txtDep.Text)
, new SqlParameter("@dat1", dat1)
, new SqlParameter("@dat2", dat2) };
dt = sh.ExecuteProcedure("usp_mo_outsideprocess", parameters1);
//ps.DataSource = dtTranRec.DefaultView;
//this.rptDetail.DataSource = ps;
//this.rptDetail.DataBind();
string content = getExcelContent(dt);
string css = ".firstTR td{color:blue;width:100px;}.secondTR td{color:blue;width:100px;}";
filename = System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8);//.UTF8
ExportToExcel(filename, content, css);
}
protected void BindData()
{
if (!validData())
{
return;
}
string dat1, dat2;
string inv1 = txtInv1.Text;
string inv2 = txtInv2.Text;
int tr_type = dlShowDeliv.SelectedIndex;//過期類型報表
dat1 = dateStart.Value;
dat2 = dateEnd.Value;
if (dat2 != "")
{
dat2 = Convert.ToDateTime(dat2).AddDays(1).ToString("yyyy/MM/dd");
}
if (dateStart.Value == "" && txtMo1.Text == "" && txtMo2.Text == "" &&
txtCust.Text == "" && txtInv1.Text == "" && txtInv2.Text == "")
{
inv1 = "ZZZZZZZZZ";
inv2 = "ZZZZZZZZZ";
}
System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
string strSql = "usp_ShowInvStatus";
SqlParameter[] parameters = { new SqlParameter("@tr_type", tr_type)
, new SqlParameter("@dat1", dat1), new SqlParameter("@dat2", dat2)
, new SqlParameter("@mo1", txtMo1.Text)
, new SqlParameter("@mo2", txtMo2.Text)
, new SqlParameter("@inv1", inv1)
, new SqlParameter("@inv2", inv2)
, new SqlParameter("@cust", txtCust.Text) };
DataTable dtInv = sh.ExecuteProcedure(strSql, parameters);
ps.DataSource = dtInv.DefaultView;
this.wpDetail.DataSource = ps;
this.wpDetail.DataBind();
if (dtInv.Rows.Count > 0)
{
lblShowInfo.Text = dlShowDeliv.SelectedValue + " 記錄數：" + dtInv.Rows.Count.ToString();
}
else
{
lblShowInfo.Text = "已開發票，未送貨記錄。";
}
}
protected void BindData()
{
if (!validData())
{
return;
}
string dat1, dat2;
string vatdat1, vatdat2;
dat1 = dateStart.Value;
dat2 = dateEnd.Value;
vatdat1 = vatDateStart.Value;
vatdat2 = vatDateEnd.Value;
string Agent1 = txtAgent1.Text;
string Agent2 = txtAgent2.Text;
int doc_type = 1;
if (chkShowVat.Checked == true)
{
doc_type = 2;
}
if (dat2 != "")
{
dat2 = Convert.ToDateTime(dat2).AddDays(1).ToString("yyyy/MM/dd");
}
if (vatdat2 != "")
{
vatdat2 = Convert.ToDateTime(vatdat2).AddDays(1).ToString("yyyy/MM/dd");
}
System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
string strSql = "usp_LoadInvByAgent";
SqlParameter[] parameters = { new SqlParameter("@doc_type", doc_type)
, new SqlParameter("@brand1", txtBrand1.Text), new SqlParameter("@brand2", txtBrand2.Text)
, new SqlParameter("@Agent1", Agent1), new SqlParameter("@Agent2", Agent2)
, new SqlParameter("@dat1", dat1), new SqlParameter("@dat2", dat2)
, new SqlParameter("@vatdat1", vatdat1), new SqlParameter("@vatdat2", vatdat2) };
DataTable dtStTr = sh.ExecuteProcedure(strSql, parameters);
ps.DataSource = dtStTr.DefaultView;
this.wpDetail.DataSource = ps;
this.wpDetail.DataBind();
}
protected void BindData()
{
if (!validData())
{
return;
}
string dat1, dat2;
dat1 = txtDate1.Text;
dat2 = txtDate2.Text;
string dep = txtDep.Text;
if (dat2 != "")
{
dat2 = Convert.ToDateTime(dat2).AddDays(1).ToString("yyyy/MM/dd");
}
if (txtDate2.Text == "" && txtDep.Text == "")
{
dep = "ZZZZZZZZZ";
}
string strSql = "mo_MoveStatus_Spec";
SqlParameter[] parameters = { new SqlParameter("@dep", dep)
, new SqlParameter("@dat1",dat1), new SqlParameter("@dat2", dat2) };
DataTable dtStTr = sh.ExecuteProcedure(strSql, parameters);
gvDetails.DataSource = dtStTr.DefaultView;
gvDetails.DataBind();
if (dtStTr.Rows.Count > 0)
{
lblShowInfo.Text = " 記錄數：" + dtStTr.Rows.Count.ToString();
}
else
{
lblShowInfo.Text = "查看外發記錄之移交狀態。";
}
}
protected void BindData()
{
user_id = getUserName();
string strDat1 = dateStart.Value;
string strDat2 = dateEnd.Value;
if (!StrHlp.CheckDateFormat(strDat1))
{
strDat1 = "";
}
if (!StrHlp.CheckDateFormat(strDat2))
{
strDat2 = "";
}
string sales_group = dlSales_group.SelectedValue.ToString();
string brand = txtBrand.Text;
string mat = txtMaterial.Text;
string cust_code = txtCust_code.Text;
string cust_color = txtCust_color.Text;
string cf_code = txtCf_code.Text;
string cf_color = txtCf_color.Text;
string season = txtSeason.Text;
string temp_code = txtTemp_code.Text;
string size = txtSize.Text;
string sub_mo_id = txtSubMo.Text;
string product_desc = txtGood_desc.Text;
string plm_code = "";
string reason_edit = "";
string remark = "";
string other_remark = "";
string remark_for_pdd = "";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@user_id", user_id),
new SqlParameter("@sales_group", sales_group),
new SqlParameter("@brand", brand),
new SqlParameter("@material", mat),
new SqlParameter("@cust_code", cust_code),
new SqlParameter("@cust_color", cust_color),
new SqlParameter("@cf_code", cf_code),
new SqlParameter("@cf_color", cf_color),
new SqlParameter("@season", season),
new SqlParameter("@temp_code", temp_code),
new SqlParameter("@size", size),
new SqlParameter("@dat1", strDat1),
new SqlParameter("@dat2", strDat2),
new SqlParameter("@mo_id", txtMo_id.Text),
new SqlParameter("@sub_mo_id", sub_mo_id),
new SqlParameter("@plm_code", plm_code),
new SqlParameter("@reason_edit", reason_edit),
new SqlParameter("@product_desc", product_desc),
new SqlParameter("@remark", remark),
new SqlParameter("@other_remark", other_remark),
new SqlParameter("@remark_for_pdd", remark_for_pdd)
};
DataTable dtQuotation = sh.ExecuteProcedure("usp_qoutation_find", paras);
if (dtQuotation.Rows.Count == 0)
{
dtQuotation.Rows.Add();
}
gvDetails.DataSource = dtQuotation.DefaultView;
gvDetails.DataBind();
}
protected void LoadData()
{
if (!validData())
{
return;
}
string user_id = "admin";// getUserName();
string mo1 = txtMo1.Text.Trim().ToUpper();
string mo2 = txtMo2.Text.Trim().ToUpper();
string date1, date2;
string crdate1, crdate2;
string cs_date1, cs_date2;
string crby = txtCrBy.Text;
string mo_group = "";
string brand1;
string cust1;
string agent1;
string only_apart = "";
int period_type = dlShowPeriod.SelectedIndex;//過期類型報表
brand1 = txtBrand.Text;
cust1 = txtCust.Text;
date1 = orderDateStart.Value;
date2 = orderDateEnd.Value;
crdate1 = crDateStart.Value;
crdate2 = crDateEnd.Value;
cs_date1 = custReqDateStart.Value;
cs_date2 = custReqDateEnd.Value;
agent1 = txtAgent1.Text;
if (chkShowA_part.Checked == true)
{
only_apart = "1";
}
if (dlMo_group.SelectedIndex > 0)
{
mo_group = dlMo_group.SelectedValue.ToString();
}
if (date2 != "")
{
date2 = Convert.ToDateTime(date2).AddDays(1).ToString("yyyy/MM/dd");
}
if (crdate2 != "")
{
crdate2 = Convert.ToDateTime(crdate2).AddDays(1).ToString("yyyy/MM/dd");
}
if (cs_date2 != "")
{
cs_date2 = Convert.ToDateTime(cs_date2).AddDays(1).ToString("yyyy/MM/dd");
}
string strSql = "usp_ShowOcList_prd";
SqlParameter[] parameters = { new SqlParameter("@user_id", user_id)
, new SqlParameter("@period_type",period_type)
, new SqlParameter("@mo_group", mo_group)
, new SqlParameter("@only_apart", only_apart)
, new SqlParameter("@crdat1", crdate1), new SqlParameter("@crdat2", crdate2)
, new SqlParameter("@dat1", date1), new SqlParameter("@dat2", date2)
, new SqlParameter("@cs_dat1", cs_date1), new SqlParameter("@cs_dat2", cs_date2)
, new SqlParameter("@crby", crby)
, new SqlParameter("@mo1", mo1), new SqlParameter("@mo2", mo2)
, new SqlParameter("@brand1", brand1)
, new SqlParameter("@cust1", cust1)
, new SqlParameter("@agent1", agent1)
, new SqlParameter("@cust_goods", txtCust_Goods.Text)
, new SqlParameter("@cust_color", txtCust_Color.Text)
, new SqlParameter("@cust_style", txtCust_Style.Text)
, new SqlParameter("@season", txtSeason.Text)
, new SqlParameter("@mat_code", txtMat.Text)
, new SqlParameter("@prod_code", txtProd.Text)
, new SqlParameter("@art_code", txtArt.Text)
, new SqlParameter("@size_code", txtSize.Text)
, new SqlParameter("@clr_code", txtClr.Text)
, new SqlParameter("@pono", txtPoNo.Text)
, new SqlParameter("@ocno", txtOcNo.Text)
, new SqlParameter("@goods_id", txtGoods_id.Text) };
DataTable dtOc = sh.ExecuteProcedure(strSql, parameters);
BindData();
//if (dtOc.Rows.Count == 0)
// dtOc.Rows.Add();
//gvDetails.DataSource = dtOc.DefaultView;
//gvDetails.DataBind();
}
protected void loadData()
{
if (!validData())
{
return;
}
try
{
/*实例化分页数据源*/
System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
/*建立业务层对象，执行查询，将记录集绑定到分页数据源上*/
//HourseBLL hourseBll = new HourseBLL();
//ps.DataSource = hourseBll.QueryHourseInfo(this.leixing.SelectedValue, xiaoqu.Text, lowprice.Text, highprice.Text).Tables[0].DefaultView;
string dat1, dat2;
string fdep;
int type = 1;//從外發加工單中提取
int no_set_oil = 0;
dat1 = dateStart.Value;
dat2 = Convert.ToDateTime(dateEnd.Value).AddDays(1).ToString("yyyy/MM/dd");
fdep = txtDep.Text;
if (chkAfter501.Checked == true)//電鍍部已申請大通，但噴油未申請的記錄
{
no_set_oil = 1;
}
string strSql = "usp_MoAfterPlate_To510";
SqlParameter[] parameters = { new SqlParameter("@type", type)
, new SqlParameter("@no_set_oil", no_set_oil)
, new SqlParameter("@fdep", fdep)
, new SqlParameter("@dat1", dat1)
, new SqlParameter("@dat2", dat2) };
DataTable dtTranRec = sh.ExecuteProcedure(strSql, parameters);
ps.DataSource = dtTranRec.DefaultView;
ps.AllowPaging = true;
ps.PageSize = 1000000; //每页显示几条记录
ps.CurrentPageIndex = curPage - 1; //设置当前页的索引(当前页码减1就是)
//this.firstBtn.Enabled = true;
//this.nextBtn.Enabled = true;
//this.prevBtn.Enabled = true;
//this.lastBtn.Enabled = true;
//this.CurrentPage.Text = curPage.ToString();
//this.TotalPage.Text = totalPage.ToString();
//if (curPage == 1)//当是第一页是.上一页和首页的按钮不可用
//{
// this.prevBtn.Enabled = false;
// this.firstBtn.Enabled = false;
//}
//if (curPage == ps.PageCount)//当是最后一页时下一页和最后一页的按钮不可用
//{
// this.nextBtn.Enabled = false;
// this.lastBtn.Enabled = false;
//}
this.rptDetail.DataSource = ps;
//this.hourseDataList.DataKeyField = "hourseId";
this.rptDetail.DataBind();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void loadData()
{
if (!validData())
{
return;
}
try
{
/*实例化分页数据源*/
System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
/*建立业务层对象，执行查询，将记录集绑定到分页数据源上*/
//HourseBLL hourseBll = new HourseBLL();
//ps.DataSource = hourseBll.QueryHourseInfo(this.leixing.SelectedValue, xiaoqu.Text, lowprice.Text, highprice.Text).Tables[0].DefaultView;
string dat1, dat2;
string season;
string mo_group = dlMo_group.Text;
string brand1 = txtBrand1.Value;
string brand2 = txtBrand2.Value;
dat1 = dateStart.Value;
dat2 = dateEnd.Value;
season = dlSeason.Text;
dat2 = Convert.ToDateTime(dat2).AddDays(1).ToString("yyyy/MM/dd");
string strSql = "usp_mo_find_season";
SqlParameter[] parameters = { new SqlParameter("@sea", season)
, new SqlParameter("@mo_group", mo_group)
, new SqlParameter("@dat1", dat1)
, new SqlParameter("@dat2", dat2)
, new SqlParameter("@brand1", brand1)
, new SqlParameter("@brand2", brand2) };
DataTable dtTranRec = sh.ExecuteProcedure(strSql, parameters);
ps.DataSource = dtTranRec.DefaultView;
ps.AllowPaging = true;
ps.PageSize = 1000000; //每页显示几条记录
ps.CurrentPageIndex = curPage - 1; //设置当前页的索引(当前页码减1就是)
//this.firstBtn.Enabled = true;
//this.nextBtn.Enabled = true;
//this.prevBtn.Enabled = true;
//this.lastBtn.Enabled = true;
//this.CurrentPage.Text = curPage.ToString();
//this.TotalPage.Text = totalPage.ToString();
//if (curPage == 1)//当是第一页是.上一页和首页的按钮不可用
//{
// this.prevBtn.Enabled = false;
// this.firstBtn.Enabled = false;
//}
//if (curPage == ps.PageCount)//当是最后一页时下一页和最后一页的按钮不可用
//{
// this.nextBtn.Enabled = false;
// this.lastBtn.Enabled = false;
//}
this.wpDetail.DataSource = ps;
//this.hourseDataList.DataKeyField = "hourseId";
this.wpDetail.DataBind();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void loadData(int rpt_type)
{
if (!validData())
{
return;
}
try
{
/*实例化分页数据源*/
System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
/*建立业务层对象，执行查询，将记录集绑定到分页数据源上*/
//HourseBLL hourseBll = new HourseBLL();
//ps.DataSource = hourseBll.QueryHourseInfo(this.leixing.SelectedValue, xiaoqu.Text, lowprice.Text, highprice.Text).Tables[0].DefaultView;
string dat1, dat2;
string season;
string mo_group = dlMo_group.Text;
string brand1 = txtBrand1.Value;
string brand2 = txtBrand2.Value;
string userid = getUserName();
dat1 = dateStart.Value;
dat2 = dateEnd.Value;
season = dlSeason.Text;
dat2 = Convert.ToDateTime(dat2).AddDays(1).ToString("yyyy/MM/dd");
string strSql = "usp_mo_find_brand";
SqlParameter[] parameters = { new SqlParameter("@usr", userid)
, new SqlParameter("@rpt_type", rpt_type)
, new SqlParameter("@sea", season)
, new SqlParameter("@mo_group", mo_group)
, new SqlParameter("@dat1", dat1)
, new SqlParameter("@dat2", dat2)
, new SqlParameter("@brand1", brand1)
, new SqlParameter("@brand2", brand2) };
DataTable dtTranRec = sh.ExecuteProcedure(strSql, parameters);
//if (rpt_type == 1)
//{
// ps.DataSource = dtTranRec.DefaultView;
// ps.AllowPaging = true;
// ps.PageSize = 1000000;//每页显示几条记录
// ps.CurrentPageIndex = curPage - 1;//设置当前页的索引(当前页码减1就是)
// //this.firstBtn.Enabled = true;
// //this.nextBtn.Enabled = true;
// //this.prevBtn.Enabled = true;
// //this.lastBtn.Enabled = true;
// //this.CurrentPage.Text = curPage.ToString();
// //this.TotalPage.Text = totalPage.ToString();
// //if (curPage == 1)//当是第一页是.上一页和首页的按钮不可用
// //{
// // this.prevBtn.Enabled = false;
// // this.firstBtn.Enabled = false;
// //}
// //if (curPage == ps.PageCount)//当是最后一页时下一页和最后一页的按钮不可用
// //{
// // this.nextBtn.Enabled = false;
// // this.lastBtn.Enabled = false;
// //}
// this.wpDetail.DataSource = ps;
// //this.hourseDataList.DataKeyField = "hourseId";
// this.wpDetail.DataBind();
//}
expData(rpt_type, dtTranRec);
}
catch (Exception ex)
{
//Console.WriteLine(ex.Message.Replace("\r\n", "").Replace("'", ""));
//顯示錯誤信息，原來畫面不會清除
StrHlp.WebMessageBox(this.Page, ex.Message.Replace("\r\n", "").Replace("'", ""));
//以下兩個都會顯示信息，但原來畫面會空白的閃一下
//ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "alert", " alert('" + ex.Message.Replace("\r\n", "").Replace("'", "") + "');", true);
//Response.Write("<script language='javascript'>alert(\"" + ex.Message.Replace("\r\n", "").Replace("'", "") + "\");</script>");
}
}
protected void loadData()
{
if (!validData())
{
return;
}
try
{
/*实例化分页数据源*/
System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
/*建立业务层对象，执行查询，将记录集绑定到分页数据源上*/
//HourseBLL hourseBll = new HourseBLL();
//ps.DataSource = hourseBll.QueryHourseInfo(this.leixing.SelectedValue, xiaoqu.Text, lowprice.Text, highprice.Text).Tables[0].DefaultView;
string dat1, dat2;
string dep;
int is_qc = ddlCheckState.SelectedIndex;
dat1 = DateStart.Value;
dat2 = DateEnd.Value;
dep = txtDep.Text;
dat2 = Convert.ToDateTime(dat2).AddDays(1).ToString("yyyy/MM/dd");
string strSql = "dgcf_pad.dbo.usp_iqc";
SqlParameter[] parameters = { new SqlParameter("@is_qc", is_qc)
, new SqlParameter("@dep", dep)
, new SqlParameter("@dat1", dat1)
, new SqlParameter("@dat2", dat2)
, new SqlParameter("@mo1", txtFindMo1.Text)
, new SqlParameter("@mo2", txtFindMo2.Text)
, new SqlParameter("@item1", "")
, new SqlParameter("@item2", "") };
DataTable dtTranRec = sh.ExecuteProcedure(strSql, parameters);
txtShowRec.Text = dtTranRec.Rows.Count.ToString();
ps.DataSource = dtTranRec.DefaultView;
ps.AllowPaging = true;
ps.PageSize = 1000000; //每页显示几条记录
ps.CurrentPageIndex = curPage - 1; //设置当前页的索引(当前页码减1就是)
//this.firstBtn.Enabled = true;
//this.nextBtn.Enabled = true;
//this.prevBtn.Enabled = true;
//this.lastBtn.Enabled = true;
//this.CurrentPage.Text = curPage.ToString();
//this.TotalPage.Text = totalPage.ToString();
//if (curPage == 1)//当是第一页是.上一页和首页的按钮不可用
//{
// this.prevBtn.Enabled = false;
// this.firstBtn.Enabled = false;
//}
//if (curPage == ps.PageCount)//当是最后一页时下一页和最后一页的按钮不可用
//{
// this.nextBtn.Enabled = false;
// this.lastBtn.Enabled = false;
//}
this.wpDetail.DataSource = ps;
//this.hourseDataList.DataKeyField = "hourseId";
this.wpDetail.DataBind();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void LoadData()
{
if (!validData())
{
return;
}
string dat1, dat2;
string crdat1, crdat2;
string mo_group = "";
string user_id = "admin";
int period_type = dlShowPeriod.SelectedIndex;//過期類型報表
int f_type, mo_group_select;
crdat1 = createDateStart.Value;
crdat2 = createDateEnd.Value;
dat1 = orderDateStart.Value;
dat2 = orderDateEnd.Value;
if (dat2 != "")
{
dat2 = Convert.ToDateTime(dat2).AddDays(1).ToString("yyyy/MM/dd");
}
if (crdat2 != "")
{
crdat2 = Convert.ToDateTime(crdat2).AddDays(1).ToString("yyyy/MM/dd");
}
mo_group_select = dlMo_group.SelectedIndex;
mo_group = "ALL";
f_type = dlShowPeriod.SelectedIndex;//訂單發貨：全部，已發貨，未發貨
if (mo_group_select == -1 || dlMo_group.SelectedItem.ToString() == "" || mo_group_select == 0)
{
mo_group = "ALL";
}
else
{
if (mo_group_select <= 27)
{
mo_group = Convert.ToChar(64 + mo_group_select).ToString();
}
else
if (mo_group_select == 28) //PDD
{
mo_group = "PDD";
}
}
System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
string strSql = "usp_OcDelivStatus1";
SqlParameter[] parameters = { new SqlParameter("@f_type", f_type)
, new SqlParameter("@lang", lang_id)
, new SqlParameter("@mo_group", mo_group)
, new SqlParameter("@usr", user_id)
, new SqlParameter("@crdat1", crdat1),new SqlParameter("@crdat2", crdat2)
, new SqlParameter("@brand1", txtBrand.Text)
, new SqlParameter("@dat1", dat1), new SqlParameter("@dat2", dat2)
, new SqlParameter("@cust1", txtCust.Text)
, new SqlParameter("@po1", txtPoNo.Text)
, new SqlParameter("@mo1", txtMo1.Text)
, new SqlParameter("@mo2", txtMo2.Text) };
DataTable dtOc = sh.ExecuteProcedure(strSql, parameters);
ps.DataSource = dtOc.DefaultView;
this.wpDetail.DataSource = ps;
this.wpDetail.DataBind();
}
protected void FindByMoWip()
{
string mo_id = txtMo.Text.Trim().ToUpper();
//string strSql = "SELECT a.mo_id, b.flag,b.goods_state,b.transfers_state,b.goods_id" +
// ",CONVERT(VARCHAR(20),b.f_complete_date,120) AS f_complete_date,CONVERT(VARCHAR(20),b.t_complete_date,111) AS t_complete_date" +
// ",b.prod_qty, b.c_qty_ok,b.wp_id,d.name AS wp_name, b.next_wp_id" +
// ",e.name AS next_wp_name,b.state, b.hold,c.name AS goods_name" +
// " FROM dbo.jo_bill_mostly a " +
// " INNER JOIN dbo.jo_bill_goods_details b " +
// " ON a.within_code = b.within_code AND a.id = b.id AND a.ver = b.ver" +
// " LEFT JOIN dbo.it_goods c ON b.within_code=c.within_code AND b.goods_id=c.id" +
// " LEFT JOIN dbo.cd_department d ON b.within_code=d.within_code AND b.wp_id=d.id" +
// " LEFT JOIN dbo.cd_department e ON b.within_code=e.within_code AND b.next_wp_id=e.id" +
// " WHERE a.within_code = '" + within_code + "' AND a.mo_id = '" + mo_id + "'";
string sqlstr = "usp_ShowMoStatus";
int tb_type = 1;
SqlParameter[] parameters = { new SqlParameter("@tb_type", tb_type), new SqlParameter("@mo_id", mo_id), new SqlParameter("@goods_id", "") };
DataTable tbWip = sh.ExecuteProcedure(sqlstr, parameters);
if (tbWip.Rows.Count > 0)
{
string state = "";
int prod_qty, c_qty_ok;
for (int i = 0; i < tbWip.Rows.Count; i++)
{
prod_qty = (tbWip.Rows[i]["prod_qty"].ToString() != "" ? Convert.ToInt32(tbWip.Rows[i]["prod_qty"]) : 0);
c_qty_ok = (tbWip.Rows[i]["c_qty_ok"].ToString() != "" ? Convert.ToInt32(tbWip.Rows[i]["c_qty_ok"]) : 0);
state = tbWip.Rows[i]["mo_state"].ToString();
if (state == "G")
{
tbWip.Rows[i]["mo_state"] = "強制完成";
}
else
if (c_qty_ok >= prod_qty && prod_qty != 0)
{
tbWip.Rows[i]["mo_state"] = "完成";
}
else
if (prod_qty > c_qty_ok && prod_qty != 0)
{
tbWip.Rows[i]["mo_state"] = "未完成";
}
else
{
tbWip.Rows[i]["mo_state"] = "";
}
tbWip.Rows[i]["prod_qty"] = prod_qty.ToString();
tbWip.Rows[i]["c_qty_ok"] = c_qty_ok.ToString();
}
txtBill_date.Text = tbWip.Rows[0]["bill_date"].ToString();
txtRec_hk_date.Text = tbWip.Rows[0]["rec_hk_date"].ToString();
txtCust_req_date.Text = tbWip.Rows[0]["cust_req_date"].ToString();
}
else
{
tbWip.Rows.Add();
txtBill_date.Text = "";
txtRec_hk_date.Text = "";
txtCust_req_date.Text = "";
}
gvDetails.DataSource = tbWip.DefaultView;
gvDetails.DataBind();
for (int i = 0; i < gvDetails.Rows.Count; i++)
{
if (gvDetails.Rows[i].Cells[2].Text == "Y")
{
gvDetails.Rows[i].BackColor = System.Drawing.Color.FromArgb(0xFF, 0x33, 0x00);
}
}
if (gvDetails.Rows.Count > 1)
{
ShowImage(gvDetails.Rows[0].Cells[7].Text);
}
}
protected void loadData()
{
if (validData() == false)
{
return;
}
int show_details = 0; //顯示明細表記錄 1--匯總表記錄
if (chkShowSum.Checked == true) //顯示匯總表記錄
{
show_details = 1;
}
int show_price = 0;
string date1 = "";
string date2 = "";
string vend_id = "";
if (dlVend_id.SelectedIndex != 0)
{
vend_id = dlVend_id.Text.Trim();
}
string doc_id1 = txtDoc_id1.Text.Trim();
string doc_id2 = txtDoc_id2.Text.Trim();
string mo1 = txtMo1.Text.Trim();
string mo2 = txtMo2.Text.Trim();
string dep = txtDep.Text.Trim();
string prd_item = "";
date1 = txtDoc_date1.Text;
date2 = txtDoc_date2.Text;
//if (dlDeliverFlag.SelectedIndex == 2)//從已發貨中提取
// select_tb = 2;
//if (chkOut_type2.Checked == true)
show_price = dlSetPrice.SelectedIndex;
//if (vend_id == "")
//{
// Response.Write("<script>alert('供應商不能為空!');<" + "/" + "script>");
// txtVend_id.Focus();
// return;
//}
if (date2 != "")
{
date2 = Convert.ToDateTime(date2).AddDays(1).ToString("yyyy/MM/dd");
}
string sqlstr = "pu_DeliverSetPrice_find";
SqlParameter[] parameters = { new SqlParameter("@show_details", show_details), new SqlParameter("@show_price", show_price)
, new SqlParameter("@dep", dep), new SqlParameter("@vend_id", vend_id), new SqlParameter("@prd_item", prd_item)
, new SqlParameter("@doc_id1", doc_id1), new SqlParameter("@doc_id2", doc_id2)
, new SqlParameter("@date1", date1), new SqlParameter("@date2", date2) };
DataTable tbPu = sh.ExecuteProcedure(sqlstr, parameters);
if (show_details == 0)//顯示明細表記錄
{
gvDetails.DataSource = tbPu.DefaultView;
gvDetails.DataBind();
lblTotalRec.Text = " 記錄數: " + tbPu.Rows.Count.ToString();
}
else
{
lblTotalRec.Text = "匯總表";
gvSum.DataSource = tbPu.DefaultView;
gvSum.DataBind();
}
}