/// <summary>
/// 提交退出申请
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
string reason = txtReason.Text.Trim();
if (string.IsNullOrEmpty(reason))
{
Jscript.ShowMsg("请输入退出理由!", this);
return;
}
E_ItemApply data = new E_ItemApply();
data.ItemID = itemid;
data.UserID = UserID;
data.ApplyType = EnumApplyType.申请退出;
data.Reason = reason;
bool flag = new T_ItemApply().Add(data);
if (flag)
{
Jscript.AlertAndRedirect(this, "申请成功", "itemlist.aspx");
}
else
{
Jscript.ShowMsg("申请失败", this);
}
}
/// <summary>
/// 查看申请列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-05-09</remarks>
public DataTable GetList(E_ItemApply data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@ItemID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@Type", SqlDbType.TinyInt),
new SqlParameter("@StartDate", SqlDbType.SmallDateTime),
new SqlParameter("@EndDate", SqlDbType.SmallDateTime),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@TotalCount", SqlDbType.Int)
};
parms[0].Value = data.ItemID;
parms[1].Value = data.UserID;
parms[2].Value = (int)data.Status;
parms[3].Value = (int)data.ApplyType;
parms[4].Value = data.Page.StartDate;
parms[5].Value = data.Page.EndDate;
parms[6].Value = data.Page.PageIndex;
parms[7].Value = data.Page.PageSize;
parms[8].Direction = ParameterDirection.Output;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_ItemApply_SelectList", parms);
data.Page.TotalCount = parms[8].Value == DBNull.Value ? 0 : Convert.ToInt32(parms[8].Value);
return(dt);
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
EnumUtil.BindList <EnumApply>(rbStatus);
int status = Requests.GetQueryInt("status", -1);
rbStatus.SelectedValue = status.ToString();
E_ItemApply data = new E_ItemApply();
data.SetStatus = status;
data.ApplyType = EnumApplyType.申请加入;
data.UserID = UserID;
data.Page = new MLMGC.DataEntity.E_Page();
data.Page.PageIndex = pageIndex;
data.Page.PageSize = pageSize;
rpList.DataSource = new T_ItemApply().GetList(data);
rpList.DataBind();
//设置分页样式
pageList1.PageSize = pageSize;
pageList1.CurrentPageIndex = pageIndex;
pageList1.RecordCount = data.Page.TotalCount;
pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount);
pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " ";
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
/*
* EnumUtil.BindList<EnumApply>(rbStatus);
*
* int status = Requests.GetQueryInt("status", -1);
* rbStatus.SelectedValue = status.ToString();
*/
//根据EnterpriseID获取ItemID
E_Item item = new T_Item().GetModel(new E_Item()
{
EnterpriseID = EnterpriceID
});
if (item == null)
{
Jscript.ShowMsg("未找到项目", this);
return;
}
string start = Requests.GetQueryString("start");
string end = Requests.GetQueryString("end");
E_ItemApply data = new E_ItemApply();
data.ApplyType = EnumApplyType.申请退出;
data.Status = EnumApply.全部;
data.ItemID = item.ItemID;
data.Page = new MLMGC.DataEntity.E_Page();
if (!string.IsNullOrEmpty(start))
{
data.Page.StartDate = Convert.ToDateTime(start);
txtStartDate.Text = Convert.ToDateTime(start).ToString("yyyy-MM-dd");
}
if (!string.IsNullOrEmpty(end))
{
data.Page.EndDate = Convert.ToDateTime(end);
txtEndDate.Text = Convert.ToDateTime(end).ToString("yyyy-MM-dd");
}
data.Page.PageIndex = pageIndex;
data.Page.PageSize = pageSize;
rpList.DataSource = new T_ItemApply().GetList(data);
rpList.DataBind();
//设置分页样式
pageList1.PageSize = pageSize;
pageList1.CurrentPageIndex = pageIndex;
pageList1.RecordCount = data.Page.TotalCount;
pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount);
pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " ";
}
/// <summary>
/// 判断是否已经过申请该项目
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 20012-05-10</remarks>
public bool Exists(E_ItemApply data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@ItemID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@Type", SqlDbType.TinyInt)
};
parms[0].Value = data.ItemID;
parms[1].Value = data.UserID;
parms[2].Value = (int)data.ApplyType;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcEP_B_ItemApply_Exists", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 总监申核个人申请
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-05-09</remarks>
public int Update(E_ItemApply data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@ApplyID", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.TinyInt),
new SqlParameter("@Type", SqlDbType.TinyInt)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.ApplyID;
parms[2].Value = (int)data.Status;
parms[3].Value = (int)data.ApplyType;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcEP_B_ItemApply_Update", parms, out ReturnValue);
return(ReturnValue);
}
/// <summary>
/// 企业总监申述个人用户项目申请
/// </summary>
private void UpdateStatus()
{
int aid, status, type;
if (!int.TryParse(nv["aid"], out aid) || !int.TryParse(nv["status"], out status) || !int.TryParse(nv["type"], out type))
{
HttpContext.Current.Response.Write("0");
return;
}
E_ItemApply data = new E_ItemApply();
data.EnterpriseID = bp.EnterpriceID;
data.ApplyType = type == 1 ? EnumApplyType.申请加入 : EnumApplyType.申请退出;
data.ApplyID = aid;
data.SetStatus = status;
int result = new T_ItemApply().Update(data);
HttpContext.Current.Response.Write(result.ToString());
}
/// <summary>
/// 添加个人申请（加入或退出）
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-05-09</remarks>
public bool Add(E_ItemApply data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@ItemID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.TinyInt),
new SqlParameter("@Type", SqlDbType.TinyInt),
new SqlParameter("@Reason", SqlDbType.VarChar, 1024),
};
parms[0].Value = data.ItemID;
parms[1].Value = data.UserID;
parms[2].Value = (int)EnumApply.未查看;
parms[3].Value = (int)data.ApplyType;
parms[4].Value = data.Reason;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcEP_B_ItemApply_Insert", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 申请该项目
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnApply_Click(object sender, EventArgs e)
{
E_ItemApply data = new E_ItemApply();
data.ItemID = iid;
data.ApplyType = EnumApplyType.申请加入;
data.UserID = UserID;
data.Reason = "";
bool flag = new T_ItemApply().Add(data);
if (flag)
{
Jscript.ShowMsg("申请成功", this);
databind();
}
else
{
Jscript.ShowMsg("留言失败！", this);
}
}
/// <summary>
/// 判断是否已经过申请该项目
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 20012-05-10</remarks>
public bool Exists(E_ItemApply data)
{
return(dal.Exists(data));
}
/// <summary>
/// 查看申请列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-05-09</remarks>
public DataTable GetList(E_ItemApply data)
{
return(dal.GetList(data));
}
/// <summary>
/// 总监申述个人申请
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-05-09</remarks>
public int Update(E_ItemApply data)
{
return(dal.Update(data));
}
/// <summary>
/// 添加个人申请
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-05-09</remarks>
public bool Add(E_ItemApply data)
{
return(dal.Add(data));
}
