public static string Click_Save(string CWAR, string ITEM, string CLOT, string LOCA, string QTYS, string UNIT) { //int consecutivoPalletID = 0; //DataTable DTPalletContinue = twhcol130DAL.PaidMayorwhcol130("INITIAPOP-P"); //string SecuenciaPallet = "001"; //if (DTPalletContinue.Rows.Count > 0) //{ // foreach (DataRow item in DTPalletContinue.Rows) // { // string paid = item["T$PAID"].ToString().Trim(); // int indesSep = item["T$PAID"].ToString().Trim().IndexOf("-P"); // string secuence = paid.Substring(indesSep + 1); // consecutivoPalletID = Convert.ToInt32(secuence)+1; // if (consecutivoPalletID.ToString().Length == 1) // { // SecuenciaPallet = "P00" + consecutivoPalletID; // } // if (consecutivoPalletID.ToString().Length == 2) // { // SecuenciaPallet = "P0" + consecutivoPalletID; // } // if (consecutivoPalletID.ToString().Length == 3) // { // SecuenciaPallet = "P"+consecutivoPalletID.ToString(); // } // } //} Ent_ttwhcol016 data016 = new Ent_ttwhcol016();; string retorno = string.Empty; string strError = string.Empty; data016.zone = serieLabelRM; DataTable dat016 = ITtwhcol016.VerificaCons_Serie_Label(ref data016, ref strError); int actcontador = ITtwhcol016.actualizarContadores(ref data016, ref strError); //string SecuenciaPallet = "C"; string consecutivo = dat016.Rows[0]["CONSEC"].ToString().PadLeft(3, '0'); string serie = dat016.Rows[0]["SEQ"].ToString(); if (consecutivo == "990") { data016.serietemp = Convert.ToInt32(dat016.Rows[0]["SEQ"].ToString()) + 1; int retconser = ITtwhcol016.ActualizarSerie_Consecutivo(ref data016, ref strError); } if (consecutivo == "998") { data016.serietemp = Convert.ToInt32(dat016.Rows[0]["SEQ"].ToString()); int retconser = ITtwhcol016.DesactivarSerie_Consecutivo(ref data016, ref strError); } string id = CLOT.Trim() == "" ? cyclecountLabelRM : CLOT.Trim(); string sqnb = cyclecountLabelRM.Trim() + serie.Trim() + "-" + consecutivo; Ent_twhcol130131 MyObj = new Ent_twhcol130131 { OORG = "2",// Order type escaneada view //ORNO = "INITIAPOP", ORNO = cyclecountLabelRM.Trim() + serie.Trim(), ITEM = ITEM.ToUpper(), //PAID = "INITIAPOP" + "-" + SecuenciaPallet, PAID = sqnb, PONO = "1", SEQN = "1", CLOT = CLOT.ToUpper(), // lote VIEW CWAR = CWAR.ToUpper(), QTYS = QTYS, // cantidad escaneada view QTYA = QTYS, UNIT = UNIT, //unit escaneada view QTYC = QTYS, //cantidad escaneada view aplicando factor UNIC = UNIT, //unidad view stock DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //fecha de confirmacion CONF = "1", RCNO = " ", //llena baan DATR = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //llena baan LOCA = LOCA.ToUpper(), // enviamos vacio DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //llenar con fecha de hoy PRNT = "1", // llenar en 1 DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //llena baan NPRT = "1", //conteo de reimpresiones LOGN = HttpContext.Current.Session["user"].ToString(), // nombre de ususario de la session LOGT = " ", //llena baan STAT = "3", // LLENAR EN 3 DSCA = " ", COTP = " ", FIRE = "2", PSLIP = " ", ALLO = "0", //PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "INITIAPOP" + "-" + SecuenciaPallet + "&code=Code128&dpi=96", PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "INITIAPOP" + "-" + sqnb + "&code=Code128&dpi=96", ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "DTOrdencompra.Rows[0][].ToString()" + "&code=Code128&dpi=96", ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + ITEM + "&code=Code128&dpi=96", CLOT_URL = CLOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + CLOT + "&code=Code128&dpi=96" : "", QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + QTYS + "&code=Code128&dpi=96", UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + UNIT + "&code=Code128&dpi=96" }; string StrError = string.Empty; bool Insertsucces = twhcol130DAL.Insertartwhcol131(MyObj, ref StrError); if (Insertsucces) { HttpContext.Current.Session["MaterialDesc"] = "XXXXX XXX XXX XX"; HttpContext.Current.Session["MaterialCode"] = MyObj.ITEM; HttpContext.Current.Session["codePaid"] = MyObj.PAID; HttpContext.Current.Session["Lot"] = MyObj.CLOT; HttpContext.Current.Session["Quantity"] = MyObj.QTYS + " " + UNIT; HttpContext.Current.Session["Origin"] = MyObj.CLOT; HttpContext.Current.Session["Supplier"] = ""; HttpContext.Current.Session["RecibedBy"] = MyObj.LOGN; HttpContext.Current.Session["RecibedOn"] = DateTime.Now.ToString("MM/dd/yyyy"); HttpContext.Current.Session["Reprint"] = "no"; } else { MyObj.error = true; MyObj.TypeMsgJs = "label"; MyObj.errorMsg = "Error insert"; } return(JsonConvert.SerializeObject(MyObj)); }
protected void Save_Click(object sender, EventArgs e) { string ITEM = HttpContext.Current.Session["ITEM"].ToString(); string CWAR = HttpContext.Current.Session["CWAR"].ToString(); string CLOT = HttpContext.Current.Session["CLOT"].ToString(); string LOCA = HttpContext.Current.Session["LOCA"].ToString(); string QTYS = HttpContext.Current.Session["QTYS"].ToString(); string UNIT = HttpContext.Current.Session["UNIT"].ToString(); string CUNI = HttpContext.Current.Session["CUNI"].ToString(); Ent_tticol022 data022; Ent_tticol042 data042; string strError = string.Empty; //JC 020801 Conseguir el último consecutivo de la serie NFP definida en baan Ent_ttwhcol016 data016 = new Ent_ttwhcol016();; string retorno = string.Empty; data016.zone = serieLabelFP; DataTable dat016 = _idaltwhcol016.VerificaCons_Serie_Label(ref data016, ref strError); int actcontador = _idaltwhcol016.actualizarContadores(ref data016, ref strError); //string SecuenciaPallet = "C"; string consecutivo = dat016.Rows[0]["CONSEC"].ToString().PadLeft(3, '0'); string serie = dat016.Rows[0]["SEQ"].ToString(); if (consecutivo == "990") { data016.serietemp = Convert.ToInt32(dat016.Rows[0]["SEQ"].ToString()) + 1; int retconser = _idaltwhcol016.ActualizarSerie_Consecutivo(ref data016, ref strError); } if (consecutivo == "998") { data016.serietemp = Convert.ToInt32(dat016.Rows[0]["SEQ"].ToString()); int retconser = _idaltwhcol016.DesactivarSerie_Consecutivo(ref data016, ref strError); } string id = CLOT.Trim() == "" ? cyclecountLabel : CLOT.Trim(); string sqnb = cyclecountLabel.Trim() + serie.Trim() + "-" + consecutivo; //if (HttpContext.Current.Session["myItemType"].ToString().Trim() != "RET") //{ //string id = cyclecountLabel; //JC 020821 Conseguir el último consecutivo de la serie NFP ya no se buscará el consecutivo por orden //DataTable Dtticol022 = _idaltticol022.SecuenciaMayor(id); //if (Dtticol022.Rows.Count > 0) //{ //int res; //string sqnb = Dtticol022.Rows[0]["T$SQNB"].ToString().Trim() == "" ? SecuenciaPallet : Dtticol022.Rows[0]["T$SQNB"].ToString().Trim(); //int iSep = sqnb.IndexOf("-"); //string CurrentSecuence = sqnb.Substring(iSep + 1).Replace("C",""); // //consecutivo = Convert.ToInt32(CurrentSecuence)+1; //consecutivo = CurrentSecuence + 1; //} //else //{ // //consecutivo = 1; // consecutivo = "1"; //} //} //else //{ // //string id = CLOT.Trim() == "" ? ITEM.Trim() : CLOT.Trim(); // //string id = cyclecountLabel; // DataTable Dtticol042 = _idaltticol042.SecuenciaMayor(id); // if (Dtticol042.Rows.Count > 0) // { // int res; // string sqnb = Dtticol042.Rows[0]["T$SQNB"].ToString().Trim(); // int iSep = sqnb.IndexOf("-"); // string CurrentSecuence = sqnb.Substring(iSep + 1).Replace("C", ""); // //consecutivo = Convert.ToInt32(CurrentSecuence)+1; // consecutivo = CurrentSecuence + 1; // } // else // { // //consecutivo = 1; // consecutivo = "1"; // } //} //JC 020821 Conseguir el último consecutivo de la serie NFP ya no se buscará el consecutivo por orden //if (consecutivo.ToString().Length == 1) //{ // SecuenciaPallet = "C00" + consecutivo.ToString(); //} //if (consecutivo.ToString().Length == 2) //{ // SecuenciaPallet = "C0" + consecutivo.ToString(); //} //if (consecutivo.ToString().Length == 3) //{ // SecuenciaPallet = "C0" + consecutivo.ToString(); //} if (HttpContext.Current.Session["myItemType"].ToString().Trim() != "RET") { data022 = new Ent_tticol022(); data022.pdno = CLOT == "" ? cyclecountLabel.Trim() + serie.Trim() : CLOT.Trim(); //data022.sqnb = (CLOT == "" ? cyclecountLabel : CLOT.Trim()) + "-" + SecuenciaPallet; data022.sqnb = sqnb; data022.proc = 2; data022.logn = HttpContext.Current.Session["user"].ToString(); data022.mitm = ITEM.Trim(); data022.qtdl = Convert.ToDecimal(QTYS); data022.cuni = CUNI; data022.log1 = "NONE"; data022.qtd1 = Convert.ToInt32(Convert.ToDecimal(QTYS)); data022.pro1 = 2; data022.log2 = "NONE"; data022.qtd2 = Convert.ToInt32(Convert.ToDecimal(QTYS)); data022.pro2 = 2; data022.loca = " "; data022.norp = 1; data022.dele = 7; data022.logd = "NONE"; data022.refcntd = 0; data022.refcntu = 0; data022.drpt = DateTime.Now; data022.urpt = HttpContext.Current.Session["user"].ToString(); data022.acqt = Convert.ToDecimal(QTYS); data022.cwaf = CWAR; data022.cwat = CWAR; data022.aclo = LOCA; data022.allo = 0; HttpContext.Current.Session["strOrden"] = data022.pdno; HttpContext.Current.Session["strSecuen"] = data022.sqnb; HttpContext.Current.Session["itemId"] = data022.mitm; HttpContext.Current.Session["cantidad"] = data022.acqt; HttpContext.Current.Session["bodega"] = data022.cwaf; HttpContext.Current.Session["usuario"] = data022.urpt; HttpContext.Current.Session["fecha"] = data022.drpt; HttpContext.Current.Session["descItem"] = data022.mitm; HttpContext.Current.Session["unidad"] = data022.cuni; HttpContext.Current.Session["strTagId"] = ""; var validateSave = _idaltticol022.insertarRegistroSimple(ref data022, ref strError); var validateSaveTicol222 = _idaltticol022.InsertarRegistroTicol222(ref data022, ref strError); //return JsonConvert.SerializeObject(data022); if (Convert.ToBoolean(validateSave) && Convert.ToBoolean(validateSaveTicol222)) { HttpContext.Current.Session["MaterialDesc"] = data022.mitm; HttpContext.Current.Session["codeMaterial"] = data022.mitm; HttpContext.Current.Session["codePaid"] = data022.sqnb; HttpContext.Current.Session["Lot"] = CLOT; HttpContext.Current.Session["Quantity"] = data022.acqt + " " + data022.cuni; HttpContext.Current.Session["Date"] = DateTime.Now.ToString("MM/dd/yyyy"); HttpContext.Current.Session["Pallet"] = data022.sqnb; HttpContext.Current.Session["Machine"] = _idaltticol022.getMachine(CLOT, ITEM.Trim().ToUpper(), ref strError); HttpContext.Current.Session["Operator"] = _operator; HttpContext.Current.Session["Reprint"] = "no"; StringBuilder script = new StringBuilder(); if (HttpContext.Current.Session["navigator"].ToString() == "EDG") { script.Append("myLabelFrame = document.getElementById('myLabelFrame'); myLabelFrame.src ='../Labels/RedesingLabels/4FinishedCupsME.aspx'; "); } else { script.Append("myLabelFrame = document.getElementById('myLabelFrame'); myLabelFrame.src ='../Labels/RedesingLabels/4FinishedCups.aspx'; "); } ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); //StringBuilder script = new StringBuilder(); //script.Append("ventanaImp = window.open('../Labels/RedesingLabels/4FinishedCups.aspx', "); //script.Append("'ventanaImp', 'menubar=0,resizable=0,width=700,height=450');"); //script.Append("ventanaImp.moveTo(30, 0);"); ////script.Append("setTimeout (ventanaImp.close(), 20000);"); //ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); //StringBuilder script = new StringBuilder(); //script.Append("ventanaImp = window.open('../Labels/whInvLabelFinishProduct.aspx', "); //script.Append("'ventanaImp', 'menubar=0,resizable=0,width=580,height=450');"); //script.Append("ventanaImp.moveTo(30, 0);"); ////script.Append("setTimeout (ventanaImp.close(), 20000);"); //ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); } else { StringBuilder script = new StringBuilder(); string alert = "alert('" + strError.Replace("\n", "") + "')"; script.Append(alert); ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); } } else { data042 = new Ent_tticol042() { pdno = CLOT == "" ? cyclecountLabel.Trim() + serie.Trim() : CLOT, //sqnb = (CLOT == "" ? cyclecountLabel : CLOT) + "-" + SecuenciaPallet, sqnb = sqnb, proc = 2, logn = HttpContext.Current.Session["user"].ToString(), mitm = ITEM.Trim(), qtdl = Convert.ToDouble(QTYS), cuni = CUNI, log1 = "NONE", qtd1 = Convert.ToDecimal(QTYS), pro1 = 2, log2 = "NONE", qtd2 = Convert.ToDecimal(QTYS), pro2 = 2, loca = " ", norp = 1, dele = 7, logd = "NONE", refcntd = 0, refcntu = 0, drpt = DateTime.Now, urpt = HttpContext.Current.Session["user"].ToString(), acqt = Convert.ToDouble(QTYS), cwaf = CWAR, cwat = CWAR, aclo = LOCA, allo = 0 }; HttpContext.Current.Session["strOrden"] = data042.pdno; HttpContext.Current.Session["strSecuen"] = data042.sqnb; HttpContext.Current.Session["itemId"] = data042.mitm; HttpContext.Current.Session["cantidad"] = data042.acqt; HttpContext.Current.Session["bodega"] = data042.cwaf; HttpContext.Current.Session["usuario"] = data042.urpt; HttpContext.Current.Session["fecha"] = data042.drpt; HttpContext.Current.Session["descItem"] = data042.mitm; HttpContext.Current.Session["unidad"] = data042.cuni; HttpContext.Current.Session["strTagId"] = ""; var validateSave = _idaltticol042.insertarRegistroSimpleD(ref data042, ref strError); var validateSaveTicol242 = _idaltticol042.InsertarRegistroTicol242(ref data042, ref strError); //return JsonConvert.SerializeObject(data042); if (Convert.ToBoolean(validateSave) && Convert.ToBoolean(validateSaveTicol242)) { HttpContext.Current.Session["MaterialDesc"] = data042.mitm; HttpContext.Current.Session["codeMaterial"] = data042.mitm; HttpContext.Current.Session["codePaid"] = data042.sqnb; HttpContext.Current.Session["Lot"] = CLOT; HttpContext.Current.Session["Quantity"] = data042.acqt + " " + data042.cuni; HttpContext.Current.Session["Date"] = DateTime.Now.ToString("MM/dd/yyyy"); HttpContext.Current.Session["Pallet"] = data042.sqnb; HttpContext.Current.Session["Machine"] = _idaltticol022.getMachine(CLOT, ITEM.Trim().ToUpper(), ref strError);; HttpContext.Current.Session["Operator"] = _operator; HttpContext.Current.Session["Reprint"] = "no"; StringBuilder script = new StringBuilder(); if (HttpContext.Current.Session["navigator"].ToString() == "EDG") { script.Append("myLabelFrame = document.getElementById('myLabelFrame'); myLabelFrame.src ='../Labels/RedesingLabels/4FinishedCupsME.aspx'; "); } else { script.Append("myLabelFrame = document.getElementById('myLabelFrame'); myLabelFrame.src ='../Labels/RedesingLabels/4FinishedCups.aspx'; "); } ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); //StringBuilder script = new StringBuilder(); //script.Append("ventanaImp = window.open('../Labels/whInvLabelFinishProduct.aspx', "); //script.Append("'ventanaImp', 'menubar=0,resizable=0,width=580,height=450');"); //script.Append("ventanaImp.moveTo(30, 0);"); ////script.Append("setTimeout (ventanaImp.close(), 20000);"); //ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); } } }