editmdrugform.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.MDrug;
using Sybase.DataWindow;

using SPRFrame;

namespace HPIResource.MDrug
{
    public partial class EditMDrugForm : Form
    {
        int iItemID;
        MDrug_List _mdrugData;

        public EditMDrugForm()
        {
            InitializeComponent();
            _mdrugData = new MDrug_List("E");  //E--表示编辑模式
        }

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

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

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

            _mdrugData = new MDrug_List("E");
        }

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

            this.dw_mdrug_contrl.LibraryList = _mdrugData.LibraryList;
            this.dw_mdrug_contrl.DataWindowObject = _mdrugData.DataWindowObject;
            _mdrugData.ShareData(this.dw_mdrug_contrl);

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

        private void btn_save_Click(object sender, EventArgs e)
        {

            if (iItemID == 0)
            {//新增时需要获取项目ID值
                iItemID = SPRF.MaxId("T_YPXX_CHENG");
                if (iItemID <= 0)
                {
                    MessageBox.Show("取项目最大值出错！");
                    return;
                }

                _mdrugData.ID = iItemID;
            }

            try
            {
                _mdrugData.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)
        {
            _mdrugData.SetDataById(id);
            _mdrugData.Retrieve();
            return _mdrugData.RowCount;
        }
    }
}