protected void btnAddConstant_Click(object sender, EventArgs e)
{
int index = KPI_ConstantDal.ConstantIDCounts();
string sID = PageControl.GetGuid();
ConstantEntity ote = new ConstantEntity();
ote.ConstantID = sID;
ote.ConstantCode = "InputCode";
ote.ConstantName = "Input Name";
ote.ConstantDesc = "";
ote.ConstantValue = "Input Value";
ote.ConstantNote = "";
ote.ConstantCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.ConstantModifyTime = ote.ConstantCreateTime;
if (KPI_ConstantDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
gvConstant.EditIndex = index;
BindConstant();
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
}
protected void btnAddPosition_Click(object sender, EventArgs e)
{
int index = KPI_PositionDal.PositionIDCounts();
string sID = PageControl.GetGuid();
KPI_PositionEntity ote = new KPI_PositionEntity();
ote.PositionID = sID;
ote.PositionName = "InputName";
ote.PositionDesc = "";
ote.PositionWeight = 10;
ote.PositionIsHand = "1";
ote.PositionIsShift = "1";
ote.PositionIsValid = "1";
ote.PositionNote = "";
ote.PositionCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.PositionModifyTime = ote.PositionCreateTime;
if (KPI_PositionDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
gvPosition.EditIndex = index;
BindPosition();
}
protected void btnAddEngunit_Click(object sender, EventArgs e)
{
int index = EngunitDal.EngunitIDCounts();
string sID = PageControl.GetGuid();
EngunitEntity ote = new EngunitEntity();
ote.EngunitID = sID;
ote.EngunitName = "Input Name";
ote.EngunitDesc = "";
ote.EngunitNote = "";
ote.EngunitCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.EngunitModifyTime = ote.EngunitCreateTime;
if (EngunitDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
gvEngunit.EditIndex = index;
BindGrid();
}
protected void btnAddTeam_Click(object sender, EventArgs e)
{
int index = KPI_TeamDal.TeamIDCounts();
string sID = PageControl.GetGuid();
KPI_TeamEntity ote = new KPI_TeamEntity();
ote.TeamID = sID;
ote.ShiftID = "";
ote.PersonID = "";
ote.PositionID = "";
ote.TeamPersonID = "";
ote.TeamNote = "";
ote.TeamCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.TeamModifyTime = ote.TeamCreateTime;
if (KPI_TeamDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
gvTeam.EditIndex = index;
BindTeamByTime();
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
}
/// <summary>
/// 插入数据
/// </summary>
/// <returns></returns>
bool Insert()
{
string unitid = PageControl.GetGuid();
KPI_UnitEntity mEntity = new KPI_UnitEntity();
mEntity.UnitID = unitid;
mEntity.PlantID = ddl_PlantID.Value;
mEntity.UnitCode = txt_UnitCode.Value.Trim();
mEntity.UnitName = txt_UnitName.Value.Trim();
mEntity.UnitDesc = txt_UnitDesc.Value.Trim();
mEntity.UnitIndex = int.Parse(txt_UnitIndex.Value.Trim());
mEntity.UnitIsValid = int.Parse(ddl_UnitIsValid.Value);
mEntity.UnitPrefix = txt_UnitPrefix.Value;
mEntity.UnitMW = decimal.Parse(txt_UnitMW.Value);
mEntity.UnitMWTag = txt_UnitMWTag.Value;
mEntity.UnitCondition = txt_UnitCondition.Value.Replace("'", "''");
mEntity.UnitIsKPI = int.Parse(ddl_UnitIsKPI.Value);
mEntity.UnitIsSnapshot = int.Parse(ddl_UnitIsSnapshot.Value);
mEntity.UnitIsSort = int.Parse(ddl_UnitIsSort.Value);
mEntity.UnitIsSecurity = int.Parse(ddl_UnitIsSecurity.Value);
mEntity.UnitIsPower = int.Parse(ddl_UnitIsPower.Value);
mEntity.WorkID = ddl_UnitWorkID.Value;
mEntity.UnitNote = txt_UnitNote.Value.Trim();
mEntity.UnitCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
mEntity.UnitModifyTime = mEntity.UnitCreateTime;
return(KPI_UnitDal.Insert(mEntity));
}
protected void btnAddWeb_Click(object sender, EventArgs e)
{
int index = KPI_WebDal.WebIDCounts();
KPI_WebEntity gwe = new KPI_WebEntity();
gwe.WebID = PageControl.GetGuid();
gwe.WebCode = "InputCode";
gwe.WebDesc = "Input Description";
gwe.WebType = 0;
gwe.WebNote = "";
gwe.WebCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
gwe.WebModifyTime = gwe.WebCreateTime;
if (KPI_WebDal.Insert(gwe))
{
gvWeb.EditIndex = index;
BindWebs();
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "添加失败！", "call();");
}
return;
}
protected void btnAddCycle_Click(object sender, EventArgs e)
{
int index = CycleDal.CycleIDCounts();
string sID = PageControl.GetGuid();
CycleEntity ote = new CycleEntity();
ote.CycleID = sID;
ote.CycleName = "TX";
ote.CycleDesc = "10分钟";
ote.CycleValue = 10;
ote.CycleNote = "分钟计算周期";
ote.CycleCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.CycleModifyTime = ote.CycleCreateTime;
if (CycleDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
gvCycle.EditIndex = index;
BindGrid();
}
protected void btnAddLinq_Click(object sender, EventArgs e)
{
int index = KPI_LinqDal.LinqIDCounts();
string sID = PageControl.GetGuid();
LinqEntity ote = new LinqEntity();
ote.LinqID = sID;
ote.LinqName = "InputName";
ote.LinqDesc = "";
ote.LinqEngunit = "";
ote.LinqIndex = index + 1;
ote.LinqIsValid = 1;
ote.LinqNote = "";
ote.LinqCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.LinqModifyTime = ote.LinqCreateTime;
if (KPI_LinqDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
gvLinq.EditIndex = index;
BindGrid();
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
}
protected void btnAddKpi_Click(object sender, EventArgs e)
{
int index = KpiDal.KpiIDCounts();
string sID = PageControl.GetGuid();
KpiEntity ote = new KpiEntity();
ote.KpiID = sID;
ote.KpiCode = "InputCode";
ote.KpiName = "Input Name";
ote.KpiDesc = "";
ote.KpiIsValid = 1;
ote.KpiNote = "";
ote.KpiCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.KpiModifyTime = ote.KpiCreateTime;
if (KpiDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
gvKpi.EditIndex = index;
BindKpi();
}
protected bool ImportFromExcelToCreate(DataSet ds)
{
try
{
System.Data.DataTable dt = ds.Tables[0];
int nAll = dt.Rows.Count;
int nCreate = 0;
int nExist = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["SelectX"].ToString().ToLower() == "x")
{
//string PersonCode = dr["PersonCode"].ToString().Trim();
////判断是否存在
//if (KPI_PersonDal.PersonCodeExists(PersonCode, ""))
//{
// //MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
// nExist += 1;
// continue;
//}
//main tag
string keyid = PageControl.GetGuid();
KPI_TeamEntity mEntity = new KPI_TeamEntity();
mEntity.TeamID = keyid;
mEntity.PlantID = KPI_PlantDal.GetPlantID(dr["PlantName"].ToString().Trim());
mEntity.ShiftID = KPI_ShiftDal.GetShiftID(dr["ShiftName"].ToString().Trim());
mEntity.PersonID = KPI_PersonDal.GetPersonID(dr["PersonCode"].ToString().Trim());
mEntity.PositionID = KPI_PersonDal.GetPositionID(mEntity.PersonID);
//PersonName,无多大意义
mEntity.PositionID = KPI_PositionDal.GetPositionID(dr["PositionName"].ToString().Trim());
mEntity.TeamNote = dr["TeamNote"].ToString().Trim();
KPI_TeamDal.Insert(mEntity);
nCreate += 1;
}
}
string strInfor = "标签点总数为：{0}个, 创建成功:{1}个，已存在标签点: {2}个。";
strInfor = string.Format(strInfor, nAll, nCreate, nExist);
MessageBox.popupClientMessage(this.Page, strInfor, "call();");
return(true);
}
catch (Exception ee)
{
//
MessageBox.popupClientMessage(this.Page, ee.Message, "call();");
return(false);
}
}
/// <summary>
/// 插入数据
/// </summary>
/// <returns></returns>
bool Insert()
{
string LinqID = ViewState["linqid"].ToString();
string keyid = PageControl.GetGuid();
LinqTagEntity mEntity = new LinqTagEntity();
mEntity.TagID = keyid;
mEntity.LinqID = LinqID;
mEntity.UnitID = ddl_UnitID.SelectedValue;
mEntity.UnitName = ddl_UnitID.SelectedItem.Text;
mEntity.ECID = ddl_ECID.SelectedValue;
mEntity.ECName = ddl_ECID.SelectedItem.Text;
return(LinqTagDal.Insert(mEntity));
}
protected void btnAddSecurity_Click(object sender, EventArgs e)
{
string said = ViewState["said"].ToString();
if (said == "")
{
//btnAddSecurity.Enabled = false;
MessageBox.popupClientMessage(this.Page, "请先点击应用按钮生成新的安全指标！", "call();");
return;
}
int index = KPI_SecurityDal.SecurityIDCounts(said);
KPI_SecurityEntity ote = new KPI_SecurityEntity();
ote.SecurityID = PageControl.GetGuid();
ote.SAID = said;
ote.SecurityCalcExp = "Input Calc Exp";
ote.SecurityGainExp = "1";
ote.SecurityOptimal = 0;
ote.SecurityAlarm = 0;
ote.SecurityIsValid = 1;
//ote.SecurityNote = "";
//ote.SecurityCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
//ote.SecurityModifyTime = ote.SecurityCreateTime;
//if (KPI_SecurityDal.Insert(ote))
//{
// //MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
// gvSecurity.EditIndex = index;
// BindSecurity();
//}
//else
//{
// MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
//}
}
public void KPI_Web_Add(HttpContext context)
{
string sID = PageControl.GetGuid();
string sCode = context.Request["WebCode"];
string sDesc = context.Request["WebDesc"];
string sType = context.Request["WebType"];
string sNote = context.Request["WebNote"];
if (sCode == "")
{
context.Response.Write("{\"status\":\"代码不能为空！\"}");
return;
}
//名称是否重复
if (KPI_WebDal.WebCodeExists(sCode, sID))
{
context.Response.Write("{\"status\":\"已存在相同的代码！\"}");
return;
}
//更新
KPI_WebEntity ote = new KPI_WebEntity();
ote.WebID = sID;
ote.WebCode = sCode;
ote.WebDesc = sDesc;
ote.WebType = int.Parse(sType);
ote.WebNote = sNote;
ote.WebCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.WebModifyTime = ote.WebCreateTime;
if (KPI_WebDal.Insert(ote))
{
context.Response.Write("{\"status\":\"ok\"}");
return;
}
else
{
context.Response.Write("{\"status\":\"添加失败！\"}");
return;
}
}
protected void btnAddReal_Click(object sender, EventArgs e)
{
if (ddlUnitID.SelectedValue == "ALL")
{
MessageBox.popupClientMessage(this.Page, "请选择具体机组！", "call();");
return;
}
string UnitID = ddlUnitID.SelectedValue.Trim();
int index = KPI_RealTagDal.IDCounts(UnitID);
string sID = PageControl.GetGuid();
KPI_RealTagEntity ote = new KPI_RealTagEntity();
ote.RealID = sID;
ote.UnitID = UnitID;
ote.RealCode = "InputCode";
ote.RealDesc = "Input DEsc";
ote.RealEngunit = "Input Engunit";
ote.RealSnapshot = "0";
ote.RealSort = "1";
ote.RealDisplay = "0";
ote.RealXYZ = "0";
ote.RealNote = "";
ote.RealCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.RealModifyTime = ote.RealCreateTime;
if (KPI_RealTagDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
gvReal.EditIndex = index;
BindReal();
}
/// <summary>
/// 插入数据
/// </summary>
/// <returns></returns>
bool Insert()
{
string plantid = PageControl.GetGuid();
KPI_PlantEntity mEntity = new KPI_PlantEntity();
mEntity.PlantID = plantid;
mEntity.PlantCode = txt_PlantCode.Value.Trim();
mEntity.PlantName = txt_PlantName.Value.Trim();
mEntity.PlantDesc = txt_PlantDesc.Value.Trim();
mEntity.PlantIndex = int.Parse(txt_PlantIndex.Value.Trim());
mEntity.PlantIsValid = int.Parse(ddl_PlantIsValid.Value);
mEntity.PlantAddress = txt_PlantAddress.Value.Trim();
mEntity.PlantNote = txt_PlantNote.Value.Trim();
mEntity.PlantCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
mEntity.PlantModifyTime = mEntity.PlantCreateTime;
return(KPI_PlantDal.Insert(mEntity));
}
protected void btnAddPeriod_Click(object sender, EventArgs e)
{
//集团信息，新增页面
//string strjs = "<script language=javascript>window.open('KPI_SubRunPeriod.aspx','newwindow','width=500,height=400')</script>";
//ClientScript.RegisterStartupScript(this.GetType(), "", strjs);
int index = KPI_PeriodDal.PeriodIDCounts();
string sID = PageControl.GetGuid();
KPI_PeriodEntity ote = new KPI_PeriodEntity();
ote.PeriodID = sID;
ote.PeriodCode = KPI_PeriodDal.GetNextCode();
ote.PeriodName = "InputName";
ote.PeriodDesc = "";
ote.PeriodStartHour = 8;
ote.PeriodEndHour = 17;
ote.PeriodHours = 9;
ote.PeriodIsIDL = "0";
ote.PeriodIsValid = "1";
ote.PeriodNote = "";
ote.PeriodCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.PeriodModifyTime = ote.PeriodCreateTime;
if (KPI_PeriodDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
gvPeriod.EditIndex = index;
BindPeriod();
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
}
protected void btnAddCurve_Click(object sender, EventArgs e)
{
int index = CurveTagDal.CurveIDCounts();
string sID = PageControl.GetGuid();
CurveTagEntity ote = new CurveTagEntity();
ote.CurveID = sID;
ote.CurveCode = "InputCode";
ote.CurveName = "InputName";
ote.CurveDesc = "";
ote.CurveGroup = "InputGroup";
ote.CurveMonth = "1,2,3,4,5,6,7,8,9,10,11,12,";
ote.CurveIsValid = 0;
ote.CurveIndex = 100;
ote.CurveType = 0;
ote.CurveGetType = 0;
ote.CurveXRealTag = "";
ote.CurveYRealTag = "";
ote.CurveZRealTag = "";
ote.CurveXYZ = "";
ote.CurveNote = "";
ote.CurveCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.CurveModifyTime = ote.CurveCreateTime;
if (CurveTagDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
gvCurve.EditIndex = index;
BindValues();
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
}
/// <summary>
/// 数据提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnApply_Click(object sender, EventArgs e)
{
string msg = "";
if (CheckVal(out msg))
{
MessageBox.popupClientMessage(this.Page, msg, "call();");
return;
}
if (ViewState["said"].ToString() == "")
{
string said = PageControl.GetGuid();
if (Insert(said))
{
ViewState["said"] = said;
MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
//btnAddSecurity.Enabled = true;
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
}
else
{
if (Update())
{
MessageBox.popupClientMessage(this.Page, "编辑成功！", "call();");
//btnAddSecurity.Enabled = true;
}
else
{
MessageBox.popupClientMessage(this.Page, "编辑错误！", "call();");
}
}
}
protected void btnAddShift_Click(object sender, EventArgs e)
{
////添加新电厂信息
//string strjs = "<script language=javascript>window.open('KPI_SubRunShift.aspx','newwindow','width=500,height=400')</script>";
//ClientScript.RegisterStartupScript(this.GetType(), "", strjs);
int index = KPI_ShiftDal.ShiftIDCounts();
string sID = PageControl.GetGuid();
KPI_ShiftEntity ote = new KPI_ShiftEntity();
ote.ShiftID = sID;
ote.ShiftCode = KPI_ShiftDal.GetNextCode();
ote.ShiftName = "InputName";
ote.ShiftDesc = "";
ote.ShiftIsValid = "1";
ote.ShiftNote = "";
ote.ShiftCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
ote.ShiftModifyTime = ote.ShiftCreateTime;
if (KPI_ShiftDal.Insert(ote))
{
//MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
gvShift.EditIndex = index;
BindShift();
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
}
protected void btnAddWork_Click(object sender, EventArgs e)
{
//检查名称是否重复
string sName = txt_WorkName.Value.Trim();
if (KPI_WorkDal.WorkNameExists(sName, ""))
{
MessageBox.popupClientMessage(this.Page, "名称已存在，请修改倒班名称!", "call();");
return;
}
int nShifts = int.Parse(ddl_BaseShifts.SelectedValue);
int nDays = int.Parse(ddl_BaseDays.SelectedValue);
string sWorkSequence = "";
//WorkSequence
for (int j = 0; j < nDays; j++)
{
for (int i = 0; i < nShifts; i++)
{
string id = string.Format("ddl_period{0}{1}", i, j);
DropDownList ddl = (DropDownList)this.FindControl(id);
sWorkSequence += ddl.SelectedValue + "-";
}
}
string sWorkShift = "";
//WorkShift
for (int i = 0; i < nShifts; i++)
{
string id = string.Format("ddl_shift0{0}", i);
DropDownList ddl = (DropDownList)this.FindControl(id);
sWorkShift += ddl.SelectedValue + "-";
}
string keyid = PageControl.GetGuid();
//////////////////////////////////////////////////////////////////////////////
KPI_WorkEntity kwe = new KPI_WorkEntity();
kwe.WorkID = keyid;
kwe.WorkName = txt_WorkName.Value;
kwe.WorkDesc = txt_WorkDesc.Value;
kwe.WorkStartTime = txt_date.Value;
kwe.WorkEndTime = DateTime.Now.AddYears(10).ToLocalTime().ToString("yyyy-MM-dd");
kwe.WorkBaseShifts = nShifts;
kwe.WorkBaseDays = nDays;
kwe.WorkSequence = sWorkSequence;
kwe.WorkShift = sWorkShift;
kwe.WorkIsValid = int.Parse(ddl_WorkIsValid.SelectedValue);
kwe.WorkNote = txt_WorkNote.Value;
kwe.WorkCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
kwe.WorkModifyTime = kwe.WorkCreateTime;
///////////////////////////////////////////////////////////////////////////////
if (KPI_WorkDal.Insert(kwe))
{
MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
BindWork();
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
if (KPI_WorkDal.Update(kwe))
{
MessageBox.popupClientMessage(this.Page, "修改成功！", "call();");
BindWork();
}
else
{
MessageBox.popupClientMessage(this.Page, "修改错误！", "call();");
}
}
protected bool ImportFromExcelToCreateAndModify(DataSet ds)
{
try
{
System.Data.DataTable dt = ds.Tables[0];
int nAll = dt.Rows.Count;
int nCreate = 0;
int nModify = 0;
bool bExist = false;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["SelectX"].ToString().ToLower() == "x")
{
string PersonCode = dr["PersonCode"].ToString().Trim();
//判断是否存在
bExist = KPI_PersonDal.PersonCodeExists(PersonCode, "");
string keyid = PageControl.GetGuid();
if (bExist)
{
keyid = KPI_PersonDal.GetPersonID(PersonCode);
//MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
//nExist += 1;
//continue;
}
//main tag
KPI_PersonEntity mEntity = new KPI_PersonEntity();
mEntity.PersonID = keyid;
mEntity.PositionID = KPI_PositionDal.GetPositionID(dr["PositionName"].ToString().Trim());
mEntity.PersonCode = PersonCode;
mEntity.PersonName = dr["PersonName"].ToString().Trim();
mEntity.PersonDesc = dr["PersonDesc"].ToString().Trim();
mEntity.PersonIsValid = dr["PersonIsValid"].ToString().Trim();
mEntity.PersonNote = dr["PersonNote"].ToString().Trim();
if (bExist)
{
KPI_PersonDal.Update(mEntity);
nModify += 1;
}
else
{
KPI_PersonDal.Insert(mEntity);
nCreate += 1;
}
}
}
string strInfor = "标签点总数为：{0}个, 创建成功:{1}个， 修改成功: {2}个。";
strInfor = string.Format(strInfor, nAll, nCreate, nModify);
MessageBox.popupClientMessage(this.Page, strInfor, "call();");
return(true);
}
catch (Exception ee)
{
//
MessageBox.popupClientMessage(this.Page, ee.Message, "call();");
return(false);
}
}
protected bool ImportFromExcelToCreateAndModify(DataSet ds)
{
string strKPIError = "";
try
{
System.Data.DataTable dt = ds.Tables[0];
int nAll = dt.Rows.Count;
int nCreate = 0;
int nModify = 0;
int nNotValid = 0;
bool bExist = false;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["SelectX"].ToString().ToLower() == "x")
{
string ECCode = dr["ECCode"].ToString().Trim();
strKPIError = ECCode;
//判断是否存在
bExist = ECTagDal.CodeExist(ECCode, "");
string keyid = PageControl.GetGuid();
if (bExist)
{
keyid = ECTagDal.GetECIDByCode(ECCode);
//MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
//nExist += 1;
//continue;
}
else
{
//其他表存在也不能创建
if (ALLDal.CodeExist(ECCode, ""))
{
nNotValid += 1;
continue;
}
}
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = keyid;
string UnitName = dr["UnitName"].ToString().Trim();
mEntity.UnitID = KPI_UnitDal.GetUnitID(UnitName);
string SeqName = dr["SeqName"].ToString().Trim();
mEntity.SeqID = KPI_SeqDal.GetSeqID(SeqName);
string KpiName = dr["KpiName"].ToString().Trim();
mEntity.KpiID = KpiDal.GetKpiID(KpiName);
string EngunitName = dr["EngunitName"].ToString().Trim();
mEntity.EngunitID = EngunitDal.GetEngunitID(EngunitName);
string CycleName = dr["CycleName"].ToString().Trim();
mEntity.CycleID = CycleDal.GetCycleID(CycleName);
mEntity.ECCode = dr["ECCode"].ToString().Trim();
mEntity.ECName = dr["ECName"].ToString().Trim();
mEntity.ECDesc = dr["ECDesc"].ToString().Trim();
mEntity.ECIndex = int.Parse(dr["ECIndex"].ToString().Trim());
mEntity.ECWeb = dr["ECWeb"].ToString().Trim();
mEntity.ECIsValid = int.Parse(dr["ECIsValid"].ToString().Trim());
mEntity.ECIsCalc = int.Parse(dr["ECIsCalc"].ToString().Trim());
mEntity.ECIsAsses = int.Parse(dr["ECIsAsses"].ToString().Trim());
mEntity.ECIsZero = int.Parse(dr["ECIsZero"].ToString().Trim());
mEntity.ECIsDisplay = int.Parse(dr["ECIsDisplay"].ToString().Trim());
mEntity.ECIsTotal = int.Parse(dr["ECIsTotal"].ToString().Trim());
mEntity.ECDesign = dr["ECDesign"].ToString().Trim();
mEntity.ECOptimal = dr["ECOptimal"].ToString().Trim();
if (dr["ECMaxValue"].ToString().Trim() != "")
{
mEntity.ECMaxValue = decimal.Parse(dr["ECMaxValue"].ToString().Trim());
}
if (dr["ECMinValue"].ToString().Trim() != "")
{
mEntity.ECMinValue = decimal.Parse(dr["ECMinValue"].ToString().Trim());
}
mEntity.ECWeight = decimal.Parse(dr["ECWeight"].ToString().Trim());
mEntity.ECCalcClass = int.Parse(dr["ECCalcClass"].ToString().Trim());
mEntity.ECFilterExp = dr["ECFilterExp"].ToString().Trim();
mEntity.ECCalcExp = dr["ECCalcExp"].ToString().Trim();
mEntity.ECCalcDesc = dr["ECCalcDesc"].ToString().Trim();
mEntity.ECIsSnapshot = int.Parse(dr["ECIsSnapshot"].ToString().Trim());
mEntity.ECXLineType = int.Parse(dr["ECXLineType"].ToString().Trim());
mEntity.ECXLineGetType = int.Parse(dr["ECXLineGetType"].ToString().Trim());
mEntity.ECXLineXRealTag = dr["ECXLineXRealTag"].ToString().Trim();
mEntity.ECXLineYRealTag = dr["ECXLineYRealTag"].ToString().Trim();
mEntity.ECXLineZRealTag = dr["ECXLineZRealTag"].ToString().Trim();
mEntity.ECXLineXYZ = dr["ECXLineXYZ"].ToString().Trim();
mEntity.ECScoreExp = dr["ECScoreExp"].ToString().Trim();
mEntity.ECCurveGroup = dr["ECCurveGroup"].ToString().Trim();
mEntity.ECIsSort = int.Parse(dr["ECIsSort"].ToString().Trim());
mEntity.ECType = int.Parse(dr["ECType"].ToString().Trim());
mEntity.ECSort = int.Parse(dr["ECSort"].ToString().Trim());
mEntity.ECScore = dr["ECScore"].ToString().Trim();
mEntity.ECExExp = dr["ECExExp"].ToString().Trim();
mEntity.ECExScore = dr["ECExScore"].ToString().Trim();
mEntity.ECNote = dr["ECNote"].ToString().Trim();
mEntity.ECCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
mEntity.ECModifyTime = mEntity.ECCreateTime;
if (bExist)
{
ECTagDal.Update(mEntity);
nModify += 1;
}
else
{
ECTagDal.Insert(mEntity);
nCreate += 1;
}
}
}
string strInfor = "标签点总数为：{0}个, 创建成功:{1}个， 修改成功: {2}个，其他表存在Code: {3}个。";
strInfor = string.Format(strInfor, nAll, nCreate, nModify, nNotValid);
MessageBox.popupClientMessage(this.Page, strInfor, "call();");
return(true);
}
catch (Exception ee)
{
//
MessageBox.popupClientMessage(this.Page, strKPIError + ": " + ee.Message, "call();");
return(false);
}
}
protected bool ImportFromExcelToCreateAndModify(DataSet ds)
{
try
{
System.Data.DataTable dt = ds.Tables[0];
int nAll = dt.Rows.Count;
int nCreate = 0;
int nModify = 0;
int nNotValid = 0;
bool bExist = false;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["SelectX"].ToString().ToLower() == "x")
{
string RealCode = dr["RealCode"].ToString().Trim();
//判断是否存在
bExist = KPI_RealTagDal.CodeExist(RealCode, "");
string keyid = PageControl.GetGuid();
if (bExist)
{
keyid = KPI_RealTagDal.GetID(RealCode);
//MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
//nExist += 1;
//continue;
}
else
{
//其他表存在也不能创建
if (ALLDal.CodeExist(RealCode, ""))
{
nNotValid += 1;
continue;
}
}
//main tag
KPI_RealTagEntity mEntity = new KPI_RealTagEntity();
mEntity.RealID = keyid;
mEntity.UnitID = KPI_UnitDal.GetUnitID(dr["UnitName"].ToString().Trim());
mEntity.RealCode = RealCode;
mEntity.RealDesc = dr["RealDesc"].ToString().Trim();
mEntity.RealEngunit = dr["RealEngunit"].ToString().Trim();
string sv = dr["RealMaxValue"].ToString().Trim();
if (sv != "")
{
mEntity.RealMaxValue = decimal.Parse(sv);
}
sv = dr["RealMinValue"].ToString().Trim();
if (sv != "")
{
mEntity.RealMinValue = decimal.Parse(sv);
}
mEntity.RealSnapshot = dr["RealSnapshot"].ToString().Trim();
mEntity.RealSort = dr["RealSort"].ToString().Trim();
mEntity.RealDisplay = dr["RealDisplay"].ToString().Trim();
mEntity.RealXYZ = dr["RealXYZ"].ToString().Trim();
mEntity.RealNote = dr["RealNote"].ToString().Trim();
if (bExist)
{
KPI_RealTagDal.Update(mEntity);
nModify += 1;
}
else
{
KPI_RealTagDal.Insert(mEntity);
nCreate += 1;
}
}
}
string strInfor = "标签点总数为：{0}个, 创建成功:{1}个， 修改成功: {2}个，其他表存在Code: {3}个。";
strInfor = string.Format(strInfor, nAll, nCreate, nModify, nNotValid);
MessageBox.popupClientMessage(this.Page, strInfor, "call();");
return(true);
}
catch (Exception ee)
{
//
MessageBox.popupClientMessage(this.Page, ee.Message, "call();");
return(false);
}
}