| | |
| | | |
| | | namespace PlanM |
| | | { |
| | | public partial class Gy_DataIn_RoutingBill :BLL.Gy_DataInTmp |
| | | public partial class Gy_DataIn_RoutingBill : BLL.Gy_DataInTmp |
| | | { |
| | | public Gy_DataIn_RoutingBill() |
| | | { |
| | |
| | | { |
| | | base.sSheetName = txtHSheetName.Text; |
| | | return base.OpenExcelData(); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// åå§åçé¢ |
| | |
| | | public override void initData() |
| | | { |
| | | base.initData(); |
| | | base.sSheetName = txtHSheetName.Text ; |
| | | base.sSheetName = txtHSheetName.Text; |
| | | base.ModRightName = "Gy_DataIn_RoutingBill"; |
| | | base.ModRightNameCheck = base.ModRightName + base.ModRightNameCheck; |
| | | base.ModRightNameClose = base.ModRightName + base.ModRightNameClose; |
| | |
| | | b = BillNew.AddBill(ref ClsPub.sExeReturnInfo); |
| | | if (b == false) |
| | | { |
| | | MessageBox.Show("第" + i.ToString() + "è¡,ç©æ" + BillNew.omodel.HMaterNumber + "æ°å¢å·¥èºè·¯çº¿å¤±è´¥ï¼ä»£ç 293è¡ä¸ï¼åå ï¼"+ ClsPub.sExeReturnInfo); |
| | | MessageBox.Show("第" + i.ToString() + "è¡,ç©æ" + BillNew.omodel.HMaterNumber + "æ°å¢å·¥èºè·¯çº¿å¤±è´¥ï¼ä»£ç 293è¡ä¸ï¼åå ï¼" + ClsPub.sExeReturnInfo); |
| | | return; |
| | | } |
| | | c++; |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | MessageBox.Show("导å
¥å¤±è´¥!åå :" + e.Message, "æç¤º"); |
| | | MessageBox.Show("导å
¥å¤±è´¥!åå :" + e.Message, "æç¤º"); |
| | | } |
| | | } |
| | | |
| | |
| | | private bool WriteClass(int row) |
| | | { |
| | | string sHNumber = ""; |
| | | string sHNamePoc = ""; |
| | | string sHNamePoc = ""; |
| | | string sHNumberCen = ""; |
| | | Single sWorkQty = 0; |
| | | Single sBeginDayQty = 0; |
| | |
| | | Single sHPassRate = 0; |
| | | //long HItemID = 0; |
| | | // |
| | | sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMaterNumberCol].Value); |
| | | sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMaterNumberCol].Value); |
| | | sHNumberCen = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HWorkCenterNameCol].Value); |
| | | sHNamePoc = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HProcNameCol].Value); |
| | | |
| | |
| | | sHPassRate = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HPassRateCol].Value); |
| | | //夿æ¯å¦å
许 ä¿å |
| | | |
| | | Model.ClsGy_RoutingBillSub oSub=new Model.ClsGy_RoutingBillSub(); |
| | | Model.ClsGy_RoutingBillSub oSub = new Model.ClsGy_RoutingBillSub(); |
| | | |
| | | //å¾å°å·¥åºå
ç |
| | | if (oProcHlp.GetInfoByName(sHNamePoc)) |
| | |
| | | oSub.HQueueTime = 0; |
| | | oSub.HMoveTime = 0; |
| | | // |
| | | |
| | | |
| | | // |
| | | oSub.HCloseMan = ""; |
| | | oSub.HCloseType = false; |
| | | oSub.HSourceInterID = 0; |
| | | oSub.HSourceEntryID = 0; |
| | | oSub.HSourceBillType = ""; |
| | | oSub.HSourceBillNo =""; |
| | | oSub.HSourceBillNo = ""; |
| | | oSub.HRelationQty = 0; |
| | | oSub.HRelationMoney = 0; |
| | | |
| | |
| | | //æ£æ¥ç©æ |
| | | private bool Checkdata() |
| | | { |
| | | bool b=false; |
| | | bool b = false; |
| | | string sErrMsg = ""; |
| | | string sMsg = ""; |
| | | for (int i = 0; i <= grdMain.Rows.Count - 1; i++) |
| | | { |
| | | string sHNumber = ""; |
| | | string sHNamePoc = ""; |
| | | string sHNamePoc = ""; |
| | | string sHNumberCen = ""; |
| | | Single sWorkQty = 0; |
| | | Single sHPassRate = 0; |
| | |
| | | sHNamePoc = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HProcNameCol].Value); |
| | | sWorkQty = DBUtility.ClsPub.isSingle(grdMain.Rows[i].Cells[HWorkQtyCol].Value); |
| | | sHPassRate = DBUtility.ClsPub.isSingle(grdMain.Rows[i].Cells[HPassRateCol].Value); |
| | | if (sHNumber != "" ) |
| | | if (sHNumber != "") |
| | | { |
| | | // |
| | | int index = i + 1; |
| | |
| | | if (!oMaterHlp.GetInfoByNumber(sHNumber)) |
| | | { |
| | | sMsg = "[" + sHNumber + "]ç©æä¸åå¨"; |
| | | if (sErrMsg.Contains(sMsg)==false) |
| | | if (sErrMsg.Contains(sMsg) == false) |
| | | { |
| | | sErrMsg = sErrMsg + "[" + sHNumber + "]ç©æä¸åå¨\r\n" ; |
| | | sErrMsg = sErrMsg + "[" + sHNumber + "]ç©æä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | } |
| | |
| | | |
| | | } |
| | | |
| | | } |
| | | } |
| | | } |
| | | if (b == true) |
| | | { |