protected bool ImportFromExcelToModify(DataSet ds)
{
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 PersonCode = dr["PersonCode"].ToString().Trim();
//判断是否存在
if (!KPI_PersonDal.PersonCodeExists(PersonCode, ""))
{
//MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
nNoExist += 1;
continue;
}
//main tag
string keyid = KPI_PersonDal.GetPersonID(PersonCode);
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();
KPI_PersonDal.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, ee.Message, "call();");
return(false);
}
}
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);
}
}
