/// <summary> /// 学员信息和预约单绑定 /// </summary> /// <param name="studi"></param> /// <param name="apid"></param> public static void BindStudentforAP(string studi, string apid) { Appointment ap = AppointmentData.GetOneByID(apid); ap.ApStudentID = studi; MsSqlMapperHepler.Update <Appointment>(ap, DBKeys.PRX); }
/// <summary> /// 保存 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool UpdateSYS_Account(SYSAccount sys) { SYSAccount sysa = Accounts_UpdateData.GetSYS_AccountByID(sys.ACC_Id); //获取对象 Cloner <SYSAccount, SYSAccount> .CopyTo(sys, sysa); //代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(sysa, DBKeys.PRX)); }
/// <summary> /// 保存 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool UpdateMessage(Message Mes) { Message Stuto = MessageData.GetMessageByID(Mes.ID); //获取对象 Cloner <Message, Message> .CopyTo(Mes, Stuto); //代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(Stuto, DBKeys.PRX)); }
public static bool updateCourse(Course course) { Course to = CourseData.getCourseById(course.ID); Cloner <Course, Course> .CopyTo(course, to); return(MsSqlMapperHepler.Update(to, DBKeys.PRX)); }
/// <summary> /// 保存 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool UpdateStudent(Students Stu) { Students Stuto = StudentData.GetStudentsByID(Stu.ID); //获取对象 Cloner <Students, Students> .CopyTo(Stu, Stuto); //代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(Stuto, DBKeys.PRX)); }
/// <summary> /// 保存 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool UpdateDiscount(Discount Dis) { Discount Stuto = DiscountData.GetDiscountByID(Dis.ID); //获取对象 Cloner <Discount, Discount> .CopyTo(Dis, Stuto); //代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(Stuto, DBKeys.PRX)); }
/// <summary> /// 保存班级信息 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool Update(Classes Stu) { Classes Stuto = ClassesData.GetClassesByID(Stu.ID); //获取对象 Cloner <Classes, Classes> .CopyTo(Stu, Stuto); //代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(Stuto, DBKeys.PRX)); }
/// <summary> /// 保存 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool UpdateButton(SYSButton btn) { SYSButton btnto = ButtonData.GetButtonByID(btn.BTN_Id); //获取对象 Cloner <SYSButton, SYSButton> .CopyTo(btn, btnto); //代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(btnto, DBKeys.PRX)); }
/// <summary> /// 保存 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool UpdateReimburse(Reimburse Rb) { Reimburse Rbs = ReimburseData.GetReimburseByID(Rb.ID); //获取对象 Cloner <Reimburse, Reimburse> .CopyTo(Rb, Rbs); //代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(Rbs, DBKeys.PRX)); }
/// <summary> /// 保存 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool UpdateRefund(Refund re) { Refund Ref = RefundInfoData.GetRefundByID(re.ID); //获取对象 Cloner <Refund, Refund> .CopyTo(re, Ref); //代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(Ref, DBKeys.PRX)); }
/// <summary> /// 保存 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool UpdateAttendanceRecord(AttendanceRecord att) { AttendanceRecord Stuto = StudentScheduleListData.GetAttendanceRecordByID(att.ID); //获取对象 Cloner <AttendanceRecord, AttendanceRecord> .CopyTo(att, Stuto); //代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(Stuto, DBKeys.PRX)); }
/// <summary> /// 保存 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool UpdateTransfer(Transfer Rb) { Transfer Rbs = TransferData.GetTransferByID(Rb.ID); //获取对象 Cloner <Transfer, Transfer> .CopyTo(Rb, Rbs); //代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(Rbs, DBKeys.PRX)); }
/// <summary> /// 修改预约记录 /// </summary> /// <param name="obj"></param> /// <returns></returns> public static bool Update(Appointment obj) { Appointment objTo = AppointmentData.GetOneByID(obj.ID);//获取对象 obj.CreateTime = objTo.CreateTime; obj.ApStateID = objTo.ApStateID; Cloner <Appointment, Appointment> .CopyTo(obj, objTo);//代码克隆,把前台或者的值也就是变更内容复制到目标对象,不做变更的数据不变 return(MsSqlMapperHepler.Update(objTo, DBKeys.PRX)); }
/// <summary> /// 停课一周 /// </summary> /// <param name="classid"></param> /// <param name="classindex"></param> /// <returns></returns> public static DateTime StopClass(string classid, int classindex) { string strsql1 = "select max(ClassDate) from [ClassList] where [ClassID] = '" + classid + "'"; DateTime lastClassTime = MsSqlMapperHepler.SqlWithParamsSingle <DateTime>(strsql1, null, DBKeys.PRX);//获取最后一次课的时间 ClassList cl = GetOneByid(classid, classindex); cl.ClassDate = lastClassTime.AddDays(7);//延后一周 MsSqlMapperHepler.Update(cl, DBKeys.PRX); return(cl.ClassDate); }
/// <summary> /// 更新 Enroll信息 /// </summary> /// <param name="btn"></param> /// <returns></returns> public static bool Update(Enroll obj) { bool ret = false; try { MsSqlMapperHepler.Update <Enroll>(obj, DBKeys.PRX); ret = true; } catch (Exception ex) { throw new Exception(ex.Message); } return(ret); }
/// <summary> /// 新增跟进记录 /// </summary> /// <param name="obj"></param> /// <returns></returns> public static bool AddFollow(FollowRecord obj) { bool ret = false; try { MsSqlMapperHepler.Insert <FollowRecord>(obj, DBKeys.PRX); Appointment ap = GetOneByID(obj.APID); if (ap.ApStateID == 1)//如果之前是未跟进则改成已跟进 { ap.ApStateID = 2; } MsSqlMapperHepler.Update <Appointment>(ap, DBKeys.PRX); ret = true; } catch (Exception ex) { throw new Exception(ex.Message); } return(ret); }