using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using System.Data.OleDb;
|
using System.Data.Sql;
|
|
namespace BaseSet
|
{
|
public partial class Gy_DataInTmp_Material : Form
|
{
|
ClsGy_DataInTmp_Material oTmp = new ClsGy_DataInTmp_Material();
|
DAL.ClsGy_Material_Ctl oMater = new DAL.ClsGy_Material_Ctl();
|
DAL.ClsGy_Material_View oMaterHlp = new DAL.ClsGy_Material_View();
|
DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View();
|
DAL.ClsGy_Warehouse_View oWh = new DAL.ClsGy_Warehouse_View();
|
//
|
|
public Gy_DataInTmp_Material()
|
{
|
InitializeComponent();
|
}
|
|
|
private void initHeadCaption()
|
{
|
|
}
|
|
//
|
private void yl_Click(object sender, EventArgs e)
|
{
|
WriteClass(cmbHDataInTmp.Text);
|
}
|
|
//Êý¾Ýµ¼Èë
|
public void WriteClass(string sName)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
string sColName;
|
string sFieldName;
|
if (sName == "ÎïÁϵ¼Èë")
|
{
|
for (int i = 0; i <= grdmain.Rows.Count - 1; i++)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdmain.Rows[i].Cells[0].Value) != "")
|
{
|
if (Mater_WriteClass(i))
|
{
|
oMater.AddNew();
|
}
|
}
|
}
|
}
|
MessageBox.Show("µ¼ÈëÍê±Ï");
|
grdmain.DataSource = null;
|
}
|
|
//дÈëÀà ´Ó¿Ø¼þ
|
private bool Mater_WriteClass(int row)
|
{
|
//
|
string sHNumber = "";
|
long HItemID = 0;
|
int sCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÎïÁÏ´úÂë", grdmain);
|
//
|
sHNumber = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sCol].Value);
|
//ÅжÏÊÇ·ñÔÊÐí ±£´æ
|
//ÉóºË´úÂëÊÇ·ñºÏÀí
|
if (!DBUtility.ClsPub.AllowNumber(sHNumber))
|
{
|
MessageBox.Show("´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡", "Ìáʾ");
|
return false;
|
}
|
|
//ÊÇ·ñÖظ´´úÂë
|
if (oMater.HavSameNumber(HItemID, sHNumber))
|
{
|
MessageBox.Show("´úÂëÖظ´£¡", "Ìáʾ");
|
return false;
|
}
|
//¼ì²é¸¸¼¶ÊÇ·ñ´æÔÚ
|
string sParent;
|
sParent = DBUtility.ClsPub.GetParentCode(sHNumber);
|
if (sParent.Trim() == "")
|
{
|
oMater.oModel.HParentID = 0;
|
}
|
else
|
{
|
if (oMater.HavParentCode(sParent.Trim(), HItemID))
|
{
|
oMater.oModel.HParentID = oMater.oModel.HItemID;
|
}
|
else
|
{
|
MessageBox.Show("Éϼ¶´úÂë²»´æÔÚ»ò±»½ûÓã¡", "Ìáʾ");
|
return false;
|
}
|
}
|
//µÃµ½¶Ì´úÂë
|
string sShortNumber;
|
sShortNumber = DBUtility.ClsPub.GetShortNumber(sHNumber);
|
if (sShortNumber.Trim() == "")
|
{
|
return false;
|
}
|
//±£´æÔ´úÂë
|
if (oMaterHlp.GetInfoByID(HItemID))
|
{
|
oMater.HOldNumber = oMaterHlp.omodel.HNumber;
|
//ÊÇ·ñдúÂëÊÇ×Ô¼º×ÓÏîÄ¿µÄ¡¡×ÓÏîÄ¿
|
if (sParent.Length >= oMater.HOldNumber.Length)
|
{
|
if (sParent.Substring(0, oMater.HOldNumber.ToString().Length) == oMater.HOldNumber.Trim())
|
{
|
MessageBox.Show("дúÂë²»ÄÜÊÇ×Ô¼ºµÄϼ¶µÄ×ÓÏîÄ¿£¡", "Ìáʾ");
|
return false;
|
}
|
}
|
}
|
else
|
{
|
oMater.HOldNumber = "";
|
}
|
//дÈëÐÅÏ¢
|
oMater.oModel.HShortNumber = sShortNumber;
|
oMater.oModel.HEndFlag = true;
|
oMater.oModel.HLevel = DBUtility.ClsPub.GetLevel(sHNumber);
|
oMater.oModel.HNumber = sHNumber;
|
oMater.oModel.HHelpCode = sShortNumber;
|
oMater.oModel.HName = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sCol + 1].Value);
|
oMater.oModel.HStopflag = false;
|
oMater.oModel.HRemark = "";
|
|
oMater.oModel.HModel = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sCol + 2].Value);
|
if (oUnit.GetInfoByName(DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sCol + 3].Value)))
|
{
|
oMater.oModel.HUnitID = oUnit.omodel.HItemID;
|
}
|
if (oWh.GetInfoByName(DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sCol + 4].Value)))
|
{
|
oMater.oModel.HWhID = oWh.omodel.HItemID;
|
}
|
oMater.oModel.HMaterClsID = 0;
|
oMater.oModel.HMaterTypeID = 0;
|
oMater.oModel.HUnitGroupID = 0;
|
oMater.oModel.HRoutingID = 0;
|
oMater.oModel.HBomID = 0;
|
oMater.oModel.HSecUnitID = 0;
|
oMater.oModel.HSecUnitRate = 0;
|
oMater.oModel.HHighStock = 0;
|
oMater.oModel.HLowStock = 0;
|
oMater.oModel.HSafeStock = 0;
|
oMater.oModel.HOrderPrice = 0;
|
oMater.oModel.HSalePrice = 0;
|
oMater.oModel.HKeepDays = 0;
|
oMater.oModel.HPlanPrice = 0;
|
oMater.oModel.HstdPrice = 0;
|
oMater.oModel.HQtyMin = 0;
|
oMater.oModel.HQtyMax = 0;
|
oMater.oModel.HVersion = "";
|
oMater.oModel.HEngName = "";
|
oMater.oModel.HEngModel = "";
|
oMater.oModel.HPropertyTypeID = 0;
|
oMater.oModel.HSPGroupID = 0;
|
oMater.oModel.HSPID = 0;
|
return true;
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void K3_OutMachFeeDataIn_Load(object sender, EventArgs e)
|
{
|
initHeadCaption();
|
}
|
public string ExcelPath;
|
|
private void OpenExcelData(string sPath)
|
{
|
string sName;
|
sName = "Sheet1";
|
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sPath + ";" +
|
"Extended Properties='Excel 8.0;IMEX=1'";
|
DataSet ds = new DataSet();
|
OleDbConnection conn = new OleDbConnection(strConn);
|
conn.Open();
|
try
|
{
|
OleDbDataAdapter Da = new OleDbDataAdapter("select * from [" + sName + "$]", conn);
|
Da.Fill(ds);
|
grdmain.DataSource = ds.Tables[0];
|
}
|
catch(Exception e)
|
{
|
MessageBox.Show("ÒýÈëEXCELÊý¾Ýʧ°Ü£¡ÇëÓë¹ÜÀíÔ±ÁªÏµ£¡" + e.Message);
|
}
|
}
|
|
private void button1_Click_1(object sender, EventArgs e)
|
{
|
OpenExcelFile.Title = "Open Excel File ";
|
OpenExcelFile.FileName = "";
|
OpenExcelFile.Filter = "Microsoft Office Excel Files(*.xls)|*.xls|(*.csv)|*.csv";
|
OpenExcelFile.ShowDialog();
|
if (OpenExcelFile.FileName != "")
|
{
|
ExcelPath = OpenExcelFile.FileName;
|
OpenExcelData(ExcelPath);
|
}
|
else
|
{
|
ExcelPath = "";
|
}
|
|
}
|
|
}
|
}
|
