editcdrugform.cs

.net 开发的基础框架

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using HPIResource.CDrug;
using Sybase.DataWindow;
using SPRFrame;

namespace HPIResource.CDrug
{
    public partial class EditCDrugForm : Form
    {
        int iItemID;
        CDrug_List _cdrugData;

        public EditCDrugForm()
        {
            InitializeComponent();
            _cdrugData = new CDrug_List("E");  //E--表示编辑模式
        }

        public EditCDrugForm(string sType)
        {
            InitializeComponent();
            this.btn_save.Enabled = false;

            if (sType == "E")
            {//可惜保存修改
                this.btn_save.Enabled = true;
            }

            if (sType == "V")
            {//只能查询
                this.btn_save.Enabled = false;
            }

            _cdrugData = new CDrug_List("E");
        }

        private void EditCDrugForm_Load(object sender, EventArgs e)
        {
            iItemID = Convert.ToInt32(SPRF.PARM.ToString());

            this.dw_cdrug_contrl.LibraryList = _cdrugData.LibraryList;
            this.dw_cdrug_contrl.DataWindowObject = _cdrugData.DataWindowObject;
            _cdrugData.ShareData(this.dw_cdrug_contrl);

            if (Query(iItemID) == 0)
            {
                iItemID = 0;
                int i = _cdrugData.InsertRow(0);
                _cdrugData.SetRow(i);
            }
        }

        private void btn_save_Click(object sender, EventArgs e)
        {
            if (iItemID == 0)
            {//新增时需要获取项目ID值
                iItemID = SPRF.MaxId("T_YPXX_CAO");
                if (iItemID <= 0)
                {
                    MessageBox.Show("取项目最大值出错！");
                    return;
                }

                _cdrugData.ID = iItemID;
            }

            try
            {
                _cdrugData.UpdateData();
                SPRFrame.SPRF.SQLCA.Commit();
                MessageBox.Show("保存成功！");
                SPRF.PARM = iItemID;
                this.Close();
                return;
            }
            catch (DbErrorException ee)
            {
                SPRF.ErrText = ee.SqlErrorText;
                SPRF.SQLCA.Rollback();
                MessageBox.Show(SPRF.ErrText);
                SPRF.PARM = -1;
                return;
            }
        }

        private void btn_cancel_Click(object sender, EventArgs e)
        {
            SPRF.PARM = -1;
            this.Close();
        }

        private int Query(int id)
        {
            _cdrugData.SetDataById(id);
            _cdrugData.Retrieve();
            return _cdrugData.RowCount;
        }
    }
}