protected void btnExport_Click(object sender, EventArgs e)
{
if (this.ImportFlag.Value != "Import")
{
string LevelCondition = "";
string ManagerCondition = "";
model = PageHelper.GetModel<EmpSupportOutModel>(pnlContent.Controls, txtSupportDept, txtSupportDeptName);
string SupportDept = this.txtSupportDeptName.Text;
if (!string.IsNullOrEmpty(this.ddlLevelCode.SelectedValue.ToString()))
{
string[] temVal = ddlLevelCode.SelectedValuesToString(",").Split(',');
for (int iLoop = 0; iLoop < temVal.Length; iLoop++)
{
LevelCondition += "'" + temVal[iLoop] + "',";
}
LevelCondition = LevelCondition.Substring(0, LevelCondition.Length - 1);
}
if (!string.IsNullOrEmpty(this.ddlManagerCode.SelectedValue.ToString()))
{
string[] temVal = ddlManagerCode.SelectedValuesToString(",").Split(',');
for (int iLoop = 0; iLoop < temVal.Length; iLoop++)
{
ManagerCondition += "'" + temVal[iLoop] + "',";
}
ManagerCondition = ManagerCondition.Substring(0, ManagerCondition.Length - 1);
}
string sql = base.SqlDep;
DataTable newdt = empSupportOutBll.GetEmpSupportOutForExport(model, sql, SupportDept, LevelCondition, ManagerCondition);
if (newdt.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodataexport", "alert('" + Message.NoDataExport + "');", true);
}
else
{
List<EmpSupportOutModel> list = empSupportOutBll.GetList(newdt);
string[] header = { ControlText.gvSupportOrder, ControlText.gvSupportDeptName, ControlText.gvSubDepName, ControlText.gvWorkNo, ControlText.gvHeadLocalName, ControlText.gvEmpJoinDate, ControlText.gvSex, ControlText.gvLevel, ControlText.gvManager, ControlText.gvHeaderDataValue, ControlText.gvEmpStartDate, ControlText.gvPrepEndDate, ControlText.gvRealEndDate, ControlText.gvCardNo, ControlText.gvIsKaoQin, ControlText.gvRemark, ControlText.gvStateName };
string[] properties = { "SupportOrder", "SupportDeptName", "DepName", "WorkNo", "LocalName", "JoinDate", "SexName", "LevelName", "ManagerName", "OverTimeType", "StartDate", "PrepEndDate", "EndDate", "CardNo", "IsKaoQin", "Remark", "StateName" };
string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls";
NPOIHelper.ExportExcel(list, header, properties, 5000, filePath);
PageHelper.ReturnHTTPStream(filePath, true);
}
}
else
{
if (dt_global.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodataexport", "alert('" + Message.NoDataExport + "');", true);
}
else
{
List<EmpSupportOutModel> list = empSupportOutBll.GetList(dt_global);
string[] header = { ControlText.gvCostCode, ControlText.gvSupportDeptName, ControlText.gvWorkNo, ControlText.gvHeadLocalName, ControlText.gvSex, ControlText.gvLevel, ControlText.gvManager, ControlText.gvHeaderDataValue, ControlText.gvEmpStartDate, ControlText.gvPrepEndDate, ControlText.gvRealEndDate, ControlText.gvCardNo, ControlText.gvRemark, ControlText.gvIsKaoQin, ControlText.gvEmpJoinDate };
string[] properties = { "CostCode", "SupportDeptName", "DepName", "WorkNo", "LocalName", "SexName", "LevelName", "ManagerName", "OverTimeType", "StartDate", "PrepEndDate", "EndDate", "CardNo", "Remark", "IsKaoQin", "JoinDate" };
string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls";
NPOIHelper.ExportExcel(list, header, properties, 5000, filePath);
PageHelper.ReturnHTTPStream(filePath, true);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string alert = "";
model = PageHelper.GetModel<EmpSupportOutModel>(pnlContent.Controls);
string WorkNo = model.WorkNo;
model.SupportOrder = this.HiddenSeqNo.Value;
if (this.ProcessFlag.Value == "Add")
{
logmodel.ProcessFlag = "insert";
if (employeeBll.GetEmp(WorkNo).Rows.Count > 0 || empSupportOutBll.GetEmpSupportOut(WorkNo).Rows.Count > 0)
{
base.Response.Write("<script type='text/javascript'>alert(\"" + Message.DuplicateState + "\");</script>");
return;
}
model.SupportOrder = empSupportOutBll.GetEmpsupportOrder(WorkNo).Rows[0][0].ToString();
bool flag = empSupportOutBll.AddEmpSupportOut(model, logmodel);
if (flag == true)
{
alert = "alert('" + Message.AddSuccess + "')";
this.txtWorkNo.Text = "";
this.txtLocalName.Text = "";
this.ddlSex.SelectedValue = "";
this.txtSupportDept.Text = "";
this.txtSupportDeptName.Text = "";
this.txtDepName.Text = "";
this.txtJoinDate.Text = "";
this.txtStartDate.Text = "";
this.txtPrepEndDate.Text = "";
this.txtEndDate.Text = "";
this.txtNotes.Text = "";
this.ddlLevelCode.SelectedValue = "";
this.ddlManagerCode.SelectedValue = "";
this.ddlOverTimeType.SelectedValue = "";
this.ddlIsKaoQin.SelectedValue = "";
this.txtRemark.Text = "";
this.txtCardNo.Text = "";
}
else
{
alert = "alert('" + Message.AddFailed + "')";
}
}
if (this.ProcessFlag.Value == "Modify")
{
logmodel.ProcessFlag = "update";
string tmpSupportOrder = this.HiddenSeqNo.Value.Trim();
if (empSupportOutBll.GetEmpSupportByWorkNoAndOrder(WorkNo, tmpSupportOrder).Rows.Count > 0)
{
base.Response.Write("<script type='text/javascript'>alert(\"" + Message.DuplicateState + "\");</script>");
return;
}
bool flag = empSupportOutBll.UpdateEmpSupportOut(model, logmodel);
if (flag == true)
{
base.Response.Write("<script type='text/javascript'>alert('" + Message.UpdateSuccess + "');window.parent.document.all.btnQuery.click();</script>");
}
else
{
alert = "alert('" + Message.UpdateFailed + "')";
}
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "save", alert, true);
}
private void DataUIBind()
{
int totalCount;
string LevelCondition = "";
string ManagerCondition = "";
model = PageHelper.GetModel<EmpSupportOutModel>(pnlContent.Controls,txtSupportDept,txtSupportDeptName);
string SupportDept = this.txtSupportDeptName.Text;
if (!string.IsNullOrEmpty(this.ddlLevelCode.SelectedValue.ToString()))
{
string[] temVal = ddlLevelCode.SelectedValuesToString(",").Split(',');
for (int iLoop = 0; iLoop < temVal.Length; iLoop++)
{
LevelCondition += "'" + temVal[iLoop] + "',";
}
LevelCondition = LevelCondition.Substring(0, LevelCondition.Length - 1);
}
if (!string.IsNullOrEmpty(this.ddlManagerCode.SelectedValue.ToString()))
{
string[] temVal = ddlManagerCode.SelectedValuesToString(",").Split(',');
for (int iLoop = 0; iLoop < temVal.Length; iLoop++)
{
ManagerCondition += "'" + temVal[iLoop] + "',";
}
ManagerCondition = ManagerCondition.Substring(0, ManagerCondition.Length - 1);
}
string sql = base.SqlDep;
DataTable dt = empSupportOutBll.GetEmpSupportOutPageInfo(model,sql, SupportDept, LevelCondition, ManagerCondition, pager.CurrentPageIndex, pager.PageSize, out totalCount);
pager.RecordCount = totalCount;
this.UltraWebGrid.DataSource = dt.DefaultView;
this.UltraWebGrid.DataBind();
pager.TextAfterPageIndexBox = "/" + pager.PageCount.ToString();
}
