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);
}
