using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using Pub_Class;
|
using SQLHelper;
|
|
namespace BaseSet
|
{
|
public partial class Gy_DataIn_StdWorkTimes : BLL.Gy_DataInTmp
|
{
|
public Gy_DataIn_StdWorkTimes()
|
{
|
InitializeComponent();
|
}
|
public int HItemIDCol = 0;
|
public int HMaterNumberCol = 0; //ÎïÁÏ´úÂë
|
public int HProcNumberCol = 0; //¹¤Ðò´úÂë
|
public int HStdWorkTimesCol = 0; //±ê×¼¹¤Ê±
|
public int HUpperlimitCol = 0; //ÉÏÏÞ±ÈÀý
|
public int HLowerlimitCol = 0; //ÏÂÏÞ±ÈÀý
|
public int HStdPieceCol = 0; //±ê×¼¼Æ¼þ
|
public int HStdPricCol = 0; //±ê×¼¼Æ¼Û
|
public int HUSEORGIDCol = 0; //×éÖ¯ID
|
public int HMakerCol = 0; //ÖƵ¥ÈË
|
public int HMakeDateCol = 0; //ÖƵ¥ÈÕÆÚ
|
//
|
public DAL.ClsGy_Process_View oProcHlp = new DAL.ClsGy_Process_View();
|
public DAL.ClsGy_StdWorkTimes_Ctl BillNew = new DAL.ClsGy_StdWorkTimes_Ctl();
|
DAL.ClsIF_Material_View oMaterHlp = new DAL.ClsIF_Material_View();
|
int c = 0;
|
|
public override bool OpenExcelData()
|
{
|
base.sSheetName = txtHSheetName.Text;
|
return base.OpenExcelData();
|
}
|
|
/// <summary>
|
/// ³õʼ»¯½çÃæ
|
/// </summary>
|
public override void initData()
|
{
|
base.initData();
|
base.sSheetName = "±ê×¼¹¤Ê±µ¼Èë";
|
base.ModRightName = "Gy_DataIn_StdWorkTimes";
|
base.ModRightNameCheck = base.ModRightName + base.ModRightNameCheck;
|
base.ModRightNameClose = base.ModRightName + base.ModRightNameClose;
|
base.ModRightNameDelete = base.ModRightName + base.ModRightNameDelete;
|
base.ModRightNameEdit = base.ModRightName + base.ModRightNameEdit;
|
base.ModRightNameMoney = base.ModRightName + base.ModRightNameMoney;
|
base.ModRightNameQty = base.ModRightName + base.ModRightNameQty;
|
base.ModCaption = "±ê×¼¹¤Ê±µ¼Èë";
|
this.Text = base.ModCaption;
|
lblCaption.Text = base.ModCaption;
|
//
|
DBUtility.Gy_BaseFun.SetComboxYear(cmbHYear);
|
DBUtility.Gy_BaseFun.SetComboxPeriod(cmbHPeriod);
|
}
|
|
public override void Sub_DataIn()
|
{
|
HStdWorkTimesCol = DBUtility.Gy_BaseFun.Fun_GetCol("±ê×¼¹¤Ê±", grdMain);
|
HProcNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤Ðò´úÂë", grdMain);
|
HMaterNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÎïÁÏ´úÂë", grdMain);
|
HUpperlimitCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÉÏÏß±ÈÀý", grdMain);
|
HLowerlimitCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÏÂÏß±ÈÀý", grdMain);
|
HStdPieceCol = DBUtility.Gy_BaseFun.Fun_GetCol("±ê×¼¼Æ¼þ", grdMain);
|
HStdPricCol = DBUtility.Gy_BaseFun.Fun_GetCol("±ê×¼¼Æ¼Û", grdMain);
|
|
//Åжϵ¼ÈëÎĵµÖÐÊÇ·ñ´æÔÚÒÔϱêÌâÁÐ
|
if (HStdWorkTimesCol == -1)
|
{
|
MessageBox.Show("ûÓÐÕÒµ½¡¾±ê×¼¹¤Ê±¡¿µÄ±êÌâ", "Ìáʾ");
|
return;
|
}
|
if (HProcNumberCol == -1)
|
{
|
MessageBox.Show("ûÓÐÕÒµ½¡¾¹¤Ðò´úÂë¡¿µÄ±êÌâ", "Ìáʾ");
|
return;
|
}
|
if (HMaterNumberCol == -1)
|
{
|
MessageBox.Show("ûÓÐÕÒµ½¡¾ÎïÁÏ´úÂë¡¿µÄ±êÌâ", "Ìáʾ");
|
return;
|
}
|
if (HUpperlimitCol == -1)
|
{
|
MessageBox.Show("ûÓÐÕÒµ½¡¾ÉÏÏß±ÈÀý¡¿µÄ±êÌâ", "Ìáʾ");
|
return;
|
}
|
if (HLowerlimitCol == -1)
|
{
|
MessageBox.Show("ûÓÐÕÒµ½¡¾ÏÂÏß±ÈÀý¡¿µÄ±êÌâ", "Ìáʾ");
|
return;
|
}
|
if (HStdPieceCol == -1)
|
{
|
MessageBox.Show("ûÓÐÕÒµ½¡¾±ê×¼¼Æ¼þ¡¿µÄ±êÌâ", "Ìáʾ");
|
return;
|
}
|
if (HStdPricCol == -1)
|
{
|
MessageBox.Show("ûÓÐÕÒµ½¡¾±ê×¼¼Æ¼Û¡¿µÄ±êÌâ", "Ìáʾ");
|
return;
|
}
|
//µ¼ÈëÇ°Êý¾ÝÊÇ·ñºÏÀíÅжÏ
|
if (!Checkdata())
|
{
|
return;
|
}
|
|
for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
|
{
|
//дÈëÀà
|
if (WriteClass(i))
|
{
|
bool b = false;
|
//±£´æ¼Ç¼
|
b = BillNew.AddNew();
|
if (b == false) return;
|
c++;
|
}
|
}
|
MessageBox.Show("µ¼ÈëÍê±Ï:¹²" + c.ToString() + "ÌõÊý¾Ý£¡");
|
grdMain.DataSource = null;
|
c = 0;
|
}
|
|
//дÈëÀà ´Ó¿Ø¼þ
|
private bool WriteClass(int row)
|
{
|
Model.ClsGy_StdWorkTimes_Model oSub = new Model.ClsGy_StdWorkTimes_Model();
|
BillNew.DetailColl.Clear();
|
string sHMaterNumber = "";
|
string sHProcNumber = "";
|
//
|
sHMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMaterNumberCol].Value);
|
sHProcNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HProcNumberCol].Value);
|
|
//дÈëÐÅÏ¢
|
//µÃµ½ÎïÁÏÄÚÂë
|
if (oMaterHlp.GetInfoByNumber(sHMaterNumber))
|
{
|
oSub.HMaterID = oMaterHlp.omodel.HItemID;
|
}
|
//µÃµ½¹¤ÐòÄÚÂë
|
if (oProcHlp.GetInfoByNumber(sHProcNumber))
|
{
|
oSub.HProcID = oProcHlp.omodel.HItemID;
|
}
|
oSub.HRemark = "";
|
oSub.HStdWorkTimes = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HStdWorkTimesCol].Value);
|
oSub.HUpperlimit = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HUpperlimitCol].Value);
|
oSub.HLowerlimit = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HLowerlimitCol].Value);
|
oSub.HStdPiece = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HStdPieceCol].Value);
|
oSub.HStdPric = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HStdPricCol].Value);
|
oSub.HUSEORGID = DBUtility.ClsPub.HOrgID;
|
oSub.HMaker = DBUtility.ClsPub.CurUserName;
|
oSub.HMakeDate = DateTime.Today.ToShortDateString();
|
BillNew.DetailColl.Add(oSub);
|
|
//·Ç×·¼Óģʽ£¬µ¼ÈëÇ°¸ù¾ÝÎïÁÏID¡¢¹¤ÐòID²éÕÒɾ³ý¶ÔÓ¦¼Ç¼
|
if (checkadd.Checked == false)
|
{
|
BillNew.DeleteByMaterIDAndHProcID(oSub.HMaterID, oSub.HProcID);
|
}
|
return true;
|
}
|
|
//¼ì²éµ¼ÈëÊý¾ÝÊÇ·ñºÏÀí
|
private bool Checkdata()
|
{
|
bool b = false;
|
string sErrMsg = "";
|
string sMsg = "";
|
for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
|
{
|
string sHMaterNumber = "";
|
string sHProcNumber = "";
|
double sHStdWorkTimes = 0;
|
double sHUpperlimit = 0;
|
double sHLowerlimit = 0;
|
double sHStdPiece = 0;
|
double sHStdPric = 0;
|
//
|
sHMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value);
|
sHProcNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HProcNumberCol].Value);
|
sHStdWorkTimes = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HStdWorkTimesCol].Value);
|
sHUpperlimit = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HUpperlimitCol].Value);
|
sHLowerlimit = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HLowerlimitCol].Value);
|
sHStdPiece = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HStdPieceCol].Value);
|
sHStdPric = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HStdPricCol].Value);
|
//
|
//ÉóºË´úÂëÊÇ·ñºÏÀí
|
if (!DBUtility.ClsPub.AllowNumber(sHMaterNumber))
|
{
|
sErrMsg = sErrMsg + "µÚ" + (i + 1).ToString() + "ÐÐ,ÎïÁÏ´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡\r\n";
|
b = true;
|
}
|
if (!DBUtility.ClsPub.AllowNumber(sHProcNumber))
|
{
|
sErrMsg = sErrMsg + "µÚ" + (i + 1).ToString() + "ÐÐ,¹¤Ðò´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡\r\n";
|
b = true;
|
}
|
|
//ÅжÏËùµ¼ÈëÊý¾ÝÊÇ·ñÕýÈ·
|
if (sHStdWorkTimes<=0)
|
{
|
sErrMsg = sErrMsg + "µÚ" + (i + 1).ToString() + "ÐÐ,±ê×¼¹¤Ê±²»ÄÜСÓÚ»òµÈÓÚ0£¡\r\n";
|
b = true;
|
}
|
if (sHUpperlimit < 0)
|
{
|
sErrMsg = sErrMsg + "µÚ" + (i + 1).ToString() + "ÐÐ,ÉÏÏÞ±ÈÀý²»ÄÜСÓÚ0£¡\r\n";
|
b = true;
|
}
|
if (sHLowerlimit < 0)
|
{
|
sErrMsg = sErrMsg + "µÚ" + (i + 1).ToString() + "ÐÐ,ÏÂÏÞ±ÈÀý²»ÄÜСÓÚ0£¡\r\n";
|
b = true;
|
}
|
if (sHStdPiece < 0)
|
{
|
sErrMsg = sErrMsg + "µÚ" + (i + 1).ToString() + "ÐÐ,±ê×¼¼Æ¼þ²»ÄÜСÓÚ0£¡\r\n";
|
b = true;
|
}
|
if (sHStdPric < 0)
|
{
|
sErrMsg = sErrMsg + "µÚ" + (i + 1).ToString() + "ÐÐ,±ê×¼¼Æ¼Û²»ÄÜСÓÚ0£¡\r\n";
|
b = true;
|
}
|
|
if (sHMaterNumber == "")
|
{
|
sErrMsg = sErrMsg + "µÚ" + (i + 1).ToString() + "ÐÐ,ÎïÁÏ´úÂë²»ÄÜΪ¿Õ£¡\r\n";
|
b = true;
|
}
|
else
|
{
|
//µÃµ½ÎïÁÏÄÚÂë
|
if (!oMaterHlp.GetInfoByNumber(sHMaterNumber))
|
{
|
sMsg = "[" + sHMaterNumber + "]ÎïÁϲ»´æÔÚ";
|
if (sErrMsg.Contains(sMsg) == false)
|
{
|
sErrMsg = sErrMsg + "[" + sHMaterNumber + "]ÎïÁϲ»´æÔÚ\r\n";
|
}
|
b = true;
|
}
|
}
|
|
if (sHProcNumber == "")
|
{
|
sErrMsg = sErrMsg + "µÚ" + (i + 1).ToString() + "ÐÐ,¹¤Ðò´úÂë²»ÄÜΪ¿Õ£¡\r\n";
|
b = true;
|
}
|
else
|
{
|
//µÃµ½¹¤ÐòÄÚÂë
|
if (!oProcHlp.GetInfoByNumber(sHProcNumber))
|
{
|
sMsg = "[" + sHProcNumber + "]¹¤Ðò²»´æÔÚ";
|
if (sErrMsg.Contains(sMsg) == false)
|
{
|
sErrMsg = sErrMsg + "[" + sHProcNumber + "]¹¤Ðò²»´æÔÚ\r\n";
|
}
|
b = true;
|
}
|
}
|
}
|
if (b == true)
|
{
|
Pub_Control.ErrMsgBox oMsgbox = new Pub_Control.ErrMsgBox();
|
oMsgbox.txtHErrMsg.Text = sErrMsg;
|
oMsgbox.ShowDialog();
|
return false;
|
}
|
else
|
{
|
return true;
|
}
|
}
|
|
private void Gy_DataIn_StdWorkTimes_Load(object sender, EventArgs e)
|
{
|
|
}
|
}
|
}
|
