private void BindSelect()
{
var bll = new FlexPlusBLL();
var dt = bll.GetRepairDormTypeList();
ddlDeviceType.DataSource = dt;
ddlDeviceType.DataValueField = "Name";
ddlDeviceType.DataTextField = "Name";
var row = dt.NewRow();
row["Name"] = "All";
dt.Rows.InsertAt(row, 0);
ddlDeviceType.DataBind();
ddlDeviceType.SelectedIndex = 0;
var lst = new List <TNameVal>();
lst.Add(new TNameVal("All", "-1"));
lst.Add(new TNameVal("等待处理", "0"));
lst.Add(new TNameVal("批准", "1"));
lst.Add(new TNameVal("拒绝", "2"));
ddlStatus.DataSource = lst;
ddlStatus.DataValueField = "Value";
ddlStatus.DataTextField = "Name";
ddlStatus.DataBind();
ddlStatus.SelectedIndex = 0;
}
private void InitData(string key)
{
var bll = new FlexPlusBLL();
var dt = bll.GetDormSuggestByID(key);
if (DataTableHelper.IsEmptyDataTable(dt))
{
txtResponse.Disabled = false;
btnSave.Visible = true;
btnSave.Enabled = true;
return;
}
var dr = dt.Rows[0];
txtEmployeeNo.Text = dr["EmployeeNo"].ToString();
txtCName.Text = dr["CName"].ToString();
txtMobileNo.Text = dr["MobileNo"].ToString();
var sDate = (dr["CreateDate"] == null) ? ""
: Convert.ToDateTime(dr["CreateDate"]).ToString("yyyy-MM-dd HH:mm");
txtCreateDate.Text = sDate;
txtSuggest.Value = dr["Suggest"].ToString();
txtResponse.Value = dr["Response"].ToString();
int nStatus = 0;
nStatus = Convert.ToInt32(dr["Status"]);
if (nStatus != 0)
{
txtResponse.Disabled = true;
btnSave.Visible = false;
btnSave.Enabled = false;
}
}
private void Bind(int iPage)
{
var bll = new FlexPlusBLL();
var pager = new Pager();
pager.CurrentPageIndex = iPage;
pager.srcOrder = " CreateDate desc";
var mItem = new TB_DormReissueKey();
var sSel = ddlKeyType.SelectedItem.Text;
if (0 != string.Compare("all", sSel, true))
{
mItem.KeyTypes = sSel;
}
mItem.Status = Convert.ToInt32(ddlStatus.SelectedValue);
var dt = bll.GetReissueKeyList(mItem, ref pager);
GridView1.DataSource = dt;
GridView1.DataBind();
this.Pager1.ItemCount = pager.TotalRecord;
this.Pager1.PageCount = pager.TotalPage;
this.Pager1.CurrentIndex = pager.CurrentPageIndex;
this.Pager1.PageSize = pager.PageSize;
}
private void BindApplys(int curPageIndex)
{
var bll = new FlexPlusBLL();
var pager = new Pager();
pager.CurrentPageIndex = curPageIndex;
pager.srcOrder = " ID desc";
var mTB_DormAreaApply = new TB_DormAreaApply();
mTB_DormAreaApply.EmployeeNo = txtWorkDayNo.Text.Trim();
mTB_DormAreaApply.CName = txtName.Text.Trim();
mTB_DormAreaApply.CardNo = txtScanCardNO.Text.Trim();
int nVal = 0;
int.TryParse(ddlRequiredType.SelectedValue, out nVal);
mTB_DormAreaApply.RequireType = nVal;
nVal = -1;
int.TryParse(ddlDormArea.SelectedValue, out nVal);
mTB_DormAreaApply.DormAreaID = nVal;
nVal = -1;
int.TryParse(ddlStatus.SelectedValue, out nVal);
mTB_DormAreaApply.Status = nVal;
var dt = bll.GetApplyDorms(mTB_DormAreaApply, ref pager);
GridView1.DataSource = dt;
GridView1.DataBind();
this.Pager1.ItemCount = pager.TotalRecord;
this.Pager1.PageCount = pager.TotalPage;
this.Pager1.CurrentIndex = pager.CurrentPageIndex;
this.Pager1.PageSize = pager.PageSize;
}
private void InitData(string sid)
{
int nID = 0;
int.TryParse(sid, out nID);
if (0 == nID)
{
return;
}
var bll = new FlexPlusBLL();
var mItem = new TB_DormRepair();
mItem.ID = nID;
Framework.Pager pager = null;
var dt = bll.GetRepairDormList(mItem, ref pager);
if (DataTableHelper.IsEmptyDataTable(dt))
{
return;
}
var dr = dt.Rows[0];
txtEmployeeNo.Text = dr["EmployeeNo"].ToString();
txtCName.Text = dr["CName"].ToString();
txtMobileNo.Text = dr["MobileNo"].ToString();
txtDormAddress.Text = dr["DormAddress"].ToString();
var sDate = (dr["CreateDate"] == null) ? ""
: Convert.ToDateTime(dr["CreateDate"]).ToString("yyyy-MM-dd HH:mm");
txtCreateDate.Text = sDate;
sDate = (dr["RepairTime"] == null) ? ""
: Convert.ToDateTime(dr["RepairTime"]).ToString("yyyy-MM-dd HH:mm");
txtRepairTime.Text = sDate;
txtDeviceType.Text = dr["DeviceType"].ToString();
txtRequireDesc.Value = dr["RequireDesc"].ToString();
var oBatchNo = dr["RefImageBatchNo"];
int nBatchNo = 0;
if (null != oBatchNo)
{
int.TryParse(oBatchNo.ToString(), out nBatchNo);
}
if (nBatchNo > 0)
{
lnkView.Enabled = nBatchNo > 0;
lnkView.CssClass = "lnkHas";
RefImageBatchNo.Value = oBatchNo.ToString();
}
else
{
lnkView.CssClass = "lnkNoHas";
RefImageBatchNo.Value = string.Empty;
lblNoHas.Visible = true;
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
//export to excel
var mItem = GetParam();
var bll = new FlexPlusBLL();
var sfn = DateTime.Now.ToString("yyMMddHHmmssms_") + "宿舍建议.xls";
string strFileName = bll.ExportDormSugget(mItem, sfn);
DownLoadFile(this.Request, this.Response, sfn, File.ReadAllBytes(strFileName), 10240000);
}
private void InitData(string batchNo)
{
var bll = new FlexPlusBLL();
var dt = bll.GetRepairDormImage(batchNo);
if (DataTableHelper.IsEmptyDataTable(dt))
{
return;
}
rp_Item.DataSource = dt;
rp_Item.DataBind();
}
private void InitData()
{
var bll = new FlexPlusBLL();
var dt = bll.GetDormNoticeByID(key);
if (DataTableHelper.IsEmptyDataTable(dt))
{
return;
}
var dr = dt.Rows[0];
var sTitle = dr["NoticeTitle"] as string;
var sContext = dr["NoticeHtml"] as string;
txtTitle.Text = sTitle;
txtContext.Value = sContext;
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(key))
{
return;
}
var bll = new FlexPlusBLL();
var sMsg = txtResponse.Value.Trim();
//var sHandlerWorkdayNo = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EmployeeNo);
var sEnName = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EName);
bll.HandleSuggest(key, sEnName, sMsg);
RunScript(this, "myscript", "saveComplete();");
}
private void Bind(int iPage)
{
var bll = new FlexPlusBLL();
var pager = new Pager();
pager.CurrentPageIndex = iPage;
pager.srcOrder = " CreateDate desc";
var dt = bll.GetDormNotice(ref pager);
GridView1.DataSource = dt;
GridView1.DataBind();
this.Pager1.ItemCount = pager.TotalRecord;
this.Pager1.PageCount = pager.TotalPage;
this.Pager1.CurrentIndex = pager.CurrentPageIndex;
this.Pager1.PageSize = pager.PageSize;
}
protected void btnSave_Click(object sender, EventArgs e)
{
var sTitle = txtTitle.Text.Trim();
var sContext = txtContext.Value.Trim();
var sCreator = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EmployeeNo);
var bll = new FlexPlusBLL();
if (string.IsNullOrEmpty(key))
{
bll.AddDormNotice(sTitle, sContext, sCreator);
}
else
{
bll.EditDormNotice(key, sTitle, sContext, sCreator);
}
RunScript("myscript", "saveComplete();");
}
private void InitData(string[] mKeys)
{
if (mKeys.Length > 1)
{
ddlDormArea.Enabled = false;
//txtReply.Disabled = true;
ddlHandle_SelectedIndexChanged(null, null);
}
else
{
//加载旧数据，限制提交
var bll = new FlexPlusBLL();
var mTB_DormAreaApply = new TB_DormAreaApply();
int nID = 0;
int.TryParse(mKeys[0], out nID);
mTB_DormAreaApply.ID = nID;
Framework.Pager pager = null;
var dt = bll.GetApplyDorms(mTB_DormAreaApply, ref pager);
if (!DataTableHelper.IsEmptyDataTable(dt))
{
var dr = dt.Rows[0];
int nStatus = 0;
nStatus = Convert.ToInt32(dr["Status"]);
if (nStatus != 0)
{
var sLastResp = dr["Response"].ToString();
txtReply.Value = sLastResp;
ddlDormArea.Enabled = false;
ddlHandle.Enabled = false;
txtReply.Disabled = true;
btnSave.Visible = false;
btnSave.Enabled = false;
}
else
{
ddlHandle_SelectedIndexChanged(null, null);
txtReply.Disabled = false;
txtReply.Focus();
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (null == mKey || 0 == mKey.Length)
{
return;
}
var bll = new FlexPlusBLL();
var sHandle = ddlHandle.SelectedValue;
var sMsg = txtReply.Value.Trim();
//var sHandlerWorkdayNo = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EmployeeNo);
var sEnName = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EName);
var kind = (0 == string.Compare("RepairDorm", mKind, true)) ? 0 : 1;
bll.HandleRequired(kind, mKey, sEnName, sHandle, sMsg);
var sCmd = string.Format("saveComplete({0});", kind);
RunScript(this, "myscript", sCmd);
}
protected void btnSave_Click(object sender, EventArgs e)
{
var mKeys = GetKeys();
if (null == mKeys || 0 == mKeys.Length)
{
return;
}
var bll = new FlexPlusBLL();
var sDormAreaID = ddlDormArea.SelectedValue;
var sHandle = ddlHandle.SelectedValue;
var sMsg = txtReply.Value.Trim();
var lst = new List <string>(mKeys);
var sHandlerWorkdayNo = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EmployeeNo);
var sEnName = (base.UserInfo == null ? base.SystemAdminInfo.Account : base.UserInfo.EName);
bll.ApplyDorm(lst, sHandlerWorkdayNo, sEnName, sDormAreaID, sHandle, sMsg);
RunScript(this, "myscript", "saveComplete();");
}
private void InitData(string sid)
{
int nID = 0;
int.TryParse(sid, out nID);
if (0 == nID)
{
return;
}
var bll = new FlexPlusBLL();
var mItem = new TB_DormReissueKey();
mItem.ID = nID;
Framework.Pager pager = null;
var dt = bll.GetReissueKeyList(mItem, ref pager);
if (DataTableHelper.IsEmptyDataTable(dt))
{
return;
}
var dr = dt.Rows[0];
txtEmployeeNo.Text = dr["EmployeeNo"].ToString();
txtCName.Text = dr["CName"].ToString();
txtMobileNo.Text = dr["MobileNo"].ToString();
txtDormAddress.Text = dr["DormAddress"].ToString();
txtKeyTypes.Text = dr["KeyTypes"].ToString();
txtMoney.Text = dr["Money"].ToString();
var sDate = (dr["CreateDate"] == null) ? ""
: Convert.ToDateTime(dr["CreateDate"]).ToString("yyyy-MM-dd HH:mm");
txtCreateDate.Text = sDate;
txtReason.Value = dr["Reason"].ToString();
txtMemo.Value = dr["Memo"].ToString();
}
private void InitData(string mKey)
{
//load old data
var bll = new FlexPlusBLL();
var kind = (0 == string.Compare("RepairDorm", mKind, true)) ? 0 : 1;
var sAppr = "1";
var sResp = string.Empty;
if (bll.IsHandledRequire(kind, mKey, out sAppr, out sResp))
{
ddlHandle.SelectedValue = sAppr;
txtReply.Value = sResp;
txtReply.Disabled = true;
ddlHandle.Enabled = false;
btnSave.Visible = false;
btnSave.Enabled = false;
}
else
{
txtReply.Disabled = false;
btnSave.Visible = true;
}
}
private void InitData(string sid)
{
int nID = 0;
int.TryParse(sid, out nID);
if (0 == nID)
{
return;
}
var bll = new FlexPlusBLL();
var mTB_DormAreaApply = new TB_DormAreaApply();
mTB_DormAreaApply.ID = nID;
Framework.Pager pager = null;
var dt = bll.GetApplyDorms(mTB_DormAreaApply, ref pager);
if (DataTableHelper.IsEmptyDataTable(dt))
{
return;
}
int nTemp = 0;
var dr = dt.Rows[0];
txtEmployeeNo.Text = dr["EmployeeNo"].ToString();
txtCName.Text = dr["CName"].ToString();
nTemp = 0;
int.TryParse(dr["Sex"].ToString(), out nTemp);
txtSex.Text = nTemp > 0 ? "男" : "女";
txtCardNo.Text = dr["CardNo"].ToString();
txtCreateDate.Text = dr["CreateDate"].ToString();
txtHandler.Text = dr["ModifyUserID"].ToString();
txtUpdateDate.Text = dr["UpdateDate"].ToString();
txtDormArea.Text = dr["DormArea"].ToString();
txtGrade.Text = dr["Grade"].ToString();
nTemp = 0;
int.TryParse(dr["HasHousingAllowance"].ToString(), out nTemp);
txtHasHousingAllowance.Text = nTemp > 0 ? "是" : "否";
txtmemo.Value = dr["memo"].ToString();
txtMobileNo.Text = dr["MobileNo"].ToString();
txtRequireReason.Value = dr["RequireReason"].ToString();
nTemp = 0;
int.TryParse(dr["RequireType"].ToString(), out nTemp);
var sTemp = string.Empty;
switch (nTemp)
{
case 2:
sTemp = "复入住";
break;
case 3:
sTemp = "调房";
break;
default:
sTemp = "新入住";
break;
}
txtRequireType.Text = sTemp;
}
public void DelDormNotice(string key)
{
var bll = new FlexPlusBLL();
bll.DelDormNotice(key);
}
public void SetDormNoticeEnable(string key, bool bEnable)
{
var bll = new FlexPlusBLL();
bll.SetDormNoticeEnable(key, bEnable);
}
