using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using gregn6Lib;
|
using SQLHelper;
|
|
|
namespace CostM
|
{
|
public partial class CB_WIPBalanceImport : Form
|
{
|
public CB_WIPBalanceImport()
|
{
|
InitializeComponent();
|
}
|
|
const string ViewName = "h_v_CB_WIPBalanceImport";
|
const string ModCaption = "Ö±½Ó²ÄÁÏÔÚÖÆ»ã×ÜÒýÈë";
|
public const string ModName = "1205";
|
public const string ModRightName = "CB_WIPBalance";
|
public const string ModRightNameEdit = ModRightName + "_Edit";
|
public const string ModRightNameCheck = ModRightName + "_Check";
|
public const string ModRightNameClose = ModRightName + "_Close";
|
public const string ModRightNameDelete = ModRightName + "_Delete";
|
public const string ModRightNameMoney = ModRightName + "_Money";
|
public const string ModRightNameQty = ModRightName + "_Qty";
|
public Int32 iTopRow = 0;//»ºáÏß
|
int _ScrollValue = 0;//ˢР»Øλ
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
//±£´æÁпí
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
}
|
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
|
}
|
|
private void dc_Click(object sender, EventArgs e)
|
{
|
DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
|
}
|
|
|
#region //´òÓ¡ÉèÖÃ
|
GridppReport Report;
|
private void set_Click(object sender, EventArgs e)
|
{
|
//Ñ¡Ôñ´òÓ¡Ä£°å
|
BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
|
oFrm.sBillName = ModName;
|
oFrm.sBillModel = ModCaption;
|
oFrm.ShowDialog();
|
}
|
|
private void dy_Click(object sender, EventArgs e)
|
{
|
//Ñ¡Ôñ´òÓ¡Ä£°å
|
BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
|
oFrm.sBillName = ModName;
|
oFrm.sBillModel = ModCaption;
|
oFrm.ShowDialog();
|
if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
|
{
|
//
|
Sub_SetReport(oFrm.sOpenTmp);
|
Report.Print(true);
|
}
|
}
|
|
private void yl_Click(object sender, EventArgs e)
|
{
|
//Ñ¡Ôñ´òÓ¡Ä£°å
|
BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
|
oFrm.sBillName = ModName;
|
oFrm.sBillModel = ModCaption;
|
oFrm.ShowDialog();
|
if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
|
{
|
//
|
Sub_SetReport(oFrm.sOpenTmp);
|
Report.PrintPreview(true);
|
}
|
}
|
|
private void Sub_SetReport(string sOpenTmp)
|
{
|
//ÅжÏÐÐÊý
|
//
|
Report = new GridppReport();
|
Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf"); //here .
|
Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
|
}
|
|
private void ReportFetchRecordByDataTable()
|
{
|
BLL.Utility.FillRecordToReport(Report, grdMain, grdPrint, 0);
|
}
|
|
#endregion
|
|
private void yr_Click(object sender, EventArgs e)
|
{
|
ClsCN SubCn = new ClsCN();
|
DataSet DSet;
|
string sSql = "select * from h_v_CB_WIPBalanceImport where Äê="+cmbHYear.Text+" and ÔÂ="+cmbHPeriod.Text;
|
|
DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
|
//Éú³ÉÊ×ÐбêÌâ
|
if (DSet == null)
|
{
|
MessageBox.Show("ûÓзµ»ØÈκνá¹û,Çë³¢ÊÔÔٴβéѯ£¡" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
//ÊͷŶ³½á
|
DBUtility.Xt_BaseBillFun.CancelFrozenCol(grdMain);
|
//ˢкó,»Ø¹öµ½ÔλÖÃ
|
int selectRows = 0;
|
if (grdMain.CurrentRow != null)
|
{
|
selectRows = DBUtility.ClsPub.isInt(grdMain.CurrentRow.Index);
|
}
|
//°ó¶¨
|
grdMain.DataSource = DSet.Tables[0].DefaultView;
|
//ˢкó,»Ø¹öµ½ÔλÖÃ
|
if (grdMain.Rows.Count > _ScrollValue)
|
{
|
grdMain.FirstDisplayedScrollingRowIndex = _ScrollValue;
|
//iTopRow = _ScrollValue;
|
}
|
if (grdMain.Rows.Count > 0 && grdMain.Rows.Count > selectRows)
|
{
|
grdMain.Rows[selectRows].Selected = true;
|
}
|
//ÉèÖúϼÆÁÐ
|
//string sTotalCol = "";
|
//sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
|
//string[] sT;
|
//sT = sTotalCol.Split(Convert.ToChar(","));
|
//oSumGrid.BuildTotalCols(sT);
|
//
|
//¶³½á
|
int FrCol = DBUtility.ClsPub.isInt(0);
|
string s = "";
|
DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol);
|
//»Ïß
|
GraphLine();
|
//
|
//Total();
|
}
|
|
private void GraphLine()
|
{
|
//int MainIDCol = Fun_GetCol("hmainid");
|
//int SubIDCol = Fun_GetCol("hsubid");
|
//string s = frmCondition.cmbHComplete.Text;
|
//long n = 0;
|
//DBUtility.Xt_BaseBillFun.GraphLine(grdMain, MainIDCol, SubIDCol, s, ref n);
|
////ÏÔʾ
|
//lbldj.Text = "²éѯ³ö " + n.ToString() + " Õŵ¥¾Ý";
|
//lbljl.Text = "¹²ÓÐ " + grdMain.RowCount.ToString() + " Ìõ¼Ç¼";
|
|
}
|
|
|
private Int32 Fun_GetCol(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
|
}
|
|
private void xz_Click(object sender, EventArgs e)
|
{
|
ClsCN oCn = new ClsCN();
|
int HYear;
|
int HPeriod;
|
long HDeptID;
|
long HMaterID;
|
double HQty;
|
double HPrice;
|
double HMoney;
|
string HRemark;
|
for (int i = 0; i < grdMain.RowCount; i++)
|
{
|
HYear = Pub_Class.ClsPub.isInt(grdMain.Rows[i].Cells[Fun_GetCol("Äê")].Value);
|
HPeriod = Pub_Class.ClsPub.isInt(grdMain.Rows[i].Cells[Fun_GetCol("ÔÂ")].Value);
|
HDeptID = Pub_Class.ClsPub.isInt(grdMain.Rows[i].Cells[Fun_GetCol("HDeptID")].Value);
|
HMaterID = Pub_Class.ClsPub.isInt(grdMain.Rows[i].Cells[Fun_GetCol("HMaterID")].Value);
|
HQty = Pub_Class.ClsPub.isDoule(grdMain.Rows[i].Cells[Fun_GetCol("MESÊýÁ¿")].Value);
|
HPrice = Pub_Class.ClsPub.isDoule(grdMain.Rows[i].Cells[Fun_GetCol("µ¥¼Û")].Value);
|
HMoney = Pub_Class.ClsPub.isDoule(grdMain.Rows[i].Cells[Fun_GetCol("½ð¶î")].Value);
|
HRemark = "";
|
if (HMaterID==0)
|
continue;
|
oCn.RunProc("insert into CB_WIPBalance (HYear,HPeriod,HBillType,HDate" +
|
",HDeptID,HMaterID,HQty,HPrice,HMoney,HRemark" +
|
",HMaker,HMakeDate)" +
|
"values('" + HYear + "','" + HPeriod + "','1111',GETDATE()" +
|
"," + HDeptID + "," + HMaterID + "," + HQty + "," + HPrice + "," + HMoney + ",'" + HRemark + "'" +
|
",'" + DBUtility.ClsPub.CurUserName + "',GETDATE())");
|
}
|
MessageBox.Show("±£´æÍê±Ï£¡");
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void CB_WIPBalanceImport_Load(object sender, EventArgs e)
|
{
|
cmbHYear.Items.Clear();
|
cmbHYear.Items.Add(DateTime.Today.Year - 4);
|
cmbHYear.Items.Add(DateTime.Today.Year - 3);
|
cmbHYear.Items.Add(DateTime.Today.Year - 2);
|
cmbHYear.Items.Add(DateTime.Today.Year - 1);
|
cmbHYear.Items.Add(DateTime.Today.Year);
|
cmbHYear.SelectedIndex = 4;
|
cmbHPeriod.Text = DateTime.Today.AddMonths(-1).Month.ToString();
|
}
|
}
|
}
|
