/// <summary>
/// 添加新的教师
/// </summary>
/// <returns></returns>
public static string AddTeach(Teachers teacher)
{
if (string.IsNullOrEmpty(teacher.ID))
{
RandomOperate operate = new RandomOperate();
teacher.ID = operate.CreateMD5Hash(operate.GenerateCheckCode(30));
}
return(MsSqlMapperHepler.Insert <Teachers>(teacher, DBKeys.PRX));
}
/// <summary>
/// 新增时钟（字典表）
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static bool AddDictionaryItemt(DictionaryItem item)
{
bool ret = false;
try
{
MsSqlMapperHepler.Insert <DictionaryItem>(item, DBKeys.PRX);
ret = true;
}
catch (Exception)
{
throw;
}
return(ret);
}
/// <summary>
/// 新增预约记录
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool Add(Appointment obj)
{
bool ret = false;
try
{
MsSqlMapperHepler.Insert <Appointment>(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 Add(Enroll obj)
{
bool ret = false;
try
{
MsSqlMapperHepler.Insert <Enroll>(obj, DBKeys.PRX);
//Classes ca = ClassesData.GetClassesByID(obj.ClassID);
////ca.PresentEnroll = ca.PresentEnroll + 1;
//MsSqlMapperHepler.Update<Classes>(ca,DBKeys.PRX);//报名数加1
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);
}
/// <summary>
/// 新增,返回的是主键
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static int AddDiscount(Discount Dis)
{
return(MsSqlMapperHepler.Insert <Discount>(Dis, DBKeys.PRX));
}
public static int addCourse(Course course)
{
return(MsSqlMapperHepler.Insert <Course>(course, DBKeys.PRX));
}
/// <summary>
/// 新增,返回的是主键
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static int AddButton(SYSButton btn)
{
return(MsSqlMapperHepler.Insert <SYSButton>(btn, DBKeys.PRX));
}
/// <summary>
/// 新增,返回的是主键
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static string AddStudent(Classes Clas)
{
return(MsSqlMapperHepler.Insert <Classes>(Clas, DBKeys.PRX));
}
/// <summary>
/// 新增,返回的是主键
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static int AddRefund(Refund obj)
{
return(MsSqlMapperHepler.Insert <Refund>(obj, DBKeys.PRX));
}
/// <summary>
/// 保存签名数据
/// </summary>
/// <returns></returns>
public static int SaveSign(SignImage si)
{
return(MsSqlMapperHepler.Insert(si, DBKeys.PRX));
}
/// <summary>
/// 新增,返回的是主键
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static int AddReimburse(Reimburse Rb)
{
return(MsSqlMapperHepler.Insert <Reimburse>(Rb, DBKeys.PRX));
}
/// <summary>
/// 新增,返回的是主键
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static int AddFiles(Files files)
{
return(MsSqlMapperHepler.Insert <Files>(files, DBKeys.PRX));
}
/// <summary>
///新增加课方法,返回的是主键 ClassList表
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static bool AddClassesSAVA(ClassList Clas)
{
bool ret = false;
try
{
string Week = Clas.ClassDate.DayOfWeek.ToString(); //判断这是星期几,根据加课时间来判断的
int weekday = 0; //默认给个数
if (Week.Contains("Monday")) //判断有选择星期
{
weekday = 2;
}
if (Week.Contains("Tuesday"))//判断有选择星期
{
weekday = 3;
}
if (Week.Contains("Wednesday"))//判断有选择星期
{
weekday = 4;
}
if (Week.Contains("Thursday"))//判断有选择星期
{
weekday = 5;
}
if (Week.Contains("Friday"))//判断有选择星期
{
weekday = 6;
}
if (Week.Contains("Saturday"))//判断有选择星期
{
weekday = 7;
}
if (Week.Contains("Sunday"))//判断有选择星期
{
weekday = 1;
}
ClassList CL = new ClassList();
CL.ClassID = Clas.ClassID;
CL.ClassIndex = Getnumber(Clas.ClassID) + 1; //取行号
CL.ClassDate = Clas.ClassDate;
CL.TimePeriod = Clas.TimePeriod;
CL.StateID = 1;
CL.TeacherID = Clas.TeacherID;
CL.Teacher2ID = Clas.Teacher2ID;
CL.RoomID = Clas.RoomID;
CL.CreateTIme = DateTime.Now;
CL.CreatorId = Clas.CreatorId;
CL.weekday = weekday;
MsSqlMapperHepler.Insert <ClassList>(CL, DBKeys.PRX);
ret = true; //新增成功
}
catch (Exception ex)
{
throw new Exception(ex.Message + "。" + ex.InnerException.Message);
}
return(ret);
}
/// <summary>
/// 新增,返回的是主键
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static int AddClassListJob(ClassListJob Clas)
{
return(MsSqlMapperHepler.Insert <ClassListJob>(Clas, DBKeys.PRX));
}
/// <summary>
/// 新增,返回的是主键
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static int AddMessage(Message Mes)
{
return(MsSqlMapperHepler.Insert <Message>(Mes, DBKeys.PRX));
}
/// <summary>
/// 新增,返回的是主键
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static int AddTransfer(Transfer Rb)
{
return(MsSqlMapperHepler.Insert <Transfer>(Rb, DBKeys.PRX));
}