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_DuSubsidyItem : Form
|
{
|
ClsGy_DataInTmp_DuSubsidyItem oTmp = new ClsGy_DataInTmp_DuSubsidyItem();
|
DAL.ClsPay_DuSubsidyItemBill BillNew = new DAL.ClsPay_DuSubsidyItemBill();
|
DAL.ClsGy_DuSubsidyItem_View oDuHlp = new DAL.ClsGy_DuSubsidyItem_View();
|
DAL.ClsGy_Department_View oDept = new DAL.ClsGy_Department_View();//K3²¿ÃÅ
|
DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
|
//
|
|
public Gy_DataInTmp_DuSubsidyItem()
|
{
|
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))
|
{
|
BillNew.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
}
|
}
|
}
|
}
|
MessageBox.Show("µ¼ÈëÍê±Ï");
|
grdmain.DataSource = null;
|
}
|
|
//дÈëÀà ´Ó¿Ø¼þ
|
private bool Mater_WriteClass(int row)
|
{
|
//
|
|
string sBillNo = "";
|
sBillNo = DBUtility.ClsPub.CreateBillCode("2233", ref DBUtility.ClsPub.sExeReturnInfo, true);//µÃµ½Ðµ¥ºÅ£¨È±ÉÙº¯Êý£© δÍê³É
|
int sDuSubCol = DBUtility.Gy_BaseFun.Fun_GetCol("¿Û²¹ÏîÄ¿", grdmain);
|
int sDeptCol = DBUtility.Gy_BaseFun.Fun_GetCol("²¿ÃÅ", grdmain);
|
int sGroupCol = DBUtility.Gy_BaseFun.Fun_GetCol("°à×é", grdmain);
|
int sEmpCol = DBUtility.Gy_BaseFun.Fun_GetCol("Ö°Ô±", grdmain);
|
//
|
string sDuSubName = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sDuSubCol].Value);
|
string sDeptName = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sDeptCol].Value);
|
string sGroupName = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sGroupCol].Value);
|
string sEmpName = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sEmpCol].Value);
|
//ÅжÏÊÇ·ñÔÊÐí ±£´æ
|
|
//ÅжÏÊÇ·ñÔÊÐí ±£´æ
|
//µÃµ½Òµ»§ÄÚÂ룬·ÑÓÃÏîÄ¿ÄÚÂë
|
//дÈëÐÅÏ¢
|
BillNew.omodel.HYear = 2011;
|
BillNew.omodel.HPeriod = 1;
|
BillNew.omodel.HBillNo = sBillNo;
|
BillNew.omodel.HDate = DateTime.Today;
|
BillNew.omodel.HRemark = "ϵͳµ¼Èë";
|
//
|
|
if (oDept.GetInfoByName(sDeptName))
|
{
|
BillNew.omodel.HDeptID = oDept.omodel.HItemID;
|
}
|
else
|
{
|
BillNew.omodel.HDeptID = 0;
|
return false;
|
}
|
//
|
if (oGroup.GetInfoByName(sGroupName))
|
{
|
BillNew.omodel.HGroupID = oGroup.omodel.HItemID;
|
}
|
else
|
{
|
BillNew.omodel.HGroupID = 0;
|
return false;
|
}
|
BillNew.omodel.HExplanation = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[DBUtility.Gy_BaseFun.Fun_GetCol("ÕªÒª", grdmain)].Value);// DBUtility.Gy_BaseFun.Fun_GetCol("ÕªÒª", grdmain);
|
BillNew.omodel.HInnerBillNo = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[DBUtility.Gy_BaseFun.Fun_GetCol("ÄÚ²¿µ¥¾ÝºÅ", grdmain)].Value); //DBUtility.Gy_BaseFun.Fun_GetCol("ÄÚ²¿µ¥¾ÝºÅ", grdmain);
|
BillNew.omodel.HAutoSaveFlag = false;
|
|
//
|
//BillNew.HExRate = ClsPub.isDoule(this.txtHMaterName.Text.ToString());
|
//Ã÷ϸÀำֵ
|
BillNew.DetailColl = new List<Model.ClsPay_DuSubsidyItemBillSub>();
|
Model.ClsPay_DuSubsidyItemBillSub oSub = new Model.ClsPay_DuSubsidyItemBillSub();
|
oSub.HEntryID = 1;
|
//
|
if (oDuHlp.GetInfoByName(sDuSubName))
|
{
|
oSub.HDuSubsidyItemID = oDuHlp.omodel.HItemID;
|
}
|
else
|
{
|
oSub.HDuSubsidyItemID = 0;
|
return false;
|
}
|
//
|
if (oEmp.GetInfoByName(sEmpName))
|
{
|
oSub.HEmpID = oEmp.omodel.HItemID;
|
}
|
else
|
{
|
oSub.HEmpID = 0;
|
return false;
|
}
|
oSub.HQty = DBUtility.ClsPub.isLong(grdmain.Rows[row].Cells[DBUtility.Gy_BaseFun.Fun_GetCol("ÊýÁ¿", grdmain)].Value); //DBUtility.Gy_BaseFun.Fun_GetCol("ÊýÁ¿", grdmain); ;
|
oSub.HPrice = DBUtility.ClsPub.isLong(grdmain.Rows[row].Cells[DBUtility.Gy_BaseFun.Fun_GetCol("µ¥¼Û", grdmain)].Value); //DBUtility.Gy_BaseFun.Fun_GetCol("µ¥¼Û", grdmain); ;
|
oSub.HMoney = DBUtility.ClsPub.isLong(grdmain.Rows[row].Cells[DBUtility.Gy_BaseFun.Fun_GetCol("½ð¶î", grdmain)].Value); //DBUtility.Gy_BaseFun.Fun_GetCol("½ð¶î", grdmain); ;
|
|
|
BillNew.DetailColl.Add(oSub);
|
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 = "";
|
}
|
|
}
|
|
}
|
}
|
