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;
}
}
private void EditProject_Load(object sender, EventArgs e)
{
CtrlHelper.SetDropDownList(ddlProjectType, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Project_Type order by ProjectType", SqlTextType.Text, "ProjectTypeName,ProjectType"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlWorkUnit, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Work_Unit order by WorkUnit", SqlTextType.Text, "WorkUnitName,WorkUnit"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlProjectManager, CoreCtrls.GetComboBoxItems("select b.Man_ID, b.Man_Name from T_Sys_Oper_Role a, T_Sys_Man b where a.Man_ID = b.Man_ID and a.Role_ID = '1'", SqlTextType.Text, "Man_Name,Man_ID"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlProjectStatus, CoreCtrls.GetComboBoxItems("Select ProjectStatus, ProjectStatusName from T_Pmt_Project_Status order by ProjectStatus", SqlTextType.Text, "ProjectStatusName,ProjectStatus"), DropAddType.New, DropAddFlag.Select);
this.allCtrls = new object[] { txtProjectCode, txtProjectName, ddlProjectType, ddlProjectStatus, ddlProjectManager, txtWorkDate, ddlWorkUnit, txtProjectDesc };
this.editCtrls = new object[] { };
OnInitData();
}
private void EditRole_Load(object sender, EventArgs e)
{
tpMenu.BackColor = this.BackColor;
tpNav.BackColor = this.BackColor;
scEdit.BackColor = this.BackColor;
scEdit.Panel1.BackColor = this.BackColor;
scEdit.Panel2.BackColor = this.BackColor;
plEdit.BackColor = this.BackColor;
CtrlHelper.SetDropDownList(ddlData, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Auth_Bound order by Auth_Bound", SqlTextType.Text, "Auth_Bound_Name,Auth_Bound"), DropAddType.New, DropAddFlag.Select);
this.allCtrls = new object[] { txtRoleName, ddlData, txtRoleDesc, clNav, clMenu, clAuth };
OnInitData();
}
private void ManDept_Load(object sender, EventArgs e)
{
if (!DesignMode)
{
OnInitAuth();
}
CtrlHelper.SetDropDownList(ddlDeptStatus, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Dept_Status order by Dept_Status", SqlTextType.Text, "Dept_Status_Name,Dept_Status"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlDeptType, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Dept_Type order by Dept_Type", SqlTextType.Text, "Dept_Type_Name,Dept_Type"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlDeptLevel, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Dept_Level order by Dept_Level", SqlTextType.Text, "Dept_Level_Name,Dept_Level"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlCoID, CoreCtrls.GetComboBoxItems("Select * from T_Sys_Company order by Co_ID", SqlTextType.Text, "Co_Name,Co_ID"), DropAddType.New, DropAddFlag.Select);
OnBindData();
OnInitData();
CtrlHelper.DisableCtrls(allCtrls);
tsbCancel.Visible = false;
tsbSave.Visible = false;
}
private void EditMan_Load(object sender, EventArgs e)
{
ectDept.Tree.ComboTreeType = WinControls.ComboTreeType.All;
ectDept.Tree.TypeText = "所有部门";
ectDept.Tree.DataSource = SqlBaseProvider.GetSimpleValidDept();
ectDept.Tree.DisplayMember = "Dept_Name";
ectDept.Tree.ValueMember = "Dept_ID";
ectDept.Tree.ParentMember = "Dept_PID";
ectDept.Tree.Height = 200;
ectDept.AbsoluteChildrenSelectableOnly = false;
CtrlHelper.SetDropDownList(ddlManType, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Man_Type order by Man_Type", SqlTextType.Text, "Man_Type_Name,Man_Type"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlManTitle, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Man_Title order by Man_Title", SqlTextType.Text, "Man_Title_Name,Man_Title"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlManLevel, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Man_Level order by Man_Level", SqlTextType.Text, "Man_Level_Name,Man_Level"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlManStatus, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Man_Status order by Man_Status", SqlTextType.Text, "Man_Status_Name,Man_Status"), DropAddType.New, DropAddFlag.Select);
this.allCtrls = new object[] { txtManID, txtManName, txtManTele, ddlManLevel, ddlManStatus, ddlManTitle, ddlManType, ectDept };
this.editCtrls = new object[] { txtManID };
OnInitData();
}
public ImportPdm()
{
InitializeComponent();
CtrlHelper.SetDropDownList(ddlProject, CoreCtrls.GetComboBoxItems("Select * from T_Bus_Project order by ProjectID", SqlTextType.Text, "ProjectName,ProjectID"), DropAddType.New, DropAddFlag.Select);
}
private void ManCompany_Load(object sender, EventArgs e)
{
this.PageOrRow = false;
CtrlHelper.SetDropDownList(ddlCoStatus, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Co_Status order by Co_Status", SqlTextType.Text, "Co_Status_Name,Co_Status"), DropAddType.New, DropAddFlag.Select);
}
private void initForm()
{
CtrlHelper.SetDropDownList(ddlDB, SqlBaseProvider.GetDBForCombox(Convert.ToInt32(DataBaseType.MySql)), DropAddType.New, DropAddFlag.Select, String.Empty, "DBName,DBID");
ddlDB.SelectedValueChanged += new EventHandler(ddlDB_SelectedIndexChanged);
pTable = new PdmTable();
}
