using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace DAL
|
{
|
public partial class frmBillQueryCondition_New : Pub_Control.frmBillQueryCondition_Base
|
{
|
public frmBillQueryCondition_New()
|
{
|
InitializeComponent();
|
}
|
|
|
//°ïÖúº¯Êý
|
public override void Sub_GridKeyView(int sKeyCode, int sRow, int sCol, DataGridView grdCondition, DataGridViewTextBoxEditingControl oEdit)
|
{
|
DAL.ClsIF_Department_View oDept = new DAL.ClsIF_Department_View();
|
DAL.ClsIF_Customer_View oCus = new DAL.ClsIF_Customer_View();
|
DAL.ClsIF_Currency_View oCur = new DAL.ClsIF_Currency_View();
|
DAL.ClsIF_Employee_View oEmp = new DAL.ClsIF_Employee_View();
|
DAL.ClsIF_Material_View oMat = new DAL.ClsIF_Material_View();
|
DAL.ClsIF_Unit_View oUnit = new DAL.ClsIF_Unit_View();
|
DAL.ClsIF_Group_View oGroup = new DAL.ClsIF_Group_View();
|
DAL.ClsIF_Process_View oProc = new DAL.ClsIF_Process_View();
|
DAL.ClsIF_Supplier_View oSup = new DAL.ClsIF_Supplier_View();
|
DAL.ClsIF_Warehouse_View oWare = new DAL.ClsIF_Warehouse_View();
|
int FieldNameCol = 2;
|
int ConditionCol = 4;
|
if (sCol != ConditionCol)
|
return;
|
switch (sKeyCode)
|
{
|
case 118:
|
{
|
switch (grdCondition.Rows[sRow].Cells[FieldNameCol].Value.ToString())
|
{
|
|
case "²Ö¿â´úÂë":
|
case "ÊÕÁϲֿâ´úÂë":
|
case "·¢Áϲֿâ´úÂë":
|
case "·¢»õ²Ö¿â´úÂë":
|
case "µ÷Èë²Ö¿â´úÂë":
|
case "µ÷³ö²Ö¿â´úÂë":
|
if (oWare.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oWare.oModel.HNumber.Trim();
|
}
|
break;
|
case "²Ö¿â":
|
case "ÊÕÁϲֿâ":
|
case "·¢Áϲֿâ":
|
case "·¢»õ²Ö¿â":
|
case "µ÷Èë²Ö¿â":
|
case "µ÷³ö²Ö¿â":
|
if (oWare.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oWare.oModel.HName.Trim();
|
}
|
break;
|
case "²¿ÃÅ":
|
case "²¿ÃÅÃû³Æ":
|
case "Éú²ú³µ¼äÃû³Æ":
|
if (oDept.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oDept.oModel.HName.Trim();
|
|
}
|
break;
|
case "²¿ÃÅ´úÂë":
|
case "Éú²ú³µ¼ä´úÂë":
|
if (oDept.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oDept.oModel.HNumber.Trim();
|
}
|
break;
|
case "¹¤Ðò":
|
case "¹¤ÐòÃû³Æ":
|
if (oProc.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oProc.oModel.HName.Trim();
|
}
|
break;
|
case "¹¤Ðò´úÂë":
|
if (oProc.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oProc.oModel.HNumber.Trim();
|
}
|
break;
|
case "°à×é":
|
case "°à×éÃû³Æ":
|
if (oGroup.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oGroup.oModel.HName.Trim();
|
}
|
break;
|
case "°à×é´úÂë":
|
if (oGroup.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oGroup.oModel.HNumber.Trim();
|
}
|
break;
|
|
case "¹©Ó¦ÉÌ":
|
case "¹©Ó¦ÉÌÃû³Æ":
|
if (oSup.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oSup.oModel.HName.Trim();
|
}
|
break;
|
case "¹©Ó¦ÉÌ´úÂë":
|
if (oSup.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oSup.oModel.HNumber.Trim();
|
}
|
break;
|
case "¿Í»§":
|
case "¿Í»§Ãû³Æ":
|
if (oCus.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oCus.oModel.HName.Trim();
|
}
|
break;
|
case "¿Í»§´úÂë":
|
if (oCus.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oCus.oModel.HNumber.Trim();
|
}
|
break;
|
case "±Ò±ð":
|
case "±Ò±ðÃû³Æ":
|
case "»õ±Ò":
|
if (oCur.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oCur.oModel.HName.Trim();
|
}
|
break;
|
case "±Ò±ð´úÂë":
|
case "»õ±Ò´úÂë":
|
if (oCur.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oCur.oModel.HNumber.Trim();
|
}
|
break;
|
case "ÒµÎñÔ±":
|
case "ÒµÎñÔ±Ãû³Æ":
|
case "Ö°Ô±":
|
case "Ö°Ô±Ãû³Æ":
|
case "Ö÷¹Ü":
|
case "¸ºÔðÈË":
|
case "±£¹ÜÔ±":
|
case "ÑéÊÕÔ±":
|
case "ÁìÁÏÔ±":
|
case "¾°ìÈË":
|
case "²Ù×÷Ô±Ãû³Æ":
|
case "Ö÷¹ÜÃû³Æ":
|
if (oEmp.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oEmp.oModel.HName.Trim();
|
}
|
break;
|
case "ÒµÎñÔ±´úÂë":
|
case "Ö÷¹Ü´úÂë":
|
case "¸ºÔðÈË´úÂë":
|
case "±£¹ÜÔ±´úÂë":
|
case "ÑéÊÕÔ±´úÂë":
|
case "ÁìÁÏÔ±´úÂë":
|
case "¾°ìÈË´úÂë":
|
case "²Ù×÷Ô±´úÂë":
|
case "Ö°Ô±´úÂë":
|
if (oEmp.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oEmp.oModel.HNumber.Trim();
|
}
|
break;
|
case "ÎïÁÏÃû³Æ":
|
case "Ö÷¼þÎïÁÏÃû³Æ":
|
if (oMat.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oMat.omodel.HName.Trim();
|
}
|
break;
|
case "ÎïÁÏ´úÂë":
|
case "Ö÷¼þÎïÁÏ´úÂë":
|
if (oMat.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oMat.omodel.HNumber.Trim();
|
}
|
break;
|
case "¼ÆÁ¿µ¥Î»":
|
case "¼ÆÁ¿µ¥Î»Ãû³Æ":
|
case "Ö÷¼þ¼ÆÁ¿µ¥Î»Ãû³Æ":
|
if (oUnit.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oUnit.oModel.HName.Trim();
|
}
|
break;
|
case "¼ÆÁ¿µ¥Î»´úÂë":
|
case "Ö÷¼þ¼ÆÁ¿µ¥Î»´úÂë":
|
if (oUnit.RefreshView())
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oUnit.oModel.HNumber.Trim();
|
}
|
break;
|
case "ÈÕÆÚ":
|
case "µ¥¾ÝÈÕÆÚ":
|
DBUtility.FrmSelectDate oDate = new DBUtility.FrmSelectDate();
|
oDate.ShowDialog();
|
if (oDate.isSelected == true)
|
{
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oDate.MC1.SelectionStart.ToShortDateString();
|
grdCondition.Rows[sRow].Cells[ConditionCol].Value = oDate.MC1.SelectionEnd.ToShortDateString();
|
}
|
|
break;
|
default:
|
break;
|
}
|
oEdit.Text =DBUtility.ClsPub.isStrNull(grdCondition.Rows[sRow].Cells[ConditionCol].Value);
|
break;
|
}
|
case 117:
|
MessageBox.Show("´Ë¹¦ÄÜÉÐ먦·Å£¡", "Ìáʾ");
|
break;
|
default:
|
break;
|
}
|
}
|
}
|
}
|
