public void Asp(GridView gv, AspNetPager pager, UserHolidayDetailEntity mo)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@DetailID", SqlDbType.Int);
param[0].Value = mo.DetailID;
param[1] = new SqlParameter("@UserID", SqlDbType.VarChar, 50);
param[1].Value = mo.UserID;
string comstr = "with IntegralInfo as\r\n (\r\n select ui.DetailID as DetailID,ui.UserID as UserID,ui.IntegralChange as IntegralChange,ui.ChangeDes as ChangeDes,us.UserName as UserName,Row_Number() over(order by DetailID) as row_number from UserHolidayDetail ui,Users us where ui.UserID=us.UserID";
string comstr2 = "select count(*) from UserHolidayDetail ui,Users us where ui.UserID=us.UserID";
if (mo.DetailID != 0)
{
comstr += " and ui.DetailID=@DetailID";
comstr2 += " and ui.DetailID=@DetailID";
}
if (mo.UserID != null && mo.UserID != "")
{
comstr += " and ui.UserID=@UserID";
comstr2 += " and ui.UserID=@UserID";
}
comstr += " ) select * from IntegralInfo where row_number>{0} and row_number<{1}";
comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
DataBase db = new DataBase();
pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param));
gv.DataSource = db.GetDataTable(comstr, param);
gv.DataBind();
}
public bool Delete(UserHolidayDetailEntity mo)
{
DataBase db = new DataBase();
string sql = "delete from UserHolidayDetail where DetailID=@DetailID";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@DetailID", SqlDbType.Int)
};
param[0].Value = mo.DetailID;
return(db.ExecuteSql(sql, param) > 0);
}
public bool Add(UserHolidayDetailEntity mo)
{
DataBase db = new DataBase();
string sql = "insert into UserHolidayDetail(UserID,IntegralChange,ChangeDes) values(@UserID,@IntegralChange,@ChangeDes)";
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@UserID", SqlDbType.VarChar, 50);
param[0].Value = mo.UserID;
param[1] = new SqlParameter("@IntegralChange", SqlDbType.Int);
param[1].Value = mo.IntegralChange;
param[2] = new SqlParameter("@ChangeDes", SqlDbType.VarChar, 1000);
param[2].Value = mo.ChangeDes;
return(db.ExecuteSql(sql, param) > 0);
}
public bool Update(UserHolidayDetailEntity mo)
{
DataBase db = new DataBase();
string sql = "update UserHolidayDetail set UserID=@UserID,IntegralChange=@IntegralChange,ChangeDes=@ChangeDes where DetailID=@DetailID";
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@UserID", SqlDbType.VarChar, 50);
param[0].Value = mo.UserID;
param[1] = new SqlParameter("@IntegralChange", SqlDbType.Int);
param[1].Value = mo.IntegralChange;
param[2] = new SqlParameter("@ChangeDes", SqlDbType.VarChar, 1000);
param[2].Value = mo.ChangeDes;
param[3] = new SqlParameter("@DetailID", SqlDbType.Int);
param[3].Value = mo.DetailID;
return(db.ExecuteSql(sql, param) > 0);
}
private void BindView2()
{
UserHolidayDetailEntity UserHolidayDetailEntity = new UserHolidayDetailEntity();
UserHolidayDetailBll UserHolidayDetailBll = new UserHolidayDetailBll();
UserHolidayDetailEntity.DetailID = 0;
UserHolidayDetailEntity.UserID = this.ViewState["id"].ToString();
UserHolidayDetailBll.Asp(this.GridView2, this.AspNetPager2, UserHolidayDetailEntity);
UserEntity userEntity = new UserEntity();
UserBll userBll = new UserBll();
userEntity.UserID = this.ViewState["id"].ToString();
DataTable byID = userBll.GetByID(userEntity);
if (byID != null && byID.Rows.Count == 1)
{
this.Label1.Text = byID.Rows[0]["UserName"].ToString();
this.Label2.Text = byID.Rows[0]["UserIntegral"].ToString();
}
}
public DataTable GetByID(UserHolidayDetailEntity mo)
{
DataBase db = new DataBase();
string sql = "select ui.DetailID as DetailID,ui.UserID as UserID,ui.IntegralChange as IntegralChange,ui.ChangeDes as ChangeDes,us.UserName as UserName from UserHolidayDetail ui,Users us where ui.UserID=us.UserID";
if (mo.DetailID != 0)
{
sql += " and ui.DetailID=@DetailID";
}
if (mo.UserID != null && mo.UserID != "")
{
sql += " and ui.UserID=@UserID";
}
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@DetailID", SqlDbType.Int);
param[0].Value = mo.DetailID;
param[1] = new SqlParameter("@UserID", SqlDbType.VarChar, 50);
param[1].Value = mo.UserID;
return(db.GetDataTable(sql, param));
}
protected void Button1_Click(object sender, EventArgs e)
{
if (base.Request.QueryString["type"].ToString() == "1")
{
UserHolidayEntity rewardProblemEntity = new UserHolidayEntity();
UserHolidayBll rewarProblemBll = new UserHolidayBll();
rewardProblemEntity.UserHolidayID = int.Parse(this.ViewState["id"].ToString());
rewardProblemEntity.UserID = "";
DataTable byID = rewarProblemBll.GetByID(rewardProblemEntity);
if (byID == null || byID.Rows.Count != 1)
{
base.Response.Redirect("~/login_1.aspx");
return;
}
string userID = byID.Rows[0]["UserID"].ToString();
UserEntity userEntity = new UserEntity();
UserBll userBll = new UserBll();
userEntity.UserID = userID;
DataTable byID2 = userBll.GetByID(userEntity);
if (byID2 != null && byID2.Rows.Count == 1)
{
userEntity.UserID = userID;
userEntity.UserIntegral = int.Parse(byID2.Rows[0]["UserIntegral"].ToString()) + 5;
userBll.Update_Integral(userEntity);
UserHolidayDetailEntity UserHolidayDetailEntity = new UserHolidayDetailEntity();
UserHolidayDetailBll UserHolidayDetailBll = new UserHolidayDetailBll();
UserHolidayDetailEntity.UserID = userID;
UserHolidayDetailEntity.IntegralChange = 5;
UserHolidayDetailEntity.ChangeDes = "请假认同上报";
UserHolidayDetailBll.Add(UserHolidayDetailEntity);
rewardProblemEntity.ManagerBack = this.txtDes.Text.Trim();
rewardProblemEntity.RecordState = 2;
rewarProblemBll.Update_Back(rewardProblemEntity);
base.Response.Redirect("UserHolidayManage.aspx");
return;
}
base.Response.Redirect("~/login_1.aspx");
return;
}
else
{
RewardProblemEntity rewardProblemEntity2 = new RewardProblemEntity();
RewardProbelmBll wrongProblemBll2 = new RewardProbelmBll();
rewardProblemEntity2.RewardProblemID = int.Parse(this.ViewState["id"].ToString());
rewardProblemEntity2.UserID = "";
DataTable byID3 = wrongProblemBll2.GetByID(rewardProblemEntity2);
if (byID3 != null && byID3.Rows.Count == 1)
{
string userID2 = byID3.Rows[0]["UserID"].ToString();
UserHolidayDetailEntity UserHolidayDetailEntity2 = new UserHolidayDetailEntity();
UserHolidayDetailBll UserHolidayDetailBll2 = new UserHolidayDetailBll();
UserHolidayDetailEntity2.UserID = userID2;
UserHolidayDetailEntity2.IntegralChange = 0;
UserHolidayDetailEntity2.ChangeDes = "请假不认同上报";
UserHolidayDetailBll2.Add(UserHolidayDetailEntity2);
rewardProblemEntity2.ManagerBack = this.txtDes.Text.Trim();
rewardProblemEntity2.RecordState = 3;
wrongProblemBll2.Update_Back(rewardProblemEntity2);
base.Response.Redirect("UserHolidayManage.aspx");
return;
}
base.Response.Redirect("~/login_1.aspx");
return;
}
}
public void Asp(GridView gv, AspNetPager pager, UserHolidayDetailEntity mo)
{
this.dal.Asp(gv, pager, mo);
}
public DataTable GetByID(UserHolidayDetailEntity mo)
{
return(this.dal.GetByID(mo));
}
public bool Delete(UserHolidayDetailEntity mo)
{
return(this.dal.Delete(mo));
}
public bool Update(UserHolidayDetailEntity mo)
{
return(this.dal.Update(mo));
}
public bool Add(UserHolidayDetailEntity mo)
{
return(this.dal.Add(mo));
}
