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 node_add1 : Form
|
{
|
public bool up_flag;
|
public string Fnumber;
|
public string Fname;
|
public string fitemid;
|
|
TreeNode CurNode = new TreeNode();
|
public node_add1()
|
{
|
InitializeComponent();
|
}
|
|
private void cmdOk_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Ds;
|
if (DBUtility.ClsPub.isStrNull(txtFnumber.Text) == "")
|
{
|
MessageBox.Show("²¿ÃűàºÅ²»ÄÜΪ¿Õ£¡", "Ìáʾ");
|
return;
|
}
|
if (DBUtility.ClsPub.isStrNull(txtFname.Text) == "")
|
{
|
MessageBox.Show("²¿ÃÅÃû³Æ²»ÄÜΪ¿Õ£¡", "Ìáʾ");
|
return;
|
}
|
if (up_flag == false)
|
{
|
oCn.RunProc("Update deptlist set " +
|
"Fname= '" + txtFname.Text.Trim() + "'Where fitemid ='" + fitemid + "'", ref DBUtility.ClsPub.sExeReturnInfo);
|
MessageBox.Show("Ð޸ijɹ¦");
|
|
txtFnumber.Text = "";
|
txtFname.Text = "";
|
this.Close();
|
}
|
else
|
{
|
//string fnumber;
|
//Ds = oCn.RunProcReturn("Select * from deptlist Where fitemid='" + fnumber + "'", "deptlist");
|
//fnumber = Ds.Tables[0].Rows[0]["Fnumber"].ToString().Trim();
|
//if (txtFnumber.Text == fnumber)
|
//{
|
//}
|
//else
|
//{
|
oCn.RunProc("Insert into deptlist " +
|
" (Fnumber,Fname) " +
|
" Values('" + txtFnumber.Text.Trim() + "','" + txtFname.Text.Trim() + "')", ref DBUtility.ClsPub.sExeReturnInfo);
|
|
MessageBox.Show("ÐÂÔö³É¹¦");
|
txtFnumber.Text = "";
|
txtFname.Text = "";
|
this.Close();
|
//}
|
|
}
|
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
txtFname.Text = Fname;
|
txtFnumber.Text = Fnumber;
|
//return;
|
}
|
|
}
|
}
|
