using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace OAM
|
{
|
public partial class frm_MeetingBill : Form
|
{
|
public string id;
|
public bool zt;
|
public Int64 HInterID = 0;
|
public frm_MeetingBill()
|
{
|
InitializeComponent();
|
}
|
|
|
private void cmdOK_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (zt == false)
|
{
|
oCN.RunProc("update oa_meetingbill set " +
|
" HDate= '" + dtpHDate.Value.ToShortDateString() + "'" +
|
" ,HMeetID= '" + DBUtility.ClsPub.isLong(txtHMeetID.Tag).ToString() + "'" +
|
" ,HItem= '" + txtHItem.Text + "'" +
|
" ,HReason= '" + txtHReason.Text + "'" +
|
" ,HDept= '" + txtHDept.Text + "'" +
|
" ,HEmp= '" + txtHEmp.Text + "'" +
|
" ,HRemark= '" + txtHRemark.Text + "'" +
|
" ,HModel= '" + txtHModel.Text + "'" +
|
" ,HEDate= '" + dtpHEDate.Value.ToShortDateString() + "'" +
|
" where HInterID=" + HInterID.ToString());
|
|
MessageBox.Show("Ð޸ijɹ¦£¡");
|
}
|
else
|
{
|
if (HInterID == 0)
|
{
|
oCN.RunProc(" insert into oa_meetingbill (HDate,HMeetID,HItem,HReason,HDept,HEmp,HRemark,HMaker,HMakeDate,HType,HEDate,HModel) values (" +
|
"'" + dtpHDate.Value.ToShortDateString() + "'," + DBUtility.ClsPub.isLong(txtHMeetID.Tag).ToString() + ",'" + txtHItem.Text + "','" + txtHReason.Text +
|
"','" + txtHDept.Text + "','" + txtHEmp.Text + "','" + txtHRemark.Text + "','" + DBUtility.ClsPub.CurUserName +
|
"',getdate(),0,'" + dtpHEDate.Value.ToShortDateString() + "','" + txtHModel.Text + "') ");
|
}
|
|
MessageBox.Show("±£´æ³É¹¦£¡");
|
}
|
InitUI();
|
this.Close();
|
|
}
|
|
private void cmdCancel_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void InitUI()
|
{
|
txtHMeetID.Text = "";
|
txtHItem.Text = "";
|
txtHReason.Text = "";
|
txtHDept.Text = "";
|
txtHEmp.Text = "";
|
txtHRemark.Text = "";
|
txtHModel.Text = "";
|
HInterID = 0;
|
}
|
|
private void Display()
|
{
|
|
}
|
|
private void frm_MeetingBill_Load(object sender, EventArgs e)
|
{
|
dtpHDate.Value = DateTime.Today;
|
dtpHEDate.Value = DateTime.Today;
|
if (zt == false)
|
{
|
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Ds;
|
Ds = oCn.RunProcReturn("Select * from Oa_Meetingbill where HInterID='" + id + "'", "Oa_Meetingbill");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
return;
|
}
|
//oDeptid = Ds.Tables[0].Rows[0]["Deptid"].ToString().Trim();
|
//DataSet Ds2;
|
//Ds2 = oCn.RunProcReturn("Select * from deptlist where fitemid='" + oDeptid + "'", "deptlist");
|
//if (Ds.Tables[0].Rows.Count == 0)
|
//{
|
// return;
|
//}
|
//¸³Öµ
|
DAL.ClsOa_Meetingitem_View omee = new DAL.ClsOa_Meetingitem_View();
|
string oHMeetID = Ds.Tables[0].Rows[0]["HMeetID"].ToString();
|
|
int result;
|
if (int.TryParse(oHMeetID, out result))
|
{
|
Console.WriteLine("ת»»ºóµÄÕûÐÍÊýֵΪ£º{0}", result);
|
}
|
else
|
{
|
Console.WriteLine("ÎÞ·¨Íê³Éת»»£¡");
|
}
|
txtHModel.Tag = Ds.Tables[0].Rows[0]["HMeetID"].ToString().Trim();
|
if (omee.GetInfoByID(result))//²¿ÃÅ
|
{
|
this.txtHMeetID.Text = omee.omodel.HName;
|
this.txtHMeetID.Tag = omee.omodel.HItemID.ToString().Trim();
|
}
|
else
|
{
|
this.txtHMeetID.Text = "";
|
}
|
|
txtHModel.Text = Ds.Tables[0].Rows[0]["HModel"].ToString().Trim();
|
txtHItem.Text = Ds.Tables[0].Rows[0]["HItem"].ToString().Trim();
|
txtHReason.Text = Ds.Tables[0].Rows[0]["HReason"].ToString().Trim();
|
txtHDept.Text = Ds.Tables[0].Rows[0]["HDept"].ToString().Trim();
|
txtHEmp.Text = Ds.Tables[0].Rows[0]["HEmp"].ToString().Trim();
|
dtpHEDate.Text = Ds.Tables[0].Rows[0]["HEDate"].ToString().Trim();
|
txtHRemark.Text = Ds.Tables[0].Rows[0]["HRemark"].ToString().Trim();
|
dtpHDate.Text = Ds.Tables[0].Rows[0]["HDate"].ToString().Trim();
|
}
|
else
|
{
|
InitUI();
|
}
|
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
|
timer1.Enabled = false;
|
|
Display();
|
}
|
|
private void cmdHMeetID_Click(object sender, EventArgs e)
|
{
|
|
DAL.ClsOa_Meetingitem_View omee = new DAL.ClsOa_Meetingitem_View();
|
if (omee.RefreshView())
|
{
|
this.txtHMeetID.Text = omee.oModel.HName;
|
this.txtHMeetID.Tag = omee.oModel.HItemID.ToString();
|
}
|
else
|
{
|
this.txtHMeetID.Text = "";
|
}
|
}
|
|
private void dtpHDate_ValueChanged(object sender, EventArgs e)
|
{
|
|
}
|
|
|
|
}
|
}
|
