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 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 PersonCode = dr["PersonCode"].ToString().Trim();
//判断是否存在
if (!KPI_PersonDal.PersonCodeExists(PersonCode, ""))
{
//MessageBox.popupClientMessage(this.Page, " 该机组的输出标签已存在！", "call();");
nEmpty += 1;
continue;
}
else
{
//main tag
//string RealID = KPI_PersonDal.GetRealID(PersonCode);
KPI_PersonEntity mEntity = new KPI_PersonEntity();
mEntity.PersonID = KPI_PersonDal.GetPersonID(PersonCode);
KPI_PersonDal.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);
}
}
/// <summary>
/// 从界面获取对象
/// </summary>
/// <returns></returns>
private KPI_PersonEntity GetPersonUI()
{
KPI_PersonEntity Result = new KPI_PersonEntity();
Result.PersonID = PersonID;
Result.PositionID = drpPositions.SelectedValue;
Result.PersonCode = txtPersonCode.Text;
Result.PersonName = txtPersonName.Text;
Result.PersonDesc = txtPersonDesc.Text;
Result.PersonIsValid = chkPersonIsValid.Checked?"1":"0";
Result.PersonNote = txtPersonNote.Text;
Result.UnitID = drpUnits.SelectedValue;
Result.Shift = drpShifts.SelectedValue;
Result.SpecialField = drpSpecialFields.SelectedValue;
return(Result);
}
protected void btnSavePerson_Click(object sender, EventArgs e)
{
KPI_PersonEntity Result = GetPersonUI();
using (KPI_PersonDal DataAccess = new KPI_PersonDal()) {
int Succeed = DataAccess.SavePerson(Result);
if (Succeed > 0)
{
ShowMessage("数据保存成功!");
}
if (Succeed < 0)
{
ShowMessage("数据保存失败!");
}
}
DataBind();
SetUIState("Default");
}
/// <summary>
/// 填充界面
/// </summary>
private void SetPersonUI()
{
using (KPI_PersonDal DataAccess = new KPI_PersonDal()) {
KPI_PersonEntity Result = DataAccess.GetKPI_Person(PersonID);
if (Result == null)
{
return;
}
drpPositions.SelectedValue = Result.PositionID;
txtPersonCode.Text = Result.PersonCode;
txtPersonName.Text = Result.PersonName;
txtPersonDesc.Text = Result.PersonDesc;
chkPersonIsValid.Checked = Result.PersonIsValid == "1";
txtPersonNote.Text = Result.PersonNote;
drpUnits.SelectedValue = Result.UnitID;
drpShifts.SelectedValue = Result.Shift;
drpSpecialFields.SelectedValue = Result.SpecialField;
}
}
