private void bindgrid(string strproduceserialno)
{
string strsql = "select * from tbmakelog where cnnproduceserialno=" + strproduceserialno;
DataTable dtMakeLog = Helper.Query(strsql);
if (dtMakeLog.Rows.Count == 0)
{
this.Popup("无法找到生产计划");
return;
}
Entity.MakeLog ml = new MakeLog(dtMakeLog);
string strsql1 = "select * from tbmakedetail where cnnCount>0 and cnnmakeserialno=" + ml.cnnMakeSerialNo.ToString();
DataTable dtMakeDetail = Helper.Query(strsql1);
string strsql2 = "select * from tbproducechecklog where cnnproduceserialno=" + strproduceserialno;
DataTable dtCheckLog = Helper.Query(strsql2);
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcInvName", "tbInventory", "cnvcInvCode", "cnvcInvName", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcProduceUnitCode", "tbInventory", "cnvcInvCode", "cnvcProduceUnitCode", "");
this.DataTableConvert(dtMakeDetail, "cnvcProduceUnitCode", "cnvcComUnitName", "tbComputationUnit", "cnvcComUnitCode", "cnvcComUnitName", "");
Helper.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnnCheckCount", dtCheckLog, "cnvcInvCode", "cnnCheckCount", "");
Helper.DataTableConvert(dtMakeDetail, "cnnMakeSerialNo", "cnnProduceSerialNo", dtMakeLog, "cnnMakeSerialNo", "cnnProduceSerialNo", "");
dtMakeDetail.Columns["cnnMakeCount"].ColumnName = "cnnOrderCount";
dtMakeDetail.Columns["cnnCount"].ColumnName = "cnnProduceCount";
//Session["tbProduceDetail"] = dtMakeDetail;
this.DataGrid1.DataSource = dtMakeDetail;
this.DataGrid1.DataBind();
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
Button2.Attributes["onClick"] = "javascript:return confirm(getwh());";
if (!this.IsPostBack)
{
this.BindDept(ddlProduceDept, "cnvcDeptType <>'Corp'");
if (Request["ProduceSerialNo"] == null)
{
Popup("无效链接");
return;
}
string strProduceSerialNo = Request["ProduceSerialNo"].ToString();
DataTable dt = Helper.Query("select * from tbmakelog where cnnproduceserialno=" + strProduceSerialNo);
if (dt.Rows.Count == 0)
{
this.Popup("搜索领用明细出错！");
return;
}
Entity.MakeLog ml = new MakeLog(dt);
string strMakeSerialNo = ml.cnnMakeSerialNo.ToString();
txtMakeSerialNo.Text = strMakeSerialNo;
BindProduceLog(strProduceSerialNo);
this.BindWarehouse(ddlWarehouse, "cnvcDepCode='" + this.ddlProduceDept.SelectedValue + "' and cnbFreeze=0");
BindGrid();
}
}
private void Button2_Click(object sender, System.EventArgs e)
{
//领料单打印
string strsql = "select * from tbmakelog where cnnproduceserialno=" + this.txtProduceSerialNo.Text;
DataTable dt = Helper.Query(strsql);
if (dt.Rows.Count == 0)
{
this.Popup("无法定位预估流水");
return;
}
Entity.MakeLog ml = new MakeLog(dt);
this.Response.Redirect("wfmMakeDetail.aspx?MakeType=0&MakeSerialNo=" + ml.cnnMakeSerialNo.ToString() + "&ProduceSerialNo=" + this.txtProduceSerialNo.Text);
}
protected void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
//btnPrint.Attributes.Add("onclick","return PrintDataGrid(document.all('DataGrid1'))");
if (!this.IsPostBack)
{
if (Request["MakeSerialNo"] == null)
{
Popup("无效链接");
return;
}
string strDetailSql = "";
string strMakeSerialNo = Request["MakeSerialNo"].ToString();
string strMakeType = Request["MakeType"].ToString();
string strMakeLogSql = "select * from tbMakeLog where cnnMakeSerialNo=" + strMakeSerialNo;
string strSql = "select cnvcCode,cnvcname,'' as Speci,cnvcunit,cnnCount from tbMakeDetail where cnnMakeSerialNo=" + strMakeSerialNo;
DataTable dtDetailtmp = Helper.Query(strSql);
MakeDetail mDetail = new MakeDetail(dtDetailtmp);
string strcode = mDetail.cnvcCode.ToString();
if (strcode.Length.ToString() != "5")
{
strDetailSql = "select cnvcCode,cnvcname,'' as Speci,cnvcunit,cnnCount from tbMakeDetail where cnnMakeSerialNo=" + strMakeSerialNo;
}
else
{
strDetailSql = "select a.cnvcCode,a.cnvcname,convert(varchar,b.cnnStatdardCount)+ b.cnvcUnit + '/'+cnvcStandardUnit as Speci,a.cnvcunit,a.cnnCount from tbMakeDetail a,tbMaterial b where a.cnvcCode=b.cnvcMaterialCode and cnnMakeSerialNo=" + strMakeSerialNo;
}
DataTable dtDetail = Helper.Query(strDetailSql);
DataTable dtMakeLog = Helper.Query(strMakeLogSql);
MakeLog mLog = new MakeLog(dtMakeLog);
if (mLog.cnvcMakeType == "0")
{
this.DataGrid1.Caption = mLog.cnvcMakeName + DateTime.Now.ToString("yyyy年MM月dd日") + "<br><div align='left'>生产流水：" + mLog.cnnProduceSerialNo.ToString() + " 制令流水：" + strMakeSerialNo + "</div>";
this.DataGrid1.DataSource = dtDetail;
this.DataGrid1.DataBind();
}
else
{
this.Datagrid2.Caption = mLog.cnvcMakeName + DateTime.Now.ToString("yyyy年MM月dd日") + "<br><div align='left'>生产流水：" + mLog.cnnProduceSerialNo.ToString() + " 制令流水：" + strMakeSerialNo + "</div>";
this.Datagrid2.DataSource = dtDetail;
this.Datagrid2.DataBind();
}
//Session["toExcel"] = dtDetail;
}
}
private string BuildLogException(string identifier, Exception ex)
{
string messageError = MessagesOfReturn.ExceptionMessageLogSupport(_contentFile.Message, identifier, _contentFile.NumberOfMessage);
string detailProcess = "";
if (_contentFile.NumberOfMessage == NumberOfMessage.One)
{
detailProcess = MessagesOfReturn.DetailProcessWithIdBroker(_contentFile.Message, identifier);
}
else
{
detailProcess = MessagesOfReturn.DetailProcessWithSblen(_contentFile.Message, identifier);
}
int codeMessageError = MakeLog.BuildErrorLogSupport(ex, messageError, detailProcess);
return(MessagesOfReturn.ExceptionMessageLogUser(codeMessageError, messageError));
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
btnCheck.Attributes["onClick"] = "javascript:return confirm(getwh());";
if (!this.IsPostBack)
{
this.BindDept(ddlProduceDept, "cnvcDeptType <>'Corp'");
//this.BindDept(ddlOrderDept, "cnvcDeptType <>'Corp'");
//ListItem li = new ListItem("所有", "%");
//ddlOrderDept.Items.Insert(0, li);
//this.BindNameCode(ddlGroup, "cnvcType='GROUP'");
if (Request["ProduceSerialNo"] == null)
{
Popup("无效链接");
return;
}
//string strOperType = Request["OperType"].ToString();
//ViewState["OperType"] = strOperType;
string strProduceSerialNo = Request["ProduceSerialNo"].ToString();
DataTable dt = Helper.Query("select * from tbmakelog where cnnproduceserialno=" + strProduceSerialNo);
if (dt.Rows.Count == 0)
{
this.Popup("搜索领用明细出错！");
return;
}
Entity.MakeLog ml = new MakeLog(dt);
string strMakeSerialNo = ml.cnnMakeSerialNo.ToString();
txtMakeSerialNo.Text = strMakeSerialNo;
BindProduceLog(strProduceSerialNo);
this.BindWarehouse(ddlWarehouse, "cnvcDepCode='" + this.ddlProduceDept.SelectedValue + "' and cnbFreeze=0");
QueryProduceDetail();
btnQuery_Click(null, null);
//this.txtExpDate.Text = DateTime.Now.AddDays(this.ExpDate).ToString("yyyy-MM-dd");
txtDays.Text = "0";
}
}
/// <summary>
/// Instancia as classes do tipo Mensagem do BL.Command
/// e invoca o método SwapXmlWithGTE
/// </summary>
/// <returns></returns>
public void StartChangeXML()
{
for (int i = 0; i < 5; i++)
{
string retorno = "";
int message = i + 1;
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
try
{
//Recarrega o contexto
ChangeXMLContext.ReloadContext();
//Define qual Mensagem instanciar
string objeto = "BL.Command.Mensagem" + message;
//Instancia a Mensagem
var classe = Activator.CreateInstance(null, objeto);
IMessage mensagem = (IMessage)classe.Unwrap();
//Efetua a troca da Mensagem com o Web Service
retorno += mensagem.Execute();
}
catch (Exception ex)
{
string messageError = MessagesOfReturn.ExceptionMessageLogSupport($"Message {message}", null, GetNumberOfMessage(message));
int codeMessageError = MakeLog.BuildErrorLogSupport(ex, messageError, "RunMessenger");
messageError = $"Erro Faltal{Environment.NewLine}";
retorno += MessagesOfReturn.ExceptionMessageLogUser(codeMessageError, message.ToString());
}
finally
{
stopwatch.Stop();
MakeLog.BuildLogUser(retorno, GetNumberOfMessage(message), stopwatch.Elapsed);
}
}
}
private void QueryProduceDetail()
{
// string strSql = "select a.cnnProduceSerialNo,a.cnvcInvCode,a.cnnProduceCount as cnnOrderCount,a.cnnProduceCount,isnull(b.cnnCheckCount,0) as cnnCheckCount,isnull(b.cnnAssignCount,0) as cnnAssignCount from tbProduceDetail a left outer join tbProduceCheckLog b"
// +" on a.cnnProduceSerialNo=b.cnnProduceSerialNo and a.cnvcInvCode=b.cnvcInvCode where a.cnnProduceSerialNo=" + txtProduceSerialNo.Text+" order by a.cnvcInvCode";
// DataTable dtProduce = Helper.Query(strSql);
string strsql = "select * from tbmakelog where cnnproduceserialno=" + this.txtProduceSerialNo.Text;
DataTable dtMakeLog = Helper.Query(strsql);
if (dtMakeLog.Rows.Count == 0)
{
this.Popup("无法找到生产计划");
return;
}
Entity.MakeLog ml = new MakeLog(dtMakeLog);
string strsql1 = "select * from tbmakedetail where cnncount>0 and cnnmakeserialno=" + ml.cnnMakeSerialNo.ToString();
DataTable dtMakeDetail = Helper.Query(strsql1);
string strsql2 = "select * from tbproducechecklog where cnnproduceserialno=" + this.txtProduceSerialNo.Text;
DataTable dtCheckLog = Helper.Query(strsql2);
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcInvName", "tbInventory", "cnvcInvCode", "cnvcInvName", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcProduceUnitCode", "tbInventory", "cnvcInvCode", "cnvcProduceUnitCode", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcInvStd", "tbInventory", "cnvcInvCode", "cnvcInvStd", "");
this.DataTableConvert(dtMakeDetail, "cnvcProduceUnitCode", "cnvcComUnitName", "tbComputationUnit", "cnvcComUnitCode", "cnvcComUnitName", "");
Helper.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnnCheckCount", dtCheckLog, "cnvcInvCode", "cnnCheckCount", "");
Helper.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnbInWh", dtCheckLog, "cnvcInvCode", "cnbInWh", "");
//Helper.DataTableConvert(dtMakeDetail,"cnnMakeSerialNo","cnnProduceSerialNo",dtMakeLog,"cnnMakeSerialNo","cnnProduceSerialNo","");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcSTComUnitCode", "tbInventory", "cnvcInvCode", "cnvcSTComUnitCode", "");
this.DataTableConvert(dtMakeDetail, "cnvcSTComUnitCode", "cnvcSTComUnitName", "tbComputationUnit", "cnvcComUnitCode", "cnvcComUnitName", "");
this.DataTableConvert(dtMakeDetail, "cnvcProduceUnitCode", "cniChangeRate", "tbComputationUnit", "cnvcComUnitCode", "cniChangRate", "");
this.DataTableConvert(dtMakeDetail, "cnvcSTComUnitCode", "cniChangeRate_st", "tbComputationUnit", "cnvcComUnitCode", "cniChangRate", "");
//this.DataTableConvert(dtMakeDetail,"cnvcInvCode","cnvcGroupCode","tbInventory","cnvcInvCode","cnvcGroupCode","");
//this.DataTableConvert(dtMakeDetail,"cnvcInvCode","cnvcGroupCode","tbInventory","cnvcInvCode","cnvcGroupCode","");
//this.DataTableConvert(dtMakeDetail,"cnvcGroupCode","cnvcComUnitCode_main","tbComputationUnit","cnvcGroupCode","cnvcComUnitCode","cnbMainUnit=1");
//this.DataTableConvert(dtMakeDetail,"cnvcComUnitCode_main","cniChangeRate_main","tbComputationUnit","cnvcGroupCode","cniChangRate","");
dtMakeDetail.Columns.Add("cnnInCount");
//DataTable dtUnit = Application["tbComputationUnit"] as DataTable;
foreach (DataRow dr in dtMakeDetail.Rows)
{
// if(dr["cnnCheckCount"].ToString() == "")
// {
// dr["cnnCheckCount"] = 0;
// }
// if(dr["cniChangeRate_st"].ToString() == "")
// dr["cniChangeRate_st"] = "1";
// if(dr["cniChangeRate_main"].ToString() == "")
// dr["cniChangeRate_main"] = 1;
//string strcomunitcode = dr["cnvcproduceunitcode"].ToString();
//string strcomunitcode_main = dr["cnvcComUnitCode_main"].ToString();
decimal dcheckcount = Convert.ToDecimal(dr["cnncheckcount"].ToString());
decimal dchangerate = Convert.ToDecimal(dr["cniChangeRate"].ToString());
decimal dchangerate_st = Convert.ToDecimal(dr["cniChangeRate_st"].ToString());
//decimal dchangerate_main = Convert.ToDecimal(dr["cniChangeRate_main"].ToString());
// if(strcomunitcode == strcomunitcode_main)
// {
// dr["cnnInCount"] = (dchangerate/dchangerate_st) * dcheckcount;
// }
// else
// {
dr["cnnInCount"] = Math.Round((dchangerate / dchangerate_st) * dcheckcount, 2);
//}
}
dtMakeDetail.Columns["cnnMakeCount"].ColumnName = "cnnOrderCount";
dtMakeDetail.Columns["cnnCount"].ColumnName = "cnnProduceCount";
Session["tbProduceDetail"] = dtMakeDetail;
}
private void BindGrid()
{
string strProduceSerialNo = txtProduceSerialNo.Text;
string strsql1 = "select * from tbMakeLog where cnnProduceSerialNo=" + strProduceSerialNo;
DataTable dtMakeLog = Helper.Query(strsql1);
if (dtMakeLog.Rows.Count == 0)
{
//this.Popup("无法定位生产计划");
return;
}
Entity.MakeLog ml = new MakeLog(dtMakeLog);
string strsql2 = "select * from tbMakeDetail where cnnMakeSerialNo=" + ml.cnnMakeSerialNo.ToString();
DataTable dtMakeDetail = Helper.Query(strsql2);
// string strSql = @"select a.*,b.cnvcOperID,b.cndOperDate from tbMakeDetail a
//left outer join tbMakeLog b on b.cnnMakeSerialNo=b.cnnMakeSerialNo
//where b.cnnProduceSerialNo=" + strProduceSerialNo;
// DataTable dtMakeLog = Helper.Query(strSql);
Helper.DataTableConvert(dtMakeDetail, "cnnMakeSerialNo", "cnvcOperID", dtMakeLog, "cnnMakeSerialNo", "cnvcOperID", "");
Helper.DataTableConvert(dtMakeDetail, "cnnMakeSerialNo", "cndOperDate", dtMakeLog, "cnnMakeSerialNo", "cndOperDate", "");
this.DataTableConvert(dtMakeDetail, "cnvcOperID", "tbLogin", "vcLoginID", "vcOperName", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcInvName", "tbInventory", "cnvcInvCode", "cnvcInvName", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcProduceUnitCode", "tbInventory", "cnvcInvCode", "cnvcProduceUnitCode", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcComUnitCode", "tbInventory", "cnvcInvCode", "cnvcComUnitCode", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcStComUnitCode", "tbInventory", "cnvcInvCode", "cnvcStComUnitCode", "");
//this.DataTableConvert(dtMakeLog,"cnvcInvCode","cnbSelf","tbInventory","cnvcInvCode","cnbSelf","");
this.DataTableConvert(dtMakeDetail, "cnvcProduceUnitCode", "cnvcComUnitName", "tbComputationUnit", "cnvcComUnitCode", "cnvcComUnitName", "");
this.DataTableConvert(dtMakeDetail, "cnvcStComUnitCode", "cnvcStComUnitName", "tbComputationUnit", "cnvcComUnitCode", "cnvcComUnitName", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcInvCCode", "tbInventory", "cnvcInvCode", "cnvcInvCCode", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCCode", "cnvcProductClass", "tbProductClass", "cnvcProductClassCode", "cnvcProductClassName", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCCode", "cnvcProductType", "tbProductClass", "cnvcProductClassCode", "cnvcProductType", "");
this.DataTableConvert(dtMakeDetail, "cnvcProductType", "cnvcProductTypeName", "tbNameCode", "cnvcCode", "cnvcName", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcInvName", "tbInventory", "cnvcInvCode", "cnvcInvName", "");
this.DataTableConvert(dtMakeDetail, "cnvccomunitcode", "cnnchangrate", "tbComputationUnit", "cnvccomunitcode", "cnichangrate", "");
//this.DataTableConvert(dtMakeDetail,"cnvcproduceunitcode","cnnchangrate_pd","tbComputationUnit","cnvccomunitcode","cnichangrate","");
this.DataTableConvert(dtMakeDetail, "cnvcstcomunitcode", "cnnchangrate_st", "tbComputationUnit", "cnvccomunitcode", "cnichangrate", "");
// string strSql = @"select cnvcInvCode,sum(cnnAvaQuantity) as cnnwhcount from tbCurrentStock where cnvcWhCOde
//in (select cnvcWhCOde from tbwarehouse where cnvcDepCode='"+this.ddlProduceDept.SelectedValue+"')"
//+" and CONVERT(char(10),isnull(cndExpDate,''),121)>=CONVERT(char(10),getdate(),121) "
//+"group by cnvcInvCode";
string strSql = @"select cnvcInvCode,sum(cnnAvaQuantity) as cnnwhcount from tbCurrentStock where cnvcWhCOde
='" + this.ddlWarehouse.SelectedValue + "'"
+ " and CONVERT(char(10),isnull(cndExpDate,''),121)>=CONVERT(char(10),getdate(),121) "
+ "group by cnvcInvCode";
DataTable dtwh = Helper.Query(strSql);
Helper.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnnwhcount", dtwh, "cnvcInvCode", "cnnwhcount", "");
foreach (DataRow dr in dtMakeDetail.Rows)
{
if (dr["cnnchangrate"].ToString() == "")
{
this.Popup("无此产品代码：" + dr["cnvcInvCode"].ToString() + "的产品！");
return;
}
double dchangerate = Convert.ToDouble(dr["cnnchangrate"].ToString());
double dchangerate_st = Convert.ToDouble(dr["cnnchangrate_st"].ToString());
//double dchangerate_pd = Convert.ToDouble(dr["cnnchangrate_pd"].ToString());
string strwh = dr["cnnwhcount"].ToString();
decimal dwh = 0;
if (strwh != "")
{
//dwh = Convert.ToDecimal(Math.Floor(Convert.ToDouble(strwh)*dchangerate/dchangerate_st));
dwh = Convert.ToDecimal(Math.Round(Convert.ToDouble(strwh) * dchangerate / dchangerate_st, 4));
}
dr["cnnwhcount"] = dwh;
}
DataView dvMake = new DataView(dtMakeDetail);
dvMake.Sort = "cnvcProductType asc,cnvcInvCCode asc";
this.DataGrid1.DataSource = dvMake;
this.DataGrid1.DataBind();
}
private void QueryProduceDetail()
{
// string strSql = "select a.cnnProduceSerialNo,a.cnvcInvCode,a.cnnProduceCount as cnnOrderCount,a.cnnProduceCount,isnull(b.cnnCheckCount,0) as cnnCheckCount,isnull(b.cnnAssignCount,0) as cnnAssignCount from tbProduceDetail a left outer join tbProduceCheckLog b"
// +" on a.cnnProduceSerialNo=b.cnnProduceSerialNo and a.cnvcInvCode=b.cnvcInvCode where a.cnnProduceSerialNo=" + txtProduceSerialNo.Text+" order by a.cnvcInvCode";
// DataTable dtProduce = Helper.Query(strSql);
string strsql = "select * from tbmakelog where cnnproduceserialno=" + this.txtProduceSerialNo.Text;
DataTable dtMakeLog = Helper.Query(strsql);
if (dtMakeLog.Rows.Count == 0)
{
this.Popup("无法找到生产计划");
return;
}
Entity.MakeLog ml = new MakeLog(dtMakeLog);
string strsql1 = "select * from tbmakedetail where cnnCount>0 and cnnmakeserialno=" + ml.cnnMakeSerialNo.ToString();
DataTable dtMakeDetail = Helper.Query(strsql1);
string strsql2 = "select * from tbproducechecklog where cnnproduceserialno=" + this.txtProduceSerialNo.Text;
DataTable dtCheckLog = Helper.Query(strsql2);
//dtMakeDetail.Columns.Add("cnnCheckCount");
string strpdsql = "select * from tbProduceDetail where cnnProduceSerialNo=" + this.txtProduceSerialNo.Text;
DataTable dtpd = Helper.Query(strpdsql);
Helper.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcIsNew", dtpd, "cnvcInvCode", "cnnOrderCount", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcInvCCode", "tbInventory", "cnvcInvCode", "cnvcInvCCode", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCCode", "cnvcProductType", "tbProductClass", "cnvcProductClassCode", "cnvcProductType", "");
if (dtCheckLog.Rows.Count == 0)
{
Helper.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnnCheckCount", dtMakeDetail, "cnvcInvCode", "cnnCount", "");
dtMakeDetail.Columns.Add("cnnTeamID");
dtMakeDetail.Columns.Add("cnnProducerID");
foreach (DataRow dr in dtMakeDetail.Rows)
{
if (dr["cnnCheckCount"].ToString() == "")
{
dr["cnnCheckCount"] = 0;
}
if (dr["cnvcProductType"].ToString() != "FINALPRODUCT" && dr["cnvcIsNew"].ToString() == "")
{
dr["cnnCheckCount"] = 0;
}
}
}
else
{
Helper.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnnCheckCount", dtCheckLog, "cnvcInvCode", "cnnCheckCount", "");
Helper.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnnTeamID", dtCheckLog, "cnvcInvCode", "cnnTeamID", "");
Helper.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnnProducerID", dtCheckLog, "cnvcInvCode", "cnnProducerID", "");
}
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcInvName", "tbInventory", "cnvcInvCode", "cnvcInvName", "");
this.DataTableConvert(dtMakeDetail, "cnvcInvCode", "cnvcProduceUnitCode", "tbInventory", "cnvcInvCode", "cnvcProduceUnitCode", "");
this.DataTableConvert(dtMakeDetail, "cnvcProduceUnitCode", "cnvcComUnitName", "tbComputationUnit", "cnvcComUnitCode", "cnvcComUnitName", "");
Helper.DataTableConvert(dtMakeDetail, "cnnMakeSerialNo", "cnnProduceSerialNo", dtMakeLog, "cnnMakeSerialNo", "cnnProduceSerialNo", "");
// string strSql = "select * from tbteam";
// DataTable dtTeam = Helper.Query(strSql);
// Helper.DataTableConvert(dtMakeDetail,"cnnTeamID","cnvcTeamName",dtTeam,"cnnTeamID","cnvcTeamName","");
// strSql = "select * from tbproducer";
// DataTable dtProducer = Helper.Query(strSql);
// Helper.DataTableConvert(dtMakeDetail,"cnnProducerID","cnvcProducerName",dtProducer,"cnnProducerID","cnvcProducerName","");
dtMakeDetail.Columns["cnnMakeCount"].ColumnName = "cnnOrderCount";
dtMakeDetail.Columns["cnnCount"].ColumnName = "cnnProduceCount";
Session["tbProduceDetail"] = dtMakeDetail;
}
