using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using SQLHelper;
|
|
namespace WorkM
|
{
|
public partial class IC_MateOutRequestBillList : Form
|
{
|
public IC_MateOutRequestBillList()
|
{
|
InitializeComponent();
|
}
|
public string ViewName;
|
public string tSQL;
|
public string HInterID;
|
public int icdev; // ͨѶÉ豸±êʶ·û
|
public short st; //º¯Êý·µ»ØÖµ
|
//public frmBillQueryCondition_New frmCondition;
|
/// <summary>
|
/// ±ÜÃâÖظ´ÁÐ
|
/// </summary>
|
public string sPrimaryCol;
|
public Pub_Class.ClsPub.Enum_OKTag OKTag;
|
public string sBillName="";
|
Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
|
|
//³õʼ»¯GRID
|
private void initGrid()
|
{
|
DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
|
}
|
|
|
//
|
public Int32 Fun_GetCol(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
|
}
|
|
//ÏÔʾÄÚÈÝ
|
private void Display()
|
{
|
ClsCN SubCn = new ClsCN();
|
DataSet DSet;
|
string sSql = "";
|
readcard();
|
//string a = "4,7,5,6";
|
//string[] arrStr = a.Split(',');
|
//string sWhere = tSQL; //ÌØÊâÌõ¼þ(ÈÕÆÚÏÞÖÆ£¬²¿ÃÅÏÞÖÆ)
|
//DBUtility.Xt_BaseBillFun.Sub_SQLWhere(ref sWhere);
|
|
//¹ýÂËÌõ¼þ
|
//if (frmCondition.SqlStr.Trim().Length == 0)
|
// return;
|
|
if (DBUtility.ClsPub.isStrNull(HInterID) == "")
|
{
|
MessageBox.Show("Çë¼ì²éÊÇ·ñ·ÅÈ뿨Ƭ»òÕß¿¨Æ¬ÊÇ·ñûÓеǼǣ¡");
|
return;
|
}
|
|
sSql = "select * from h_v_Kf_MateOutRequestBillList where hmainid in (" + HInterID + ") and ×÷·ÏÈË='' and isnull(¹ØÁªÊýÁ¿,0)<ÉêÇëÊýÁ¿";
|
|
|
//
|
DSet = SubCn.RunProcReturn(sSql, "h_v_Kf_MateOutRequestBillList", ref DBUtility.ClsPub.sExeReturnInfo);
|
//Éú³ÉÊ×ÐбêÌâ
|
if (DSet == null)
|
{
|
MessageBox.Show("ûÓзµ»ØÈκνá¹û,ÇëÔÚ¹ýÂË¿òÖеã»÷¡¾»Ö¸´¡¿°´Å¥,³¢ÊÔÔٴβéѯ£¡" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
//ÊͷŶ³½á
|
DBUtility.Xt_BaseBillFun.CancelFrozenCol(grdMain);
|
//°ó¶¨
|
grdMain.DataSource = DSet.Tables[0].DefaultView;
|
//ÉèÖúϼÆÁÐ
|
string sTotalCol = "";
|
sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
|
string[] sT;
|
sT = sTotalCol.Split(Convert.ToChar(","));
|
oSumGrid.BuildTotalCols(sT);
|
//
|
//¶³½á
|
int FrCol = 0;
|
string s = "ÊÇ";
|
DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol);
|
//»Ïß
|
GraphLine();
|
//
|
Total();
|
|
//
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
initGrid();
|
//Display();
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
OKTag = Pub_Class.ClsPub.Enum_OKTag.OKTag_Cancel;
|
this.Visible = false;
|
}
|
|
private void sx_Click(object sender, EventArgs e)
|
{
|
timer1.Enabled = true;
|
}
|
|
|
|
private void IC_MateOutRequestBillList_Load(object sender, EventArgs e)
|
{
|
//frmCondition = new frmBillQueryCondition_New();
|
//this.Text = ModCaption;
|
//lblCaption.Text = ModCaption;
|
oSumGrid.ogrdMain = grdMain; //³õʼ»¯ new
|
oSumGrid.oGridsum = grdSum;
|
initGrid();
|
}
|
|
private void cx_Click(object sender, EventArgs e)
|
{
|
//frmCondition = new frmBillQueryCondition_New();
|
//frmCondition.Tag = "";
|
//frmCondition.ViewName = ViewName;
|
//frmCondition.ModName = this.Name;
|
//frmCondition.ShowDialog();
|
//if (frmCondition.Tag.ToString() == "OK")
|
//{
|
// Display();
|
//}
|
}
|
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
//±£´æÁпí
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name,DBUtility.ClsPub.AppPath);
|
}
|
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
|
}
|
|
private void GraphicsGrid()
|
{
|
DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
|
}
|
|
//
|
private void GraphLine()
|
{
|
int MainIDCol = Fun_GetCol("hmainid");
|
int SubIDCol = Fun_GetCol("hsubid");
|
string s ="ÊÇ";
|
long n = 0;
|
DBUtility.Xt_BaseBillFun.GraphLine(grdMain, MainIDCol, SubIDCol, s, ref n);
|
//ÏÔʾ
|
lbldj.Text = "²éѯ³ö " + n.ToString() + " Õŵ¥¾Ý";
|
lbljl.Text = "¹²ÓÐ " + grdMain.RowCount.ToString() + " Ìõ¼Ç¼";
|
|
}
|
//ÊÇ·ñÔÊÐí·µ»Ø
|
private bool AllowBack() //Lock
|
{
|
string stmp="";
|
int PrimaryCol;
|
if (sPrimaryCol.Trim() != "")
|
{
|
//¸ù¾ÝÃû³Æ µÃµ½ÁкÅ
|
PrimaryCol = Fun_GetCol(sPrimaryCol);
|
if (PrimaryCol == 0)
|
{
|
return true; //ûÓÐÕÒµ½
|
}
|
else
|
{
|
for (int i = 0; i < grdMain.SelectedRows.Count; i++)
|
{
|
if (stmp == "")
|
{
|
stmp = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[PrimaryCol].Value);
|
}
|
if (stmp != DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[PrimaryCol].Value))
|
return false;
|
}
|
}
|
}
|
else
|
{
|
return true;
|
}
|
return true;
|
}
|
|
//ºÏ¼Æ new
|
private void Total()
|
{
|
if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
|
{
|
oSumGrid.SetGridsum();
|
oSumGrid.Total();
|
}
|
}
|
//ºÏ¼Æ new
|
private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
|
{
|
Total();
|
}
|
//ºÏ¼Æ new
|
private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
|
{
|
Total();
|
}
|
|
|
//·µ»ØÐÅÏ¢
|
private void Sub_DataBack()
|
{
|
//if (!AllowBack())
|
//{
|
// MessageBox.Show("²»ÔÊÐíÑ¡Ôñ²»Í¬µÄ" + sPrimaryCol + "£¡", "Ìáʾ");
|
// return;
|
//}
|
OKTag = Pub_Class.ClsPub.Enum_OKTag.OKTag_OK;
|
//this.Visible = false;
|
|
WarM.Kf_MateOutBill_K3 oMateOut = new WarM.Kf_MateOutBill_K3();
|
|
int MainIDCol = Fun_GetCol("hmainid");
|
int SubIDCol = Fun_GetCol("hsubid");
|
for (int i = 0; i < grdMain.SelectedRows.Count;i++ )
|
{
|
DBUtility.BillSelect oSelect = new DBUtility.BillSelect();
|
oSelect.BillMainID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[MainIDCol].Value);
|
oSelect.BillSubID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[SubIDCol].Value);
|
oMateOut.list.Add(oSelect);
|
}
|
oMateOut.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
oMateOut.ROB = true;
|
oMateOut.Sub_OperStatus();
|
//oMateOut.grdStatus = true;
|
oMateOut.ShowDialog();
|
//oMateOut.FillSelectDataIC(list);
|
if (oMateOut.BillChange)
|
{
|
Display();
|
}
|
}
|
|
|
|
private void timer2_Tick(object sender, EventArgs e)
|
{
|
timer2.Enabled = false;
|
//frmCondition = new frmBillQueryCondition_New();
|
//frmCondition.Tag = "";
|
//frmCondition.ViewName = ViewName;
|
//frmCondition.ModName = this.Name;
|
//frmCondition.ShowDialog();
|
//if (frmCondition.Tag.ToString() == "OK")
|
//{
|
timer1.Enabled = true;
|
//}
|
}
|
|
private void grdMain_Paint(object sender, PaintEventArgs e)
|
{
|
GraphicsGrid();
|
}
|
|
private void fh_Click(object sender, EventArgs e)
|
{
|
Sub_DataBack();
|
}
|
|
private void cmbDK_Click(object sender, EventArgs e)
|
{
|
Display();
|
}
|
private void readcard()
|
{
|
//--------------Á¬½ÓÉ豸
|
icdev = DBUtility.mwxrf32dll.rf_init(0, 115200);
|
|
if (icdev < 0)
|
{
|
MessageBox.Show("Á¬½Óʧ°Ü!");
|
return;
|
}
|
|
byte[] sRecData = new byte[20];
|
byte[] RecData = new byte[40];
|
byte[] datarecv = new byte[1000];
|
//------------------
|
byte[] key = new byte[10];
|
st = DBUtility.mwxrf32dll.rf_request(icdev, 1, datarecv);
|
if (st != 0)
|
{
|
MessageBox.Show("Çë¼ì²éÊÇ·ñ·ÅÈ뿨Ƭ!");
|
rf_exis();
|
return;
|
}
|
//-----------------------------
|
key[0] = 0xff;
|
key[1] = 0xff;
|
key[2] = 0xff;
|
key[3] = 0xff;
|
key[4] = 0xff;
|
key[5] = 0xff;
|
st = DBUtility.mwxrf32dll.rf_authentication_key(icdev, 0, 1, key);
|
if (st != 0)
|
{
|
MessageBox.Show("M1¿¨ÃÜÂëÈÏ֤ʧ°Ü!");
|
rf_exis();
|
return;
|
}
|
|
//----------------------
|
st = DBUtility.mwxrf32dll.rf_read(icdev, 1, sRecData);
|
if (st != 0)
|
{
|
MessageBox.Show("M1¿¨¶ÁÊý¾Ýʧ°Ü!");
|
rf_exis();
|
return;
|
}
|
string CardNo = Encoding.ASCII.GetString(sRecData);//------------CardNo ¿¨ºÅ
|
rf_exis();
|
CardNo = CardNo.Substring(0, CardNo.IndexOf('\0'));
|
//-----------------------
|
ClsCN oCn = new ClsCN();
|
DataSet Ds;
|
Ds = oCn.RunProcReturn("select * from Kf_MateOutRequestCardNo where hstopflag=0 and hcardno='" + CardNo + "'", "Kf_MateOutRequestCardNo");
|
if (Ds.Tables[0].Rows.Count > 0)
|
{
|
HInterID = "";
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
HInterID = HInterID + Ds.Tables[0].Rows[i]["HInterID"].ToString() + ",";
|
}
|
HInterID = HInterID.Remove(HInterID.LastIndexOf(","), 1);
|
}
|
else
|
{
|
HInterID = "";
|
}
|
}
|
private void rf_exis()
|
{
|
//---------------------¶Ï¿ªÉ豸Á¬½Ó
|
st = DBUtility.mwxrf32dll.rf_exit(icdev);
|
if (st != 0)
|
{
|
MessageBox.Show("¶Ï¿ªÁ¬½Óʧ°Ü!");
|
}
|
else
|
{
|
icdev = 0;
|
//MessageBox.Show("¶Ï¿ªÁ¬½Ó³É¹¦!");
|
}
|
}
|
}
|
}
|
