addpriceform.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 SPRFrame;
using Sybase.DataWindow;

namespace HPIResource.Price
{
    public partial class AddPriceForm : Form
    {
        int itemID;
        Price_List Price_edit;


        public AddPriceForm()
        {
            InitializeComponent();
            Price_edit = new Price_List("E");
        }

        public AddPriceForm(string Type)
        {
            InitializeComponent();
            if (Type == "E")
            {//可以保存修改Edit
                this.btn_save.Enabled = true;
            }
            if (Type == "V")
            {//只能查询View
                this.btn_save.Enabled = false;
            }
            Price_edit = new Price_List("E");
            //
            //Price_edit
            //
            //this.Price_edit.BeginUpdate += new Sybase.DataWindow.BeginUpdateEventHandler(this.Price_edit_BeginUpdate);
        }

        private void AddPriceForm_Load(object sender, EventArgs e)
        {
            this.dw_control_PriceEdit.LibraryList = Price_edit.LibraryList;
            this.dw_control_PriceEdit.DataWindowObject = Price_edit.DataWindowObject;
            Price_edit.ShareData(this.dw_control_PriceEdit);

            itemID = Convert.ToInt32(SPRF.PARM.ToString());
            if (query(itemID) == 0)
            {
                itemID = 0;
                int i = Price_edit.InsertRow(0);
                this.Price_edit.SetRow(i);
                this.Price_edit.SetItemString(i,"xiangmubm", "9");
            }
            
        }

      

        private void btn_save_Click(object sender, EventArgs e)
        {
            //判断项目编码的格式
            string sTemp = this.Price_edit.GetItemString(1, "xiangmubm");
            double iTemp;
            try
            {
                iTemp = Convert.ToInt64(sTemp);
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message + " 编码不能有字母！");
                return;
            }


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

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

        }

        private int query(int id)
        {
            Price_edit.SetDataById(id);         
            Price_edit.Retrieve();
            return Price_edit.RowCount;
        }

        private void btn_cancle_Click(object sender, EventArgs e)
        {
            SPRF.PARM = 0;
            this.Close();
        }

       
    }
}