protected void btnExport_Click(object sender, EventArgs e)
{
if (this.ImportFlag.Value != "Import")
{
string LevelCondition = "";
string ManagerCondition = "";
model = PageHelper.GetModel<EmpSupportInModel>(pnlContent.Controls, txtDepCode, txtDepName);
string depname = this.txtDepName.Text;
if (!string.IsNullOrEmpty(this.ddlLevelName.SelectedValue.ToString()))
{
string[] temVal = ddlLevelName.SelectedValuesToString(",").Split(',');
for (int iLoop = 0; iLoop < temVal.Length; iLoop++)
{
LevelCondition += "'" + temVal[iLoop] + "',";
}
LevelCondition = LevelCondition.Substring(0, LevelCondition.Length - 1);
}
if (!string.IsNullOrEmpty(this.ddlManagerName.SelectedValue.ToString()))
{
string[] temVal = ddlManagerName.SelectedValuesToString(",").Split(',');
for (int iLoop = 0; iLoop < temVal.Length; iLoop++)
{
ManagerCondition += "'" + temVal[iLoop] + "',";
}
ManagerCondition = ManagerCondition.Substring(0, ManagerCondition.Length - 1);
}
string StartDateFrom = this.txtStartDate1.Text.Trim();
string StartDateTo = this.txtStartDate2.Text.Trim();
string PrepEndDateFrom = this.txtPrepEndDate1.Text.Trim();
string PrepEndDateTo = this.txtPrepEndDate2.Text.Trim();
DataTable dt = empSupportInBll.GetEmpSupportInForExport(model, depname, LevelCondition, ManagerCondition, StartDateFrom, StartDateTo, PrepEndDateFrom, PrepEndDateTo);
if (dt.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodataexport", "alert('" + Message.NoDataExport + "');", true);
}
else
{
List<EmpSupportInModel> list = empSupportInBll.GetList(dt);
string[] header = { ControlText.gvWorkNo, ControlText.gvHeadLocalName, ControlText.gvSex, ControlText.gvSupportOrder, ControlText.gvSupportDeptName, ControlText.gvEmpStartDate, ControlText.gvPrepEndDate, ControlText.gvRealEndDate, ControlText.gvStateName, ControlText.gvRemark };
string[] properties = { "WorkNo", "LocalName", "SexName", "SupportOrder", "SupportDept", "StartDate", "PrepEndDate", "EndDate", "StateName", "Remark" };
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<EmpSupportInModel> list = empSupportInBll.GetList(dt_global);
string[] header = { ControlText.gvWorkNo, ControlText.gvCostCode, ControlText.gvSupportDeptName, ControlText.gvEmpStartDate, ControlText.gvPrepEndDate, ControlText.gvRealEndDate, ControlText.gvRemark };
string[] properties = { "WorkNo", "CostCode", "SupportDeptName", "StartDate", "PrepEndDate", "EndDate", "Remark" };
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<EmpSupportInModel>(pnlContent.Controls);
string WorkNo = model.WorkNo;
if (empSupportInBll.GetEmpStatus(WorkNo).Rows[0][0].ToString().Equals("2"))
{
base.Response.Write("<script type='text/javascript'>alert(\"" + Message.WorkNoIsWrong + "\");</script>");
return;
}
if (this.ProcessFlag.Value == "Add")
{
logmodel.ProcessFlag = "insert";
if (empSupportInBll.GetEmpSupportIn(WorkNo).Rows.Count>0)
{
base.Response.Write("<script type='text/javascript'>alert(\"" + Message.MoreThanOneSupport + "\");</script>");
return;
}
model.SupportOrder = empSupportInBll.GetEmpsupportOrder(WorkNo).Rows[0][0].ToString();
bool flag = empSupportInBll.AddEmpSupportIn(model,logmodel);
if (flag == true)
{
alert = "alert('" + Message.AddSuccess + "')";
this.ddlState.SelectedIndex = 0;
this.txtWorkNo.Text = "";
this.txtSupportDept.Text = "";
this.txtSupportDeptName.Text = "";
this.txtStartDate.Text = "";
this.txtPrepEndDate.Text = "";
this.txtEndDate.Text = "";
this.txtRemark.Text = "";
this.HiddenSupportOrder.Value = "";
}
else
{
alert = "alert('" + Message.AddFailed + "')";
this.TextBoxsReset("Add", false);
}
}
if (this.ProcessFlag.Value == "Modify")
{
logmodel.ProcessFlag = "update";
string tmpSupportOrder = this.HiddenSupportOrder.Value.Trim();
if (empSupportInBll.GetEmpSupportByWorkNoAndOrder(WorkNo, tmpSupportOrder).Rows.Count > 0)
{
base.Response.Write("<script type='text/javascript'>alert(\"" + Message.DuplicateState + "\");</script>");
return;
}
model.SupportOrder = tmpSupportOrder;
bool flag = empSupportInBll.UpdateEmpSupportIn(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<EmpSupportInModel>(pnlContent.Controls,txtDepCode,txtDepName);
string depname = this.txtDepName.Text;
if (!string.IsNullOrEmpty(this.ddlLevelName.SelectedValue.ToString()))
{
string[] temVal = ddlLevelName.SelectedValuesToString(",").Split(',');
for (int iLoop = 0; iLoop < temVal.Length; iLoop++)
{
LevelCondition += "'" + temVal[iLoop] + "',";
}
LevelCondition = LevelCondition.Substring(0, LevelCondition.Length - 1);
}
if (!string.IsNullOrEmpty(this.ddlManagerName.SelectedValue.ToString()))
{
string[] temVal = ddlManagerName.SelectedValuesToString(",").Split(',');
for (int iLoop = 0; iLoop < temVal.Length; iLoop++)
{
ManagerCondition += "'" + temVal[iLoop] + "',";
}
ManagerCondition = ManagerCondition.Substring(0, ManagerCondition.Length - 1);
}
string StartDateFrom = this.txtStartDate1.Text.Trim();
string StartDateTo = this.txtStartDate2.Text.Trim();
string PrepEndDateFrom = this.txtPrepEndDate1.Text.Trim();
string PrepEndDateTo = this.txtPrepEndDate2.Text.Trim();
DataTable dt = empSupportInBll.GetEmpSupportInPageInfo(model,depname, LevelCondition, ManagerCondition, StartDateFrom, StartDateTo, PrepEndDateFrom, PrepEndDateTo, pager.CurrentPageIndex, pager.PageSize, out totalCount);
pager.RecordCount = totalCount;
this.UltraWebGridSupportIn.DataSource = dt.DefaultView;
this.UltraWebGridSupportIn.DataBind();
pager.TextAfterPageIndexBox = "/" + pager.PageCount.ToString();
}
