public void KPI_SubWeb_Add(HttpContext context)
{
//KeyID,WebCode,ECCode,ECName,KeyEngunit,KeyCalcType,KeyIndex
string KeyID = Guid.NewGuid().ToString();
string WebCode = context.Request["WebCode"];
string ECCode = context.Request["ECCode"];
string ECName = context.Request["ECName"];
string KeyEngunit = context.Request["KeyEngunit"];
string KeyCalcType = context.Request["KeyCalcType"];
string KeyIndex = context.Request["KeyIndex"];
int iKeyIndex = 0;
if (!int.TryParse(KeyIndex, out iKeyIndex))
{
context.Response.Write("{\"status\":\"序号数字不合法！\"}");
return;
}
if (KPI_WebKeyDal.KeyExists(ECCode, WebCode))
{
context.Response.Write("{\"status\":\"该指标已存在！\"}");
return;
}
KPI_WebKeyEntity kwk = new KPI_WebKeyEntity();
//
kwk.KeyID = KeyID;
kwk.ECID = ECTagDal.GetECIDByCode(ECCode);
kwk.ECCode = ECCode;
kwk.ECName = ECName;
kwk.WebCode = WebCode;
kwk.KeyEngunit = KeyEngunit;
kwk.KeyCalcType = int.Parse(KeyCalcType);
kwk.KeyIndex = iKeyIndex;
kwk.KeyIsValid = 1;
kwk.KeyNote = "";
kwk.KeyCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
kwk.KeyModifyTime = kwk.KeyCreateTime;
if (KPI_WebKeyDal.Insert(kwk))
{
context.Response.Write("{\"status\":\"ok\"}");
}
else
{
context.Response.Write("{\"status\":\"添加失败！\"}");
return;
}
}
protected bool ImportFromExcelToDelete(DataSet ds)
{
try
{
System.Data.DataTable dt = ds.Tables[0];
int nAll = dt.Rows.Count;
int nDelete = 0;
int nEmpty = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["SelectX"].ToString().ToLower() == "x")
{
string ECCode = dr["ECCode"].ToString().Trim();
//判断是否存在
if (!ECTagDal.CodeExist(ECCode, ""))
{
//MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
nEmpty += 1;
continue;
}
else
{
//main tag
ECTagEntity mEntity = new ECTagEntity();
mEntity.ECID = ECTagDal.GetECIDByCode(ECCode);
ECTagDal.Delete(mEntity);
nDelete += 1;
}
}
}
string strInfor = "标签点总数为：{0}个, 删除成功:{1}个，空标签点: {2}个。";
strInfor = string.Format(strInfor, nAll, nDelete, nEmpty);
MessageBox.popupClientMessage(this.Page, strInfor, "call();");
return(true);
}
catch (Exception ee)
{
//
MessageBox.popupClientMessage(this.Page, ee.Message, "call();");
return(false);
}
}
public void KPI_Average_Add(HttpContext context)
{
//KeyID,ECCode,ECName,KeyEngunit,KeyTarget1,KeyTarget2,KeyDesign,KeyDiffMoney,KeyOptMoney,KeyIndex
string KeyID = Guid.NewGuid().ToString();
string ECCode = context.Request["ECCode"];
string ECName = context.Request["ECName"];
string KeyEngunit = context.Request["KeyEngunit"];
string KeyTarget1 = context.Request["KeyTarget1"];
string KeyTarget2 = context.Request["KeyTarget2"];
string KeyDesign = context.Request["KeyDesign"];
string KeyDiffMoney = context.Request["KeyDiffMoney"];
string KeyOptMoney = context.Request["KeyOptMoney"];
string KeyIndex = context.Request["KeyIndex"];
double dKeyDiffMoney = 0;
double dKeyOptMoney = 0;
int iKeyIndex = 0;
if (!int.TryParse(KeyIndex, out iKeyIndex))
{
context.Response.Write("{\"status\":\"序号数字不合法！\"}");
return;
}
if (!double.TryParse(KeyDiffMoney, out dKeyDiffMoney))
{
context.Response.Write("{\"status\":\"偏差奖金数字不合法！\"}");
return;
}
if (!double.TryParse(KeyOptMoney, out dKeyOptMoney))
{
context.Response.Write("{\"status\":\"最优奖金数字不合法！\"}");
return;
}
if (AVGDal.KeyExists(ECCode))
{
context.Response.Write("{\"status\":\"该指标已存在！\"}");
return;
}
AVGEntity kwk = new AVGEntity();
//
kwk.KeyID = Guid.NewGuid().ToString();
kwk.ECID = ECTagDal.GetECIDByCode(ECCode);
kwk.ECCode = ECCode;
kwk.ECName = ECName;
kwk.KeyEngunit = KeyEngunit;
kwk.KeyTarget1 = KeyTarget1 == "NOTAG" ? "" : KeyTarget1;
kwk.KeyTarget2 = KeyTarget2 == "NOTAG" ? "" : KeyTarget2;
kwk.KeyDesign = KeyDesign;
kwk.KeyDIffMoney = dKeyDiffMoney;
kwk.KeyOptMoney = dKeyOptMoney;
kwk.KeyIndex = iKeyIndex;
if (AVGDal.Insert(kwk))
{
context.Response.Write("{\"status\":\"ok\"}");
}
else
{
context.Response.Write("{\"status\":\"添加失败！\"}");
return;
}
}
protected bool ImportFromExcelToModify(DataSet ds)
{
string strError = "";
try
{
System.Data.DataTable dt = ds.Tables[0];
int nAll = dt.Rows.Count;
int nModify = 0;
int nNoExist = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["SelectX"].ToString().ToLower() == "x")
{
string ECCode = dr["ECCode"].ToString().Trim();
strError = ECCode;
//判断是否存在
if (!ECTagDal.CodeExist(ECCode, ""))
{
//MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
nNoExist += 1;
continue;
}
//main tag
string keyid = ECTagDal.GetECIDByCode(ECCode);
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;
ECTagDal.Update(mEntity);
nModify += 1;
}
}
string strInfor = "标签点总数为：{0}个, 修改成功:{1}个，不存在标签点: {2}个。";
strInfor = string.Format(strInfor, nAll, nModify, nNoExist);
MessageBox.popupClientMessage(this.Page, strInfor, "call();");
return(true);
}
catch (Exception ee)
{
//
MessageBox.popupClientMessage(this.Page, strError + ": " + ee.Message, "call();");
return(false);
}
}
