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_NetWeight_DataIn : Form
|
{
|
//ClsGy_NetWeight_DataIn oTmp = new ClsGy_NetWeight_DataIn();
|
|
DAL.ClsGy_NetWeight_Ctl BillNew = new DAL.ClsGy_NetWeight_Ctl();
|
DAL.ClsK3_Material_View oMat = new DAL.ClsK3_Material_View();
|
DAL.ClsGy_ICBomBill oBom = new DAL.ClsGy_ICBomBill();
|
|
//
|
|
public Gy_NetWeight_DataIn()
|
{
|
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 (Mater_WriteClass(i))
|
{
|
if (!BillNew.DeleteByHMaterID(BillNew.oModel.HInterID))
|
{
|
MessageBox.Show("ɾ³ýʧ°Ü£¡");
|
return;
|
}
|
if (!BillNew.AddNew())
|
{
|
MessageBox.Show("±£´æʧ°Ü£¡");
|
return;
|
}
|
}
|
else
|
{
|
MessageBox.Show("µÚ"+DBUtility.ClsPub.isStrNull(i)+"ÐУ¬ÎïÁÏδÕÒµ½£¡");
|
return;
|
}
|
}
|
}
|
MessageBox.Show("µ¼ÈëÍê±Ï");
|
grdmain.DataSource = null;
|
}
|
|
//дÈëÀà ´Ó¿Ø¼þ
|
private bool Mater_WriteClass(int row)
|
{
|
//
|
//BillNew.DetailColl = new List<Model.ClsGy_NetWeight_DataIn_M>();
|
//Model.ClsGy_NetWeight_DataIn_M omodel = new Model.ClsGy_NetWeight_DataIn_M();
|
//string sBillNo = "";
|
// sBillNo = DBUtility.ClsPub.CreateBillCode("1812", ref DBUtility.ClsPub.sExeReturnInfo, true);//µÃµ½Ðµ¥ºÅ£¨È±ÉÙº¯Êý£© δÍê³É
|
int sMaterCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÆ·´úÂë", grdmain);
|
int sQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("¾»ÖØ", grdmain);
|
|
string sMaterNum = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sMaterCol].Value);
|
|
long HMaterID = 0;
|
long HBomID = 0;
|
string HBomNumber = "";
|
//дÈëÐÅÏ¢
|
//
|
if (oMat.GetInfoByNumber(sMaterNum))
|
{
|
HMaterID = oMat.omodel.HItemID;
|
if (oBom.Get_BOMIDByMaterID(HMaterID, ref HBomID, ref HBomNumber))
|
{
|
BillNew.oModel.HInterID = HBomID;
|
if (oBom.ShowBill(HBomID, ref DBUtility.ClsPub.sExeReturnInfo))
|
{
|
foreach (Model.ClsGy_ICBomBillSub_K3 oSub in oBom.DetailColl)
|
{
|
if (oMat.GetInfoByID(oSub.HMaterID))
|
{
|
BillNew.oModel.HMaterID = oMat.omodel.HItemID;
|
}
|
else
|
{
|
BillNew.oModel.HMaterID = 0;
|
return false;
|
}
|
}
|
}
|
}
|
else
|
{
|
BillNew.oModel.HInterID=0;
|
return false;
|
}
|
}
|
else
|
{
|
BillNew.oModel.HInterID = 0;
|
BillNew.oModel.HMaterID = 0;
|
return false;
|
}
|
BillNew.oModel.HQty = DBUtility.ClsPub.isDoule(grdmain.Rows[row].Cells[sQtyCol].Value);
|
|
return true;
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void K3_OutMachFeeDataIn_Load(object sender, EventArgs e)
|
{
|
cmbHDataInTmp.SelectedIndex = 0;
|
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 = "";
|
}
|
|
}
|
|
}
|
}
|
