protected override void OnInitData() { base.OnInitData(); try { if (String.IsNullOrEmpty(id)) { id = String.Empty; txtProjectCode.Text = String.Empty; txtProjectName.Text = String.Empty; txtProjectDesc.Text = String.Empty; txtWorkDate.Text = String.Empty; CtrlHelper.SelectDropDownList(ddlProjectType, DropAddFlag.Select.ToString()); CtrlHelper.SelectDropDownList(ddlProjectStatus, DropAddFlag.Select.ToString()); CtrlHelper.SelectDropDownList(ddlProjectManager, DropAddFlag.Select.ToString()); CtrlHelper.SelectDropDownList(ddlWorkUnit, DropAddFlag.Select.ToString()); } else { BusProject item = SqlBaseProvider.GetBusProject(id); if (String.IsNullOrEmpty(item.ProjectID)) { throw new Exception("未找到编号为[" + id + "]的员工信息!"); } id = item.ProjectID; txtProjectCode.Text = item.ProjectCode; txtProjectName.Text = item.ProjectName; txtWorkDate.Text = item.WorkDate.ToString(); txtProjectDesc.Text = item.ProjectDesc; CtrlHelper.SelectDropDownList(ddlProjectManager, item.ProjectManager.ToString()); CtrlHelper.SelectDropDownList(ddlProjectType, item.ProjectType.ToString()); CtrlHelper.SelectDropDownList(ddlProjectStatus, item.ProjectStatus.ToString()); CtrlHelper.SelectDropDownList(ddlWorkUnit, item.WorkUnit.ToString()); int mAuth = Program.ManInfo.Auths.FindAuthByCode(this.mCode); if (!CoreCtrls.CheckAuth(mAuth, AuthType.Edit)) { this.OnDisplayAllCtrls(false); tsbCancel.Visible = false; tsbSave.Visible = false; tsbEdit.Visible = false; this.fState = FormState.Detail; } else { this.OnDisplayEditCtrls(false); this.fState = FormState.Edit; } } } catch (Exception) { throw; } }
private void ddlDB_SelectedIndexChanged(object sender, EventArgs e) { int dbid = ddlDB.SelectedValue.ToString().ToLower() == "select" ? 0 : Convert.ToInt32(ddlDB.SelectedValue); string manid = Program.ManInfo.Man.ManID; Program.DBID = dbid; BusProject project = SqlBaseProvider.GetBusProjectByDB(dbid); Program.ProjectCode = project.ProjectCode; CtrlHelper.SetDropDownList(ddlTable, SqlBaseProvider.GetTableNoPmtByDB(dbid), DropAddType.New, DropAddFlag.Select, String.Empty, "TableName,TableCode"); pTable.OnInit(); txtSet.Text = String.Empty; txtResult.Text = String.Empty; txtPackage.Text = String.Empty; txtPrefix.Text = String.Empty; txtCatalog.Text = String.Empty; txtClassName.Text = String.Empty; txtValue.Text = String.Empty; BusHours hours = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate); if (hours != null) { isHours = true; } else { isHours = false; } }
protected override void OnDeleteData() { SqlConnection conn = DBUtils.GetConnection(); SqlCommand cmd = DBUtils.GetCommand();; try { base.OnDeleteData(); if (dgvList.SelectedRows.Count != 1) { Global.ShowSysInfo("请选择需要修改的数据行!"); return; } BusProject item = new BusProject(); string id = dgvList.SelectedRows[0].Cells["ProjectID"].Value.ToString(); item.ProjectID = id; SqlBaseProvider.SaveBusProject(item, DataProviderAction.Delete); PdmDatabase db = SqlBaseProvider.GetDBByProject(id); if (db != null) { cmd.Transaction = conn.BeginTransaction(); ArrayList paras = new ArrayList(); if (db.DBID > 0) { paras.Clear(); paras.Add(DBUtils.MakeInParam("DBID", SqlDbType.Int, db.DBID)); DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, "dbo.P_Delete_Info", paras); } cmd.Transaction.Commit(); } RefreshForm(); } catch (Exception) { throw; } finally { conn.Close(); } }
protected override bool OnSaveData() { try { BusProject item = new BusProject(); item.ProjectID = id; item.ProjectCode = txtProjectCode.Text; item.ProjectName = txtProjectName.Text; item.ProjectType = ddlProjectType.SelectedValue.ToString(); item.ProjectStatus = ddlProjectStatus.SelectedValue.ToString(); item.ProjectManager = ddlProjectManager.SelectedValue.ToString(); item.WorkDate = Double.Parse(txtWorkDate.Text); item.WorkUnit = ddlWorkUnit.SelectedValue.ToString(); item.ProjectDesc = txtProjectDesc.Text; item.TranDate = DateTime.Now; item.TranUser = Program.ManInfo.Man.ManID; if (String.IsNullOrEmpty(id)) { SqlBaseProvider.SaveBusProject(item, DataProviderAction.Create); id = item.ProjectID; } else { SqlBaseProvider.SaveBusProject(item, DataProviderAction.Update); } this.OnDisplayAllCtrls(false); tsbSave.Visible = false; tsbCancel.Visible = false; fState = FormState.Detail; if (parentForm != null) { parentForm.RefreshForm(); } } catch (Exception ex) { Global.ShowSysError(ex); return(false); } return(true); }