public void ConfigOptionButtonsVisible()
{
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
OptionButtons1.ConfigBtSaveVisible = false;
OptionButtons1.ConfigBtAddVisible = false;
bool editVidible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ProductionATS, CommCtrl.CheckAccess.MofifyATSPlan, myAccessCode);
if (editVidible)
{
OptionButtons1.ConfigBtEditVisible = true;
}
else
{
OptionButtons1.ConfigBtEditVisible = GetTestPlanAuthority();
}
OptionButtons1.ConfigBtDeleteVisible = false;
OptionButtons1.ConfigBtCancelVisible = false;
}
public void ConfigOptionButtonsVisible()
{
if (!IsPostBack)
{
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
OptionButtons1.ConfigBtSaveVisible = false;
OptionButtons1.ConfigBtCancelVisible = false;
bool orderVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ReportHeader, CommCtrl.CheckAccess.MofifyReportHeader, myAccessCode);
bool editVidible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ReportHeader, CommCtrl.CheckAccess.MofifyReportHeader, myAccessCode);
OptionButtons1.ConfigBtAddVisible = false;
OptionButtons1.ConfigBtDeleteVisible = false;
OptionButtons1.ConfigBtEditVisible = editVidible;
if (rowCount <= 1)
{
OptionButtons1.ConfigBtOrderVisible = false;
}
else
{
OptionButtons1.ConfigBtOrderVisible = orderVisible;
}
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from GlobalProductionName where ID=" + moduleTypeID, "GlobalProductionName");
mydtCoefs = pDataIO.GetDataTable("select * from GlobalManufactureCoefficientsGroup", "GlobalManufactureCoefficientsGroup");
rowCount = mydt.Rows.Count;
bindData();
string parentItem = "";
if (AddNew)
{
parentItem = "AddNewItem";
}
else
{
parentItem = pDataIO.getDbCmdExecuteScalar("select PN from GlobalProductionName where id = " + moduleTypeID).ToString();
}
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public void ConfigOptionButtonsVisible()
{
OptionButtons1.ConfigBtAddVisible = false;
if (AddNew)
{
OptionButtons1.ConfigBtEditVisible = false;
OptionButtons1.ConfigBtSaveVisible = true;
OptionButtons1.ConfigBtCancelVisible = true;
}
else
{
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
OptionButtons1.ConfigBtSaveVisible = false;
OptionButtons1.ConfigBtEditVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.Production, CommCtrl.CheckAccess.MofifyProduction, myAccessCode);
OptionButtons1.ConfigBtCancelVisible = false;
}
OptionButtons1.ConfigBtDeleteVisible = false;
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from TopoTestControl where PID=" + moduleTypeID + "ORDER BY SEQ", "TopoTestControl");
mydtProcess = mydt;
rowCount = mydt.Rows.Count;
SeqRecord();
if (!IsPostBack)
{
bindData();
}
else
{
PostBackData();
}
string parentItem = pDataIO.getDbCmdExecuteScalar("select itemName from TopoTestPlan where id = " + moduleTypeID).ToString();
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from GlobalManufactureChipsetInitialize where ID=" + moduleTypeID, "GlobalManufactureChipsetInitialize");
rowCount = mydt.Rows.Count;
columCount = mydt.Columns.Count;
bindData();
string parentItem = "";
if (AddNew)
{
parentItem = "添加新项";
}
else
{
//parentItem = Request["uIndex"];
parentItem = pDataIO.getDbCmdExecuteScalar("select ItemName from GlobalManufactureChipsetInitialize where id =" + moduleTypeID).ToString();
}
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from ChipRegister where FormulaID="+moduleTypeID, "ChipRegister");
rowCount = mydt.Rows.Count;
string parentItem = "";
parentItem = pDataIO.getDbCmdExecuteScalar("select ItemName from RegisterFormula where id =" + moduleTypeID).ToString();
RegisterName = parentItem;
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
bindData();
}
return true;
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from TopoMSAEEPROMSet where PID=" + moduleTypeID, "TopoMSAEEPROMSet");
//mydt = pDataIO.GetDataTable("select * from TopoMSAEEPROMSet where PID='6'", "TopoMSAEEPROMSet");
string tempPid = "";
DataTable temp = pDataIO.GetDataTable("select * from GlobalProductionName where ID=" + moduleTypeID, "GlobalProductionName");
//DataTable temp = pDataIO.GetDataTable("select * from GlobalProductionName where ID='6'", "GlobalProductionName");
tempPid = temp.Rows[0]["PID"].ToString().Trim();
temp = pDataIO.GetDataTable("select * from GlobalProductionType where ID=" + tempPid, "GlobalProductionType");
tempPid = temp.Rows[0]["MSAID"].ToString().Trim();
temp = pDataIO.GetDataTable("select * from GlobalMSA where ID=" + tempPid, "GlobalMSA");
ModuleTypeName = temp.Rows[0]["ItemName"].ToString().Trim();
rowCount = mydt.Rows.Count;
bindData();
string parentItem = pDataIO.getDbCmdExecuteScalar("select PN from GlobalProductionName where id = " + moduleTypeID).ToString();
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from ChipBaseInfo", "ChipBaseInfo");
rowCount = mydt.Rows.Count;
bindData();
CommCtrl pCtrl = new CommCtrl();
if (Request.QueryString["BlockType"] != null)
{
Session["BlockType"] = Request.QueryString["BlockType"];
}
else
{
Session["BlockType"] = null;
}
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, "ChipINfor", Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public void ConfigOptionButtonsVisible()
{
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
OptionButtons1.ConfigBtSaveVisible = false;
OptionButtons1.ConfigBtAddVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.MCoefGroup, CommCtrl.CheckAccess.MofifyMCoefInfo, myAccessCode);
OptionButtons1.ConfigBtEditVisible = false; //mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.MCoefInfo, CommCtrl.CheckAccess.MofifyMCoefInfo, myAccessCode);
if (mydt.Rows.Count <= 0)
{
OptionButtons1.ConfigBtDeleteVisible = false;
OptionButtons1.ConfigBtCopyVisible = false;
}
else
{
OptionButtons1.ConfigBtDeleteVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.MCoefGroup, CommCtrl.CheckAccess.MofifyMCoefInfo, myAccessCode);
OptionButtons1.ConfigBtCopyVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.MCoefGroup, CommCtrl.CheckAccess.MofifyMCoefInfo, myAccessCode);
}
OptionButtons1.ConfigBtCancelVisible = false;
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from TopoManufactureConfigInit where ID=" + moduleTypeID, "TopoManufactureConfigInit");
rowCount = mydt.Rows.Count;
columCount = mydt.Columns.Count;
bindData();
//string parentItem = Index;
string parentItem = pDataIO.getDbCmdExecuteScalar("select ItemName from TopoManufactureConfigInit where id = " + moduleTypeID).ToString();
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from TopoPNSpecsParams where PID=" + moduleTypeID, "TopoPNSpecsParams");
rowCount = mydt.Rows.Count;
mydtGlobalSpces = pDataIO.GetDataTable("select * from GlobalSpecs", "GlobalSpecs");
bindData();
string parentItem = pDataIO.getDbCmdExecuteScalar("select ItemName from TopoTestPlan where id = " + moduleTypeID).ToString();
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public void ConfigOptionButtonsVisible()
{
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
bool ModifyVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.AppModel, CommCtrl.CheckAccess.MofifyAppModel, myAccessCode);
OptionButtons1.ConfigBtAddVisible = false;
OptionButtons1.ConfigBtDeleteVisible = false;
OptionButtons1.ConfigBtEditVisible = false;
if (rowCount <= 0)
{
OptionButtons1.ConfigBtSaveVisible = false;
OptionButtons1.ConfigBtCancelVisible = false;
}
else
{
OptionButtons1.ConfigBtSaveVisible = ModifyVisible;
OptionButtons1.ConfigBtCancelVisible = ModifyVisible;
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from PNChipMap where ID=" + moduleTypeID, "PNChipMap");
mydtChip = pDataIO.GetDataTable("select * from ChipBaseInfo", "ChipBaseInfo");
rowCount = mydt.Rows.Count;
bindData();
string parentItem = "";
if (AddNew)
{
parentItem = "AddNewItem";
}
else
{
parentItem = pDataIO.getDbCmdExecuteScalar("select itemName from ChipBaseInfo where id = " + mydt.Rows[0]["ChipID"]).ToString();
}
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from GlobalProductionType where IgnoreFlag='False'", "GlobalProductionType");
rowCount = mydt.Rows.Count;
mydtMSA = pDataIO.GetDataTable("select * from GlobalMSA", "GlobalMSA");
bindData();
CommCtrl pCtrl = new CommCtrl();
if (Request.QueryString["BlockType"] != null)
{
Session["BlockType"] = Request.QueryString["BlockType"];
}
else
{
Session["BlockType"] = null;
}
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, "ATSPlan", Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from PNChipMap where PNID=" + moduleTypeID, "PNChipMap");
rowCount = mydt.Rows.Count;
bindData();
HttpContext.Current.Session["txtLevelID_" + Session["BlockType"].ToString() + "0"] = pDataIO.getDbCmdExecuteScalar("select ItemName from FunctionTable where BlockLevel=0 and BlockTypeID = " + Session["BlockType"].ToString()).ToString();
HttpContext.Current.Session["LevelID_" + Session["BlockType"].ToString() + "0_Page"] = "";
HttpContext.Current.Session["txtLevelID_" + Session["BlockType"].ToString() + "1"] = pDataIO.getDbCmdExecuteScalar("select GlobalProductionType.ItemName from GlobalProductionName,GlobalProductionType where GlobalProductionName.PID=GlobalProductionType.ID and GlobalProductionName.id = " + moduleTypeID).ToString();
string uid = pDataIO.getDbCmdExecuteScalar("select GlobalProductionType.ID from GlobalProductionName,GlobalProductionType where GlobalProductionName.PID=GlobalProductionType.ID and GlobalProductionName.id = " + moduleTypeID).ToString();
HttpContext.Current.Session["LevelID_" + Session["BlockType"].ToString() + "1_Page"] = "~/WebFiles/Production_ATS/Production/ProductionPNList.aspx?uId=" + uid;
HttpContext.Current.Session["LevelID_" + Session["BlockType"].ToString() + "2_Page"] = "~/WebFiles/Production_ATS/TestPlan/TestPlanList.aspx?uId=" + moduleTypeID.Trim();
string parentItem = pDataIO.getDbCmdExecuteScalar("select PN from GlobalProductionName where id = " + moduleTypeID).ToString();
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public void ConfigOptionButtonsVisible()
{
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
OptionButtons1.ConfigBtSaveVisible = false;
OptionButtons1.ConfigBtCancelVisible = false;
#region TestPlanAuthority
bool addVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ATSPlan, CommCtrl.CheckAccess.AddATSPlan, myAccessCode);
bool deleteVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ATSPlan, CommCtrl.CheckAccess.DeleteATSPlan, myAccessCode);
bool editVidible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ATSPlan, CommCtrl.CheckAccess.MofifyATSPlan, myAccessCode);
if (addVisible == false && deleteVisible == false && editVidible == false)
{
bool deletePlan;
bool testplanEdit = GetTestPlanAuthority(out deletePlan);
OptionButtons1.ConfigBtAddVisible = testplanEdit;
if (rowCount <= 0)
{
OptionButtons1.ConfigBtEditVisible = false;
OptionButtons1.ConfigBtDeleteVisible = false;
}
else
{
OptionButtons1.ConfigBtEditVisible = testplanEdit;
if (testplanEdit)
{
OptionButtons1.ConfigBtDeleteVisible = testplanEdit;
}
else
{
OptionButtons1.ConfigBtDeleteVisible = deletePlan;
}
}
}
else
{
OptionButtons1.ConfigBtAddVisible = addVisible;
if (rowCount <= 0)
{
OptionButtons1.ConfigBtDeleteVisible = false;
OptionButtons1.ConfigBtEditVisible = false;
}
else
{
OptionButtons1.ConfigBtDeleteVisible = deleteVisible;
OptionButtons1.ConfigBtEditVisible = editVidible;
}
}
#endregion
}
bool getInfo(string filterStr, bool isEditState = false)
{
Table pTable = new Table();
CommCtrl pCommCtrl = new CommCtrl();
try
{
pTable.ID = "ListTable";
//----------------------------
mydt = pDataIO.GetDataTable(filterStr, "GlobalManufactureCoefficients");
DataRow[] drs = mydt.Select("");
ControlList = new Frame_MCoefGroup_GlobalMCoefParam[1];
ControlList[0] = (Frame_MCoefGroup_GlobalMCoefParam)Page.LoadControl("~/Frame/MCoefGroup/GlobalMCoefParam.ascx");
ControlList[0].SetMCoefParamsEnableState(isEditState);
if (drs.Length == 1)
{
MCoefID = drs[0]["PID"].ToString();
ControlList[0].ID = "ParamID_" + drs[0]["ID"].ToString();
ControlList[0].TxtItemName = drs[0]["ItemName"].ToString();
ControlList[0].TxtItemType = drs[0]["ItemType"].ToString();
ControlList[0].TxtDdlChannel = drs[0]["Channel"].ToString();
ControlList[0].TxtPage = drs[0]["Page"].ToString();
ControlList[0].TxtStartAddress = drs[0]["StartAddress"].ToString();
ControlList[0].TxtLength = drs[0]["Length"].ToString();
ControlList[0].TxtDdlFormat = drs[0]["Format"].ToString();
ControlList[0].TxtAmplify = drs[0]["AmplifyCoeff"].ToString();
}
else if (isEditState && drs.Length == 0)
{
ControlList[0].ID = "Param_New";
ControlList[0].TxtItemName = "NewParam";
ControlList[0].TxtItemType = "";
ControlList[0].TxtDdlChannel = "0";
ControlList[0].TxtPage = "0";
ControlList[0].TxtStartAddress = "0";
ControlList[0].TxtLength = "1";
ControlList[0].TxtDdlFormat = "0";
ControlList[0].TxtAmplify = "1";
EditData("", "");
}
TableCell tc = new TableCell();
tc.Controls.Add(ControlList[0]);
TableRow tr = new TableRow();
tr.Controls.Add(tc);
pTable.Rows.Add(tr);
this.plhMain.Controls.Add(pTable);
return(true);
}
catch (Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
pDataIO.OpenDatabase(false);
throw ex;
}
}
bool getInfo(string filterStr, bool isEditState = false)
{
CommCtrl pCommCtrl = new CommCtrl();
try
{
mydt = pDataIO.GetDataTable(filterStr, "GlobalAllTestModelList");
DataTable appNameDt = pDataIO.GetDataTable("select * from GlobalAllAppModelList", "GlobalAllAppModelList");
DataRow[] drs = mydt.Select("");
ControlList = new Frame_APPModel_GlobalModelInfo[1];
ControlList[0] = (Frame_APPModel_GlobalModelInfo)Page.LoadControl("~/Frame/APPModel/GlobalModelInfo.ascx");
for (int j = 0; j < appNameDt.Rows.Count; j++)
{
ControlList[0].AddDdlAppName(new ListItem(appNameDt.Rows[j]["ItemName"].ToString(), appNameDt.Rows[j]["ID"].ToString()));
}
ControlList[0].SetModelEnableState(isEditState);
if (drs.Length == 1)
{
//ControlList[0].ID = drs[0]["ID"].ToString();
ControlList[0].TxtItemName = drs[0]["ItemName"].ToString();
ControlList[0].TxtShowName = drs[0]["ShowName"].ToString();
for (int j = 0; j < ControlList[0].DdlAppName.Items.Count; j++)
{
if (ControlList[0].DdlAppName.Items[j].Value.ToString() == drs[0]["PID"].ToString())
{
ControlList[0].DdlAppName.SelectedValue = drs[0]["PID"].ToString();
break;
}
}
ControlList[0].TxtItemDescription = drs[0]["ItemDescription"].ToString();
ControlList[0].TxtModelWeight = drs[0]["ItemPriority"].ToString();
modelWeight = Convert.ToInt32(drs[0]["ItemPriority"]);
}
else if (isEditState && drs.Length == 0)
{
ControlList[0].ID = "Model_New";
ControlList[0].TxtItemName = "NewModelName";
ControlList[0].TxtShowName = "NewShowName";
ControlList[0].DdlAppName.SelectedIndex = -1;
ControlList[0].TxtItemDescription = "Description";
ControlList[0].TxtModelWeight = "0";
EditData("", "");
}
this.plhMain.Controls.Add(ControlList[0]);
return(true);
}
catch (Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
pDataIO.OpenDatabase(false);
throw ex;
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
string typeID = "";
if (AddNew)
{
typeID = moduleTypeID;
}
else
{
typeID = pDataIO.getDbCmdExecuteScalar("select GlobalProductionType.ID from GlobalProductionName,GlobalProductionType where GlobalProductionName.PID=GlobalProductionType.ID and GlobalProductionName.id = " + moduleTypeID).ToString();
}
mydt = pDataIO.GetDataTable("select * from GlobalProductionName where ID=" + moduleTypeID, "GlobalProductionName");
mydtCoefs = pDataIO.GetDataTable("select * from GlobalManufactureCoefficientsGroup where IgnoreFlag='false' and TypeID=" + Convert.ToInt32(typeID), "GlobalManufactureCoefficientsGroup");
rowCount = mydt.Rows.Count;
bindData();
string parentItem = "";
if (AddNew)
{
parentItem = "添加新项";
HttpContext.Current.Session["txtLevelID_" + Session["BlockType"].ToString() + "1"] = pDataIO.getDbCmdExecuteScalar("select ItemName from GlobalProductionType where ID = " + moduleTypeID).ToString();
HttpContext.Current.Session["LevelID_" + Session["BlockType"].ToString() + "1_Page"] = "~/WebFiles/Production_ATS/Production/ProductionPNList.aspx?uId=" + moduleTypeID;
HttpContext.Current.Session["LevelID_" + Session["BlockType"].ToString() + "2_Page"] = "";
}
else
{
parentItem = pDataIO.getDbCmdExecuteScalar("select PN from GlobalProductionName where id = " + moduleTypeID).ToString();
HttpContext.Current.Session["txtLevelID_" + Session["BlockType"].ToString() + "1"] = pDataIO.getDbCmdExecuteScalar("select GlobalProductionType.ItemName from GlobalProductionName,GlobalProductionType where GlobalProductionName.PID=GlobalProductionType.ID and GlobalProductionName.id = " + moduleTypeID).ToString();
HttpContext.Current.Session["LevelID_" + Session["BlockType"].ToString() + "1_Page"] = "~/WebFiles/Production_ATS/Production/ProductionPNList.aspx?uId=" + typeID;
HttpContext.Current.Session["LevelID_" + Session["BlockType"].ToString() + "2_Page"] = "~/WebFiles/Production_ATS/TestPlan/TestPlanList.aspx?uId=" + moduleTypeID.Trim();
}
HttpContext.Current.Session["txtLevelID_" + Session["BlockType"].ToString() + "0"] = pDataIO.getDbCmdExecuteScalar("select ItemName from FunctionTable where BlockLevel=0 and BlockTypeID = " + Session["BlockType"].ToString()).ToString();
HttpContext.Current.Session["LevelID_" + Session["BlockType"].ToString() + "0_Page"] = "";
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
//mydtCoefs = pDataIO.GetDataTable("select * from GlobalManufactureCoefficientsGroup where IgnoreFlag='false' and TypeID=" + Convert.ToInt32(typeID), "GlobalManufactureCoefficientsGroup");
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public void creattNavi()
{
try
{
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, "OPLogsInfor", Session["BlockType"].ToString(), mysql, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
catch (System.Exception ex)
{
throw ex;
}
}
bool getInfo(string filterStr, bool isEditState = false)
{
CommCtrl pCommCtrl = new CommCtrl();
try
{
mydt = pDataIO.GetDataTable(filterStr, "GlobalTestModelParamterList");
DataRow[] drs = mydt.Select("");
ControlList = new Frame_APPModel_GlobalModelParam[1];
ControlList[0] = (Frame_APPModel_GlobalModelParam)Page.LoadControl("~/Frame/APPModel/GlobalModelParam.ascx");
ControlList[0].SetModelParamsEnableState(isEditState);
if (drs.Length == 1)
{
ModelID = drs[0]["PID"].ToString();
ControlList[0].ID = "ParamID_" + drs[0]["ID"].ToString();
ControlList[0].TxtItemName = drs[0]["ItemName"].ToString();
ControlList[0].TxtShowName = drs[0]["ShowName"].ToString();
int temp = ControlList[0].GSItemTypeDropDownList;
string strItemType = drs[0]["ItemType"].ToString().Replace(" ", "");
ControlList[0].GSItemTypeDropDownList = ChangeItemTypeNametoIndex(strItemType.ToUpper().Trim());
ConfigValidator(strItemType, ControlList[0]);
ControlList[0].TxtItemValue = drs[0]["ItemValue"].ToString();
ControlList[0].TxtddlNeedCheckParams = drs[0]["NeedSelect"].ToString();
ControlList[0].TxtOptionalparams = drs[0]["Optionalparams"].ToString();
ControlList[0].TxtItemDescription = drs[0]["ItemDescription"].ToString();
ControlList[0].SetModelParamsEnableState(false);
}
else if (isEditState && drs.Length == 0)
{
ControlList[0].ID = "Param_New";
ControlList[0].TxtItemName = "NewParamName";
ControlList[0].TxtShowName = "NewShowName";
ControlList[0].TxtItemValue = "NewValue";
ControlList[0].GSItemTypeDropDownList = 0;
ConfigValidator(ChangeItemTypeIndextoName(ControlList[0].GSItemTypeDropDownList), ControlList[0]);
ControlList[0].TxtItemDescription = "Description";
EditData("", "");
}
this.plhMain.Controls.Add(ControlList[0]);
return(true);
}
catch (Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
pDataIO.OpenDatabase(false);
throw ex;
}
}
bool getInfo(string filterStr, bool isEditMode = false)
{
Table pTable = new Table();
CommCtrl pCommCtrl = new CommCtrl();
try
{
string parentItem = pDataIO.getDbCmdExecuteScalar("select LoginName from UserInfo where id = " + currID).ToString();
if (AddNew)
{
parentItem = "添加新项";
EditData("", "");
}
Control myCtrl = pCommCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
pTable.ID = "ListTable";
DataTable pReaderTable = pDataIO.GetDataTable(filterStr, "UserInfo");
ControlList = (Frame_UserRoleFunc_userInfo)Page.LoadControl("~/Frame/UserRoleFunc/userInfo.ascx");
ControlList.SetEnableState(isEditMode);
if (pReaderTable.Rows.Count == 1 && !AddNew)
{
ControlList.TxtLoginName = pReaderTable.Rows[0]["LoginName"].ToString();
ControlList.TxtPwd = "******";
ControlList.TxtTrueName = pReaderTable.Rows[0]["TrueName"].ToString();
ControlList.TxtRemarks = pReaderTable.Rows[0]["Remarks"].ToString();
}
else if (AddNew)
{
ControlList.TxtPwd = "111111";
}
TableCell tc = new TableCell();
TableRow tr = new TableRow();
tc.Controls.Add(ControlList);
tr.Cells.Add(tc);
pTable.Controls.Add(tr);
//setItemEnabled(isEditMode);
this.plhMain.Controls.Add(pTable);
return(true);
}
catch (Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
pDataIO.OpenDatabase(false);
throw ex;
}
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from GlobalProductionType where ID=" + moduleTypeID, "GlobalProductionType");
if (AddNew)
{
mydtMSA = pDataIO.GetDataTable("select * from GlobalMSA where IgnoreFlag='false'", "GlobalMSA");
}
else
{
if (IsPostBack)
{
mydtMSA = pDataIO.GetDataTable("select * from GlobalMSA where IgnoreFlag='false'", "GlobalMSA");
}
else
{
mydtMSA = pDataIO.GetDataTable("select * from GlobalMSA", "GlobalMSA");
}
}
rowCount = mydt.Rows.Count;
columCount = mydt.Columns.Count;
bindData();
string parentItem = "";
if (AddNew)
{
parentItem = "AddNewItem";
}
else
{
parentItem = pDataIO.getDbCmdExecuteScalar("select itemName from GlobalProductionType where id = " + moduleTypeID).ToString();
}
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
public void ConfigOptionButtonsVisible()
{
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
OptionButtons1.ConfigBtSaveVisible = false;
OptionButtons1.ConfigBtEditVisible = false;
OptionButtons1.ConfigBtCancelVisible = false;
#region PNAuthority
bool addVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ProductionATS, CommCtrl.CheckAccess.AddATSPlan, myAccessCode);
bool deleteVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ProductionATS, CommCtrl.CheckAccess.DeleteATSPlan, myAccessCode);
if (addVisible == false && deleteVisible == false)
{
bool pnEdit = PNAuthority();
OptionButtons1.ConfigBtAddVisible = pnEdit;
if (rowCount <= 0)
{
OptionButtons1.ConfigBtDeleteVisible = false;
}
else
{
OptionButtons1.ConfigBtDeleteVisible = pnEdit;
}
}
else
{
OptionButtons1.ConfigBtAddVisible = addVisible;
if (rowCount <= 0)
{
OptionButtons1.ConfigBtDeleteVisible = false;
}
else
{
OptionButtons1.ConfigBtDeleteVisible = deleteVisible;
}
}
#endregion
}
public void ConfigOptionButtonsVisible()
{
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
OptionButtons1.ConfigBtSaveVisible = false;
OptionButtons1.ConfigBtAddVisible = false; //mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.Equipment, CommCtrl.CheckAccess.AddEquipment, myAccessCode);
OptionButtons1.ConfigBtEditVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.GlobalEquipment, CommCtrl.CheckAccess.MofifyEquipment, myAccessCode);
OptionButtons1.ConfigBtDeleteVisible = false; //mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.Equipment, CommCtrl.CheckAccess.DeleteEquipment, myAccessCode);
OptionButtons1.ConfigBtCancelVisible = false;
}
public void ConfigOptionButtonsVisible()
{
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
OptionButtons1.ConfigBtSaveVisible = false;
OptionButtons1.ConfigBtAddVisible = false;
OptionButtons1.ConfigBtEditVisible = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ConfigSpecs, CommCtrl.CheckAccess.EditConfigSpecs, myAccessCode);
OptionButtons1.ConfigBtDeleteVisible = false;
OptionButtons1.ConfigBtCancelVisible = false;
}
public bool connectDataBase()
{
try
{
if (pDataIO.OpenDatabase(true))
{
mydt = pDataIO.GetDataTable("select * from ChannelMap where ID=" + moduleTypeID, "ChannelMap");
rowCount = mydt.Rows.Count;
if (rowCount == 1 && !AddNew)
{
DataTable temp = pDataIO.GetDataTable("select * from PNChipMap where ID=" + mydt.Rows[0]["PNChipID"].ToString().Trim(), "PNChipMap");
DataTable temp1 = pDataIO.GetDataTable("select * from ChipBaseInfo where ID=" + temp.Rows[0]["ChipID"].ToString().Trim(), "ChipBaseInfo");
DataTable temp2 = pDataIO.GetDataTable("select * from GlobalProductionName where ID=" + temp.Rows[0]["PNID"].ToString().Trim(), "GlobalProductionName");
chipChannelCount = Convert.ToByte(temp1.Rows[0]["Channels"]);
moduleChannelCount = Convert.ToByte(temp2.Rows[0]["Channels"]);
}
if (AddNew)
{
DataTable temp = pDataIO.GetDataTable("select * from PNChipMap where ID=" + moduleTypeID, "PNChipMap");
DataTable temp1 = pDataIO.GetDataTable("select * from ChipBaseInfo where ID=" + temp.Rows[0]["ChipID"].ToString().Trim(), "ChipBaseInfo");
DataTable temp2 = pDataIO.GetDataTable("select * from GlobalProductionName where ID=" + temp.Rows[0]["PNID"].ToString().Trim(), "GlobalProductionName");
chipChannelCount = Convert.ToByte(temp1.Rows[0]["Channels"]);
moduleChannelCount = Convert.ToByte(temp2.Rows[0]["Channels"]);
}
bindData();
string parentItem = "";
if (AddNew)
{
parentItem = "AddNewItem";
}
else
{
parentItem = "ChannelMap";
}
CommCtrl pCtrl = new CommCtrl();
Control myCtrl = pCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO, out logTracingString);
this.plhNavi.Controls.Add(myCtrl);
}
return(true);
}
catch (System.Exception ex)
{
pDataIO.WriteErrorLogs(ex.ToString());
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (!IsPostBack)
{
IsSessionNull();
rowCount = 0;
conn = "inpcsz0518\\ATS_HOME";
string serverName = ConfigurationManager.AppSettings["ServerName"].ToString();
string dbName = "";
string userId = ConfigurationManager.AppSettings["UserId"].ToString();
string pwd = ConfigurationManager.AppSettings["Pwd"].ToString();
if (Session["DB"] == null)
{
Response.Redirect("~/Default.aspx", true);
}
else if (Session["DB"].ToString().ToUpper() == "ATSDB")
{
dbName = ConfigurationManager.AppSettings["DbName"].ToString();
}
else if (Session["DB"].ToString().ToUpper() == "ATSDEBUGDB")
{
dbName = ConfigurationManager.AppSettings["DbName2"].ToString();
}
pDataIO = null;
pDataIO = new SqlManager(serverName, dbName, userId, pwd);
mydt.Clear();
Session["TreeNodeExpand"] = null;
SetSessionBlockType(1);
moduleTypeID = Request["uId"];
SourceTestPlanID = Request["sourceID"];
connectDataBase();
LoadOptionButton();
ConfigOptionButtonsVisible();
}
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
testPlanAddFunctionAuthority = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ProductionATS, CommCtrl.CheckAccess.AddATSPlan, myAccessCode);
}
public void ConfigOptionButtonsVisible()
{
int myAccessCode = 0;
if (Session["AccCode"] != null)
{
myAccessCode = Convert.ToInt32(Session["AccCode"]);
}
CommCtrl mCommCtrl = new CommCtrl();
OptionButtons1.ConfigBtSaveVisible = false;
bool addTestPlan = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ProductionATS, CommCtrl.CheckAccess.AddATSPlan, myAccessCode);
if (addTestPlan)
{
OptionButtons1.ConfigBtAddVisible = true;
OptionButtons1.ConfigBtCopyVisible = true;
}
else
{
bool addPlan = PNAuthority();
OptionButtons1.ConfigBtAddVisible = addPlan;
OptionButtons1.ConfigBtCopyVisible = addPlan;
}
OptionButtons1.ConfigBtEditVisible = false;
if (rowCount <= 0)
{
OptionButtons1.ConfigBtDeleteVisible = false;
OptionButtons1.ConfigBtCopyVisible = false;
}
else
{
deleteFunctionAuthority = mCommCtrl.CheckLoginAccess(CommCtrl.FunctionName.ProductionATS, CommCtrl.CheckAccess.DeleteATSPlan, myAccessCode);
if (deleteFunctionAuthority)
{
OptionButtons1.ConfigBtDeleteVisible = true;
}
else
{
GetTestPlanAuthority();
OptionButtons1.ConfigBtDeleteVisible = DeleteButtonVisibleWhenReadAuthority();
}
}
OptionButtons1.ConfigBtCancelVisible = false;
}
