Beispiel #1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                txtID.Text = txtID.Text.ToUpper();
                if (ValidData())
                {
                    switch (vAction)
                    {
                    case action.Insert:
                        var obj = new LObjectType();
                        obj.SName = Utility.sDbnull(txtName.Text);
                        obj.SDesc = Utility.sDbnull(txtDesc.Text);
                        obj.IsNew = true;
                        obj.Save();

                        drList = dtList.NewRow();
                        drList[LObjectType.Columns.Id] =
                            LObjectType.CreateQuery().GetMax(LObjectType.Columns.Id);
                        ApplyData2Datarow();
                        dtList.Rows.InsertAt(drList, 0);
                        dtList.AcceptChanges();

                        txtID.Text = Utility.sDbnull(drList[LObjectType.Columns.Id]);
                        vAction    = action.Update;
                        break;

                    case action.Update:
                        new Update(LObjectType.Schema.Name).Set(LObjectType.Columns.SName).EqualTo(txtName.Text).
                        Set(LObjectType.Columns.SDesc).EqualTo(txtDesc.Text).
                        Where(LObjectType.Columns.Id).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).
                        Execute();
                        ApplyData2Datarow();
                        drList.AcceptChanges();
                        break;
                    }
                }
            }
            catch (Exception ex)
            {
                Utility.ShowMsg(ex.Message);
            }
        }