public UserDownload GetUserDownload(int uID, int cdID)
{
string sql = "select * from UserDownload where U_ID=@U_ID and CD_ID=@CD_ID";
SqlParameter[] p =
{
new SqlParameter("@U_ID", uID),
new SqlParameter("@CD_ID", cdID)
};
SqlDataReader sdr = SQLHelper.ExecuteReader(sql, CommandType.Text, p);
UserDownload userdownload = new UserDownload();
while (sdr.Read())
{
userdownload.UD_ID = Convert.ToInt32(sdr["UD_ID"]);
userdownload.C_ID = Convert.ToInt32(sdr["C_ID"]);
userdownload.CD_ID = Convert.ToInt32(sdr["CD_ID"]);
userdownload.U_ID = Convert.ToInt32(sdr["U_ID"]);
userdownload.CD_IsBei = Convert.ToInt32(sdr["CD_IsBei"]);
userdownload.UD_CUT = Convert.ToInt32(sdr["UD_CUT"]);
userdownload.UD_STUDY = Convert.ToDateTime(sdr["UD_STUDY"]);
userdownload.UD_Review = Convert.ToDateTime(sdr["UD_Review"]);
}
return(userdownload);
}
public List <UserDownload> SeleteUserDownload()
{
List <UserDownload> lud = new List <UserDownload>();
string sql = "select * from UserDownload";
SqlDataReader sdr = SQLHelper.ExecuteReader(sql, System.Data.CommandType.Text, null);
if (sdr.HasRows)
{
while (sdr.Read())
{
UserDownload ud = new UserDownload();
ud.UD_ID = Convert.ToInt32(sdr["UD_ID"]);
ud.U_ID = sdr["U_ID"].ToString();
ud.C_ID = Convert.ToInt32(sdr["C_ID"]);
ud.CD_ID = Convert.ToInt32(sdr["CD_ID"]);
ud.CD_IsBei = Convert.ToBoolean(sdr["CD_IsBei"]);
ud.UD_CUT = Convert.ToBoolean(sdr["UD_CUT"]);
ud.UD_STUDY = Convert.ToDateTime(sdr["UD_STUDY"]);
ud.UD_Review = Convert.ToDateTime(sdr["UD_Review"]);
ud.UD_DATE = Convert.ToInt32(sdr["UD_DATE"]);
ud.UD_Status = sdr["UD_Status"].ToString();
lud.Add(ud);
}
}
sdr.Close();
return(lud);
}
/// <summary>
/// 获取指定用户的用户单词列表
/// </summary>
/// <param name="uID"></param>
/// <returns></returns>
public List <UserDownload> GetUserDownloadByUID(int uID)
{
string sql = "select * from UserDownload where U_ID=@U_ID";
SqlParameter[] p =
{
new SqlParameter("@U_ID", uID)
};
SqlDataReader sdr = SQLHelper.ExecuteReader(sql, CommandType.Text, p);
List <UserDownload> list = new List <UserDownload>();
while (sdr.Read())
{
UserDownload userdownload = new UserDownload();
userdownload.UD_ID = Convert.ToInt32(sdr["UD_ID"]);
userdownload.C_ID = Convert.ToInt32(sdr["C_ID"]);
userdownload.CD_ID = Convert.ToInt32(sdr["CD_ID"]);
userdownload.U_ID = Convert.ToInt32(sdr["U_ID"]);
userdownload.CD_IsBei = Convert.ToInt32(sdr["CD_IsBei"]);
userdownload.UD_CUT = Convert.ToInt32(sdr["UD_CUT"]);
userdownload.UD_STUDY = Convert.ToDateTime(sdr["UD_STUDY"]);
userdownload.UD_Review = Convert.ToDateTime(sdr["UD_Review"]);
list.Add(userdownload);
}
return(list);
}
protected void Pic_1_Click(object sender, ImageClickEventArgs e)
{
UserDownload ud = new UserDownload();
UserDownload_Bll ud_b = new UserDownload_Bll();
ud = ud_b.GetUserDownload(Convert.ToInt32(Session["ID"]), Convert.ToInt32(Session["c_id"]), Convert.ToInt32(Session["cd_id"]));
if (ud.UD_ID < 1)
{
UserDownload ud1 = new UserDownload();
UserDownload_Bll ud_b1 = new UserDownload_Bll();
ud1.C_ID = Convert.ToInt32(Session["c_id"]);
ud1.CD_ID = Convert.ToInt32(Session["cd_id"]);
ud1.U_ID = Convert.ToInt32(Session["ID"]);
ud1.CD_IsBei = 1;
ud1.UD_CUT = 0;
ud1.UD_STUDY = DateTime.Now;
ud1.UD_Review = DateTime.Now;
ud1.UD_Data = 0;
ud1.UD_Status = 0;
bool i = ud_b1.AddUserDownload(ud1);
if (i)
{
xx = ud1.CD_ID + 1;
Response.Redirect("Study_Words.aspx?xx=" + xx + "", false);
}
}
}
public static int u_id; //用户ID
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
UserCollect_Bll uc_b = new UserCollect_Bll();
Coures_Bll cb = new Coures_Bll();
Button1.Attributes.Add("onmouseout", "this.src='Images/index_btn.png'");
Button1.Attributes.Add("onmouseover", "this.src='Images/index_btn_hover.png'");
u_id = Convert.ToInt32(Session["ID"].ToString());
UserCollect uc = new UserCollect();
uc = uc_b.GetUserCollect(u_id);
c_id = uc.C_ID;
//Response.Write("<script>alert('" + c_id + "')</script>");
lab_view.Text = cb.GetCourse(c_id).C_NAME.ToString();
lab_view.DataBind(); //获取单词包名称
Bind(); //剩余天数
UserDownload ud = new UserDownload();
UserDownload_Bll ud_b = new UserDownload_Bll();
int count = ud_b.GetCount(Convert.ToInt32(Session["ID"]), c_id);
lab_view_finish.Text = count.ToString();
lab_view_finish.DataBind();//完成单词数
lab_view_number.Text = cb.GetCourse(c_id).C_vocabulary.ToString();
lab_view_number.DataBind();//该单词包的总单词数
DateTime now = DateTime.Now.Date;
DateTime ts = DateTime.Parse(uc_b.GetUserCollectUid(u_id).UC_StartDay.ToString()).Date;
TimeSpan t1 = ts.Subtract(now); //计算开始时间到结束时间天数差
TimeSpan t2 = now.Subtract(now); //计算开始时间到结束时间天数差
lab_xinxue.Text = "0";
//if(t1!=t2)
//{
// lab_xinxue.Text = "0";
//}
//else
//{
// lab_xinxue.Text = Convert.ToString(Session["xinxue"].ToString());
//}
//获取今日新目标
lab_view_words.Text = uc_b.GetUserCollectUid(u_id).UC_EveWord.ToString();
lab_view_words.DataBind();//获取今日目标
Users_Bll ub = new Users_Bll();
Users u = new Users();
u = ub.GetUser(Convert.ToInt32(Session["ID"]));
Lab_name.Text = u.U_NAME;
}
}
protected void Pic_1_Click(object sender, ImageClickEventArgs e)
{
UserDownload_Bll ud_b = new UserDownload_Bll();
UserDownload ud = new UserDownload();
ud = ud_b.GetUserDownload(2, cdid);
ud.UD_Review = DateTime.Now;
ud_b.ModifyUserDownload(ud);
rank = rank + 1;
Response.Redirect("Review_Words.aspx?rank=" + rank + "");
}
public static UserDownload Map(UserDownload model)
{
if (model == null)
{
return(null);
}
return(new UserDownload()
{
DateTime = model.DateTime,
Id = model.Id,
Product_Id = model.Product_Id,
User_Id = model.User_Id
});
}
public OperationResult Create(UserDownload model)
{
if (model == null)
{
return(null);
}
model.DateTime = DateTime.Now;
//todo : set UserID to real value
model.User_Id = 1;
OperationResult rState = null;
using (UnitOfWork uow = new UnitOfWork())
{
uow.UserDownloadRepository.Insert(model, out rState);
return(rState);
}
}
public int AddUserDownload(UserDownload ud)
{
string sql = "insert into UserDownload values(@a,@b,@c,@d,@e,@f,@g,@h,@i,@j)";
SqlParameter[] par =
{
new SqlParameter("@a", ud.UD_ID),
new SqlParameter("@b", ud.U_ID),
new SqlParameter("@c", ud.C_ID),
new SqlParameter("@d", ud.CD_ID),
new SqlParameter("@e", ud.CD_IsBei),
new SqlParameter("@f", ud.UD_CUT),
new SqlParameter("@g", ud.UD_STUDY),
new SqlParameter("@h", ud.UD_Review),
new SqlParameter("@i", ud.UD_DATE),
new SqlParameter("@j", ud.UD_Status)
};
return(SQLHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, par));
}
/// <summary>
/// 修改用户单词
/// </summary>
/// <param name="userdownload"></param>
/// <returns></returns>
public bool ModifyUserDownload(UserDownload userdownload)
{
string sql = "update UserDownload set C_ID=@C_ID,CD_ID=@CD_ID,U_ID=@U_ID,CD_IsBei=@CD_IsBei,UD_CUT=@UD_CUT,UD_STUDY=@UD_STUDY,UD_Review=@UD_Review where UD_ID=@UD_ID";
SqlParameter[] p =
{
new SqlParameter("@UD_ID", userdownload.UD_ID),
new SqlParameter("@C_ID", userdownload.C_ID),
new SqlParameter("@CD_ID", userdownload.CD_ID),
new SqlParameter("@U_ID", userdownload.U_ID),
new SqlParameter("@CD_IsBei", userdownload.CD_IsBei),
new SqlParameter("@UD_CUT", userdownload.UD_CUT),
new SqlParameter("@UD_STUDY", userdownload.UD_STUDY),
new SqlParameter("@UD_Review", userdownload.UD_Review)
};
int i = SQLHelper.ExecuteNonQuery(sql, CommandType.Text, p);
return(i > 0);
}
/// <summary>
/// 添加用户单词
/// </summary>
/// <param name="userdownload"></param>
/// <returns></returns>
public bool AddUserDownload(UserDownload userdownload)
{
string sql = "insert into UserDownload values(@U_ID,@C_ID,@CD_ID,@CD_IsBei,@UD_CUT,@UD_STUDY,@UD_Review,@UD_Data,@UD_Status)";
SqlParameter[] p =
{
new SqlParameter("@C_ID", userdownload.C_ID),
new SqlParameter("@CD_ID", userdownload.CD_ID),
new SqlParameter("@U_ID", userdownload.U_ID),
new SqlParameter("@CD_IsBei", userdownload.CD_IsBei),
new SqlParameter("@UD_CUT", userdownload.UD_CUT),
new SqlParameter("@UD_STUDY", userdownload.UD_STUDY),
new SqlParameter("@UD_Review", userdownload.UD_Review),
new SqlParameter("@UD_Data", userdownload.UD_Data),
new SqlParameter("@UD_Status", userdownload.UD_Status)
};
int i = SQLHelper.ExecuteNonQuery(sql, CommandType.Text, p);
return(i > 0);
}
public int UpdateUserDownload(UserDownload ud)
{
string sql = @"insert into UserDownload set U_ID=@a2,C_ID=@a3,CD_ID=@a4,
CD_IsBei=@a5,UD_CUT=@a6,UD_STUDY=@a7,UD_Review=@a8,
UD_DATE=@a9,UD_Status=@a10 where UD_ID=@a1";
SqlParameter[] par =
{
new SqlParameter("@a1", ud.UD_ID),
new SqlParameter("@a2", ud.U_ID),
new SqlParameter("@a3", ud.C_ID),
new SqlParameter("@a4", ud.CD_ID),
new SqlParameter("@a5", ud.CD_IsBei),
new SqlParameter("@a6", ud.UD_CUT),
new SqlParameter("@a7", ud.UD_STUDY),
new SqlParameter("@a8", ud.UD_Review),
new SqlParameter("@a9", ud.UD_DATE),
new SqlParameter("@a10", ud.UD_Status)
};
return(SQLHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, par));
}
/// <summary>
/// 获取所有用户单词列表
/// </summary>
/// <returns></returns>
public List <UserDownload> GetAllUserDownload()
{
string sql = "select * from UserDownload";
SqlDataReader sdr = SQLHelper.ExecuteReader(sql, CommandType.Text, null);
List <UserDownload> list = new List <UserDownload>();
while (sdr.Read())
{
UserDownload userdownload = new UserDownload();
userdownload.UD_ID = Convert.ToInt32(sdr["UD_ID"]);
userdownload.C_ID = Convert.ToInt32(sdr["C_ID"]);
userdownload.CD_ID = Convert.ToInt32(sdr["CD_ID"]);
userdownload.U_ID = Convert.ToInt32(sdr["U_ID"]);
userdownload.CD_IsBei = Convert.ToInt32(sdr["CD_IsBei"]);
userdownload.UD_CUT = Convert.ToInt32(sdr["UD_CUT"]);
userdownload.UD_STUDY = Convert.ToDateTime(sdr["UD_STUDY"]);
userdownload.UD_Review = Convert.ToDateTime(sdr["UD_Review"]);
list.Add(userdownload);
}
return(list);
}
protected void img_but_Click(object sender, ImageClickEventArgs e)
{
UserCollect_Bll uc_b = new UserCollect_Bll();
UserDownload_Bll ud_d = new UserDownload_Bll();
if (dl_Customer.SelectedIndex != null)
{
p = Convert.ToInt32(uc_b.GetUserCollectByUID(u_id).UC_ID.ToString());
if (p > 0)
{
//修改计划
UserCollect updatuc = new UserCollect();
updatuc.U_ID = u_id;
updatuc.C_ID = c_id;
updatuc.UC_StartDay = DateTime.Now;
updatuc.UC_EndDay = Convert.ToDateTime(myRegisterTime.Text);
updatuc.UC_ComDay = Convert.ToInt32(days);
updatuc.UC_EveWord = daycount;
//Response.Write("<script>alert('" + p + "')</script>");
bool flag = uc_b.ModifyUserCollectbyuid(updatuc);
if (flag)
{
Response.Write("<script>alert('修改计划成功')</script>");
#region
//向动态表添加用户动态数据
UserDownload ud = new UserDownload();
//if (BCZ.BLL.UserNewsBusiness.AddUserNews(usernews))
//{
//}
#endregion
Session["c_id"] = c_id;//获取单词包id用于传值
Response.Write("<script>window.top.location='../Recite Words/start.aspx'</script>");
}
else
{
Response.Write("<script>alert('修改计划不成功')</script>");
}
}
else
{
//添加计划
UserCollect adduc = new UserCollect();
adduc.U_ID = u_id;
adduc.C_ID = c_id;
adduc.UC_StartDay = DateTime.Now;
adduc.UC_EndDay = Convert.ToDateTime(myRegisterTime.Text);
adduc.UC_ComDay = Convert.ToInt32(days);
adduc.UC_EveWord = daycount;
if (uc_b.AddUserCollect(adduc))
{
Response.Write("<script>alert('添加计划成功')</script>");
#region
//向用户进度表添加数据
//UserDownload ud = new UserDownload();
//ud.
//string str = "今天我添加了" + BCZ.BLL.CourseBusiness.GetCourse(c_id).c_Name + "的计划";
//usernews.un_Content = str;
//usernews.un_PublishTime = DateTime.Now.ToString();
//usernews.u_Id = u_id;
//if (BCZ.BLL.UserNewsBusiness.AddUserNews(usernews))
//{
//}
#endregion
Session["c_id"] = c_id;//获取单词包id用于传值
//Response.Redirect("../Recite Words/start.aspx", true);
Response.Write("<script>window.top.location='../Recite Words/start.aspx'</script>");
}
else
{
Response.Write("<script>alert('添加计划不成功')</script>");
}
}
}
}
/// <summary>
/// 修改用户进度
/// </summary>
/// <param name="userdownload"></param>
/// <returns></returns>
public bool ModifyUserDownload(UserDownload userdownload)
{
return(ud_d.ModifyUserDownload(userdownload));
}
/// <summary>
/// 添加用户进度
/// </summary>
/// <param name="userdownload"></param>
/// <returns></returns>
public bool AddUserDownload(UserDownload userdownload)
{
return(ud_d.AddUserDownload(userdownload));
}
public int UpdatUserDownload(UserDownload ud)
{
return(dud.UpdateUserDownload(ud));
}
public int AddUserDownload(UserDownload ud)
{
return(dud.AddUserDownload(ud));
}
// POST: api/UserDownloadData
public OperationResult Post([FromBody] UserDownload model)
{
var result = new Biz.DownloadBiz().Create(model);
return(result);
}
