private void ClientInitial()
{
List <KPI_UnitEntity> UnitList = KPI_UnitDal.GetAllEntity();
//drpUnits.Items.Add(new ListItem("全厂", "00"));
drpSUnits.Items.Add(new ListItem("【所有机组】", ""));
foreach (KPI_UnitEntity Unit in UnitList)
{
drpSUnits.Items.Add(new ListItem(Unit.UnitName, Unit.UnitID));
drpUnits.Items.Add(new ListItem(Unit.UnitName, Unit.UnitID));
}
DataTable Shifts = KPI_ShiftDal.GetShifts();
drpSShifts.Items.Add(new ListItem("【所有值次】", ""));
foreach (DataRow dr in Shifts.Rows)
{
drpShifts.Items.Add(new ListItem(dr["Name"] + "值", dr["Name"] + ""));
drpSShifts.Items.Add(new ListItem(dr["Name"] + "值", dr["Name"] + ""));
}
Shifts.Dispose();
DataTable PositionTable = KPI_PositionDal.GetDataTable();
foreach (DataRow dr in PositionTable.Rows)
{
drpPositions.Items.Add(new ListItem(dr["PositionName"] + "", dr["PositionID"] + ""));
}
PositionTable.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//指标信息
if (Request.QueryString["webcode"] != null)
{
WebCode = Request.QueryString["webcode"].ToString();
lblInfor.Text = "报表名称: " + KPI_WebDal.GetWebDesc(WebCode);
}
else
{
WebCode = "";
}
////机组信息
DataTable dt = KPI_ShiftDal.GetShifts();
ddlShift.Items.Add(new ListItem("全部", "ALL"));
foreach (DataRow dr in dt.Rows)
{
ddlShift.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
//
txt_ST.Value = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
txt_ET.Value = DateTime.Now.ToString("yyyy-MM-dd");
BindValue();
}
}
void BindShift()
{
//值信息
DataTable dtShift = KPI_ShiftDal.GetSearchList("");
gvShift.DataSource = dtShift;
gvShift.DataBind();
}
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);
}
}
protected void gvShift_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string sID = ((HtmlInputHidden)(gvShift.Rows[e.RowIndex].Cells[0].FindControl("shiftid"))).Value.ToString().Trim();
string sName = ((TextBox)(gvShift.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
string sDesc = ((TextBox)(gvShift.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();
string sValid = ((DropDownList)(gvShift.Rows[e.RowIndex].Cells[4].FindControl("ddlValid"))).SelectedValue;
string sNote = ((TextBox)(gvShift.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim();
if (sName == "")
{
MessageBox.popupClientMessage(this.Page, "名称不能为空！", "call();");
return;
}
//名称是否重复
if (KPI_ShiftDal.ShiftNameExists(sName, sID))
{
MessageBox.popupClientMessage(this.Page, "已存在相同的名称!");
return;
}
//更新
KPI_ShiftEntity ote = new KPI_ShiftEntity();
ote.ShiftID = sID;
//
ote.ShiftName = sName;
ote.ShiftDesc = sDesc;
ote.ShiftIsValid = sValid;
ote.ShiftNote = sNote;
ote.ShiftModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
if (KPI_ShiftDal.Update(ote))
{
MessageBox.popupClientMessage(this.Page, "编辑成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "编辑错误！", "call();");
}
gvShift.EditIndex = -1;
BindShift();
}
protected void gvShift_RowCommand(object sender, GridViewCommandEventArgs e)
{
string keyid = e.CommandArgument.ToString();
if (e.CommandName == "dataDelete")
{
if (KPI_ShiftDal.DeleteShift(keyid))
{
MessageBox.popupClientMessage(this.Page, "删除成功！", "call();");
BindShift();
}
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();");
}
}
