/// <summary>
/// 修改学习卡设置项
/// </summary>
/// <param name="entity">业务实体</param>
public void SetSave(LearningCardSet entity)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
Song.Entities.LearningCardSet rs = tran.From <LearningCardSet>().Where(LearningCardSet._.Lcs_ID == entity.Lcs_ID).ToFirst <LearningCardSet>();
LearningCard[] cards = CardGenerate(entity, tran);
if (cards != null)
{
foreach (LearningCard c in cards)
{
Gateway.Default.Save <LearningCard>(c);
}
}
tran.Update <LearningCard>(new Field[] { LearningCard._.Lc_Price, LearningCard._.Lc_LimitStart, LearningCard._.Lc_LimitEnd },
new object[] { entity.Lcs_Price, entity.Lcs_LimitStart, entity.Lcs_LimitEnd },
LearningCard._.Lcs_ID == entity.Lcs_ID && LearningCard._.Lc_IsUsed == false);
tran.Save <LearningCardSet>(entity);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}
void fill()
{
Song.Entities.LearningCardSet set = id == 0 ? new Song.Entities.LearningCardSet() : Business.Do <ILearningCard>().SetSingle(id);
if (id > 0)
{
this.EntityBind(set);
//当前学习卡关联的课程
Song.Entities.Course[] courses = Business.Do <ILearningCard>().CoursesGet(set);
if (courses != null)
{
rtpCourses.DataSource = courses;
rtpCourses.DataBind();
foreach (Song.Entities.Course c in courses)
{
tbCourses.Text += c.Cou_ID + ",";
}
}
}
if (id < 1)
{
//如果是新增
Lcs_LimitStart.Text = DateTime.Now.ToString("yyyy-MM-dd");
Lcs_LimitEnd.Text = DateTime.Now.AddMonths(12).ToString("yyyy-MM-dd");
Lcs_SecretKey.Text = getUID();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
List <Song.Entities.LearningCard> lcs = Business.Do <ISystemPara>().ForSql <Song.Entities.LearningCard>("select * from LearningCard where Lc_State=1");
foreach (LearningCard lc in lcs)
{
int acid = lc.Ac_ID; //学员Id
int span = lc.Lc_Span; //要增加的学习时间
//获取学习卡关联的课程
Song.Entities.LearningCardSet lset = Business.Do <ILearningCard>().SetSingle(lc.Lcs_ID);
Song.Entities.Course[] cours = Business.Do <ILearningCard>().CoursesGet(lset);
foreach (Song.Entities.Course c in cours)
{
Student_Course sc = Business.Do <ISystemPara>()
.ScalarSql <Student_Course>(string.Format("select * from student_course where ac_id={0} and cou_id={1}", acid, c.Cou_ID));
if (sc != null)
{
DateTime end = sc.Stc_StartTime.AddDays(span); //应该结束的学习时效
if (end > sc.Stc_EndTime)
{
sc.Stc_EndTime = end;
Business.Do <ISystemPara>().ExecuteSql(string.Format("update student_course set stc_endtime='{0}' where ac_id={1} and cou_id={2}",
end.ToString("yyyy-MM-dd"), acid, c.Cou_ID));
}
}
}
}
this.Response.Write(this.Button2.Text + "---操作完成！");
}
/// <summary>
/// ÐÞ¸ÄÊÇ·ñÏÔʾµÄ״̬
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void sbEnable_Click(object sender, EventArgs e)
{
StateButton ub = (StateButton)sender;
int index = ((GridViewRow)(ub.Parent.Parent)).RowIndex;
int id = int.Parse(this.GridView1.DataKeys[index].Value.ToString());
//
Song.Entities.LearningCardSet entity = Business.Do <ILearningCard>().SetSingle(id);
entity.Lcs_IsEnable = !entity.Lcs_IsEnable;
Business.Do <ILearningCard>().SetSave(entity);
BindData(null, null);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnEnter_Click(object sender, EventArgs e)
{
Song.Entities.LearningCardSet set = id != 0 ? Business.Do <ILearningCard>().SetSingle(id) : new Song.Entities.LearningCardSet();
set = this.EntityFill(set) as Song.Entities.LearningCardSet;
//关联的课程
set = Business.Do <ILearningCard>().CoursesSet(set, tbCourses.Text.Trim());
try
{
if (id == 0)
{
Business.Do <ILearningCard>().SetAdd(set);
}
else
{
Business.Do <ILearningCard>().SetSave(set);
}
Master.AlertCloseAndRefresh("操作成功！");
}
catch (Exception ex)
{
Master.Alert(ex.Message);
}
}
