/// <summary>
/// 标记删除
/// </summary>
/// <param name="ht">参数Key:Id</param>
/// <returns></returns>
public JsonModel MarkDelete(Hashtable ht)
{
try
{
//定义JSON标准格式实体中
JsonModel jsonModel = new JsonModel();
//判断计划是否归档
List <EmsModel.TeachingPlan> modListTP = dal.GetData(ht["Id"].ToString());
if (modListTP[0].IsDelete == 2)
{
jsonModel.Status = "no";
jsonModel.Msg = "课程已归档，不能删除！";
return(jsonModel);
}
//判断计划下是否存在实验
Hashtable htPE = new Hashtable();
htPE.Add("PlanId", ht["Id"].ToString());
htPE.Add("IsDelete", "全部");
htPE.Add("PageIndex", 1);
htPE.Add("PageSize", 10);
htPE = common.AddStartEndIndex(ht);
EmsDAL.PlanExperiment peDAL = new EmsDAL.PlanExperiment();
DataTable modListPE = peDAL.GetList(htPE);
if (modListPE.Rows.Count > 0)
{
jsonModel.Status = "no";
jsonModel.Msg = "请先删除实验，再删除课程！";
return(jsonModel);
}
//修改为删除状态
ht.Add("IsDelete", 1);
ht.Add("UpdateTime", DateTime.Now);
ht.Add("TableName", "TeachingPlan");
EmsDAL.DALHelper HelperDAL = new EmsDAL.DALHelper();
int result = HelperDAL.UpdateIsDelete(ht);
if (result > 0)
{
jsonModel.Status = "ok";
jsonModel.Msg = "删除成功";
}
else
{
jsonModel.Status = "no";
jsonModel.Msg = "删除失败";
}
return(jsonModel);
}
catch (Exception ex)
{
JsonModel jsonModel = new JsonModel();
jsonModel.Status = "error";
jsonModel.Msg = ex.ToString();
return(jsonModel);
}
}
/// <summary>
/// 修改课程
/// </summary>
/// <param name="ht">参数Key:Id</param>
/// <returns></returns>
public JsonModel UpdatePlan(Hashtable ht)
{
try
{
//定义JSON标准格式实体中
JsonModel jsonModel = new JsonModel();
JsonModel IsFiling = Filing(ht);
if (IsFiling.Status == "ok")
{
jsonModel.Status = "no";
jsonModel.Msg = "计划已归档，不能修改！";
}
int obj = new EmsDAL.PlanExperiment().getTeachingPlan(ht["MainTeacher"].ToString(), ht["Name"].ToString(), ht["LearnYear"].ToString());
if (obj > 0)
{
jsonModel.Status = "cf";
jsonModel.Msg = "课程名称重复！";
}
else
{
EmsModel.TeachingPlan ModelPlan = dal.GetData(ht["Id"].ToString())[0];
ModelPlan.Name = ht["Name"].ToString(); //课程名称
ModelPlan.MainTeacher = ht["MainTeacher"].ToString(); //主讲教师
ModelPlan.GuideTeacher1 = ht["GuideTeacher1"].ToString(); //指导教师1
ModelPlan.GuideTeacher2 = ht["GuideTeacher2"].ToString(); //指导教师2
ModelPlan.Contents = ht["Contents"].ToString(); //课程内容
ModelPlan.LearnYear = Convert.ToInt32(ht["LearnYear"].ToString()); //学年学期ID
//ModelPlan.Creator = Creator;//创建人登录名
//ModelPlan.CreateTime = DateTime.Now;//创建时间
ModelPlan.Editor = ht["Editor"].ToString(); //修改人登录名
ModelPlan.UpdateTime = DateTime.Now; //修改时间
int result = dal.Update(ModelPlan);
if (result > 0)
{
jsonModel.Status = "ok";
jsonModel.Msg = "修改成功";
}
else
{
jsonModel.Status = "no";
jsonModel.Msg = "修改失败";
}
}
return(jsonModel);
}
catch (Exception ex)
{
JsonModel jsonModel = new JsonModel();
jsonModel.Status = "error";
jsonModel.Msg = ex.ToString();
return(jsonModel);
}
}
/// <summary>
/// 添加课程
/// </summary>
/// <param name="ht">参数Key:Id</param>
/// <returns></returns>
public JsonModel AddPlan(EmsModel.TeachingPlan model)
{
try
{
JsonModel jsonModel = new JsonModel();
int obj = new EmsDAL.PlanExperiment().getTeachingPlan(model.MainTeacher.ToString(), model.Name.ToString(), model.LearnYear.ToString());
if (obj > 0)
{
jsonModel.Status = "cf";
jsonModel.Msg = "课程名称重复！";
}
else
{
int result = dal.Add(model);
//定义JSON标准格式实体中
if (result > 0)
{
jsonModel.Status = "ok";
jsonModel.Msg = "添加成功";
}
else
{
jsonModel.Status = "no";
jsonModel.Msg = "添加失败";
}
}
return(jsonModel);
}
catch (Exception ex)
{
JsonModel jsonModel = new JsonModel();
jsonModel.Status = "error";
jsonModel.Msg = ex.ToString();
return(jsonModel);
}
}
public EmsModel.JsonModel CreateOrder(Hashtable ht)
{
try
{
//string[] Str = ht["YSelectStr"].ToString().Split(',');//
//订单编号前缀
string prefix = "";
if (ht["Type"].ToString() == "0")
{
prefix = "SY";
}
else if (ht["Type"].ToString() == "1")
{
prefix = "YJ";
}
EmsDAL.OrderEquipDetail ModelOrderEquipDetail = new EmsDAL.OrderEquipDetail();
//订单赋值
EmsModel.OrderInfo ModelOrderInfo = new EmsModel.OrderInfo();
ModelOrderInfo.OrderNo = prefix;
ModelOrderInfo.LoanName = ht["LoanName"].ToString();
ModelOrderInfo.ExperimentId = Convert.ToInt32(ht["ExperimentId"]);
ModelOrderInfo.Type = Convert.ToByte(ht["Type"]);
ModelOrderInfo.Status = 0;
ModelOrderInfo.Creator = ht["Creator"].ToString();
ModelOrderInfo.CreateTime = DateTime.Now;
ModelOrderInfo.IsDelete = 0;
//修改实验“是否生成订单”状态
EmsDAL.PlanExperiment DALPE = new EmsDAL.PlanExperiment();
EmsModel.PlanExperiment ModelPE = DALPE.GetData(ht["ExperimentId"].ToString())[0];
ModelPE.Status = 1;//将实验状态赋值为“已生成订单”
//事务
using (SqlTransaction trans = dal.GetTran())
{
try
{
//添加订单
int orderId = dal.Add(trans, ModelOrderInfo);
if (orderId <= 0)
{
//回滚
trans.Rollback();
//定义JSON标准格式实体中
JsonModel jsonModel1 = new JsonModel();
jsonModel1.Status = "no";
jsonModel1.Msg = "订单生成失败";
return(jsonModel1);
}
//修改订单编号
ModelOrderInfo.Id = orderId;
ModelOrderInfo.OrderNo = prefix + DateTime.Now.ToString("yyMMddHHmmss") + orderId;
int UpdateReturn = dal.Update(trans, ModelOrderInfo);
if (UpdateReturn != 1)
{
//回滚
trans.Rollback();
//定义JSON标准格式实体中
JsonModel jsonModel1 = new JsonModel();
jsonModel1.Status = "no";
jsonModel1.Msg = "订单生成失败";
return(jsonModel1);
}
//修改实验状态
int UpdatePEReturn = DALPE.Update(trans, ModelPE);
if (UpdatePEReturn != 1)
{
//回滚
trans.Rollback();
//定义JSON标准格式实体中
JsonModel jsonModel1 = new JsonModel();
jsonModel1.Status = "no";
jsonModel1.Msg = "订单生成失败";
return(jsonModel1);
}
#region 添加订单设备详情
////生成订单
//int AddCount = 0;
//int SuccessCount = 0;
////循环添加设备
//foreach (string item in Str)
//{
// int EquipKindId = Convert.ToInt32(item.Substring(0, item.IndexOf("-")));
// int Count = Convert.ToInt32(item.Substring(item.IndexOf("-") + 1, item.IndexOf(":") - item.IndexOf("-") - 1));
// string InstrumentEquip = item.Substring(item.IndexOf(":") + 1);
// //更新需要添加的设备数量
// AddCount += Count;
// //每个设备添加一条数据
// for (int i = 0; i < Count; i++)
// {
// //model赋值
// EmsModel.OrderEquipDetail model = new EmsModel.OrderEquipDetail();
// model.OrderId = orderId;
// model.InventoryKindId = EquipKindId;
// model.EquipId = "";
// model.InstrumentEquip = InstrumentEquip;
// model.EquipDetailName = "";
// model.Type = 0;
// int ret = ModelOrderEquipDetail.Add(trans, model);
// if (ret > 0)
// {
// SuccessCount++;
// }
// }
//}
//if (AddCount != SuccessCount)
//{
// //回滚
// trans.Rollback();
// //定义JSON标准格式实体中
// JsonModel jsonModel1 = new JsonModel();
// jsonModel1.Status = "no";
// jsonModel1.Msg = "订单生成失败";
// return jsonModel1;
//}
//else
//{
// //提交
// trans.Commit();
//}
#endregion
//提交
trans.Commit();
}
catch (Exception)
{
//回滚
trans.Rollback();
throw;
}
}
//定义JSON标准格式实体中
JsonModel jsonModel = new JsonModel();
jsonModel.Status = "ok";
jsonModel.Msg = "订单生成成功";
return(jsonModel);
}
catch (Exception ex)
{
JsonModel jsonModel = new JsonModel();
jsonModel.Status = "error";
jsonModel.Msg = ex.ToString();
return(jsonModel);
}
}
/// <summary>
/// 修改实验
/// </summary>
/// <param name="ht">参数Key:Id</param>
/// <returns></returns>
public JsonModel UpdateExperiment(Hashtable ht)
{
try
{
int Id = Convert.ToInt32(ht["Id"].ToString());
EmsModel.PlanExperiment Model = dal.GetData(ht["Id"].ToString())[0];
Model.Name = ht["Name"].ToString();//实验名称
Model.Type = Convert.ToByte(ht["Type"].ToString());
Model.IsOpen = Convert.ToByte(ht["IsOpen"].ToString());
Model.StartDate = Convert.ToDateTime(ht["StartDate"].ToString());
Model.Week = Convert.ToInt32(ht["Week"].ToString());
Model.Weekday = Convert.ToInt32(ht["Weekday"].ToString());
Model.ClassHour = Convert.ToInt32(ht["ClassHour"].ToString());
Model.Part = ht["Part"].ToString();
Model.ComputerRoom = Convert.ToInt32(ht["ComputerRoom"].ToString());
Model.Place = Convert.ToInt32(ht["Place"].ToString());
Model.GroupMemberNumber = Convert.ToInt32(ht["GroupMemberNumber"].ToString());
Model.GroupNumber = Convert.ToInt32(ht["GroupNumber"].ToString());
Model.NeedEquip = ht["NeedEquip"].ToString();
Model.Contents = ht["Contents"].ToString();//实验内容
//Model.Creator = Creator;//创建人登录名
//Model.CreateTime = DateTime.Now;//创建时间
Model.Editor = ht["Editor"].ToString(); //修改人登录名
Model.UpdateTime = DateTime.Now; //修改时间
Model.ClassName = ht["Class"].ToString(); //上课班级
Model.Category = Convert.ToByte(ht["Category"].ToString()); //实验类别 0室内上课;1室外上课
//定义JSON标准格式实体中
JsonModel jsonModel = new JsonModel();
int obj = new EmsDAL.PlanExperiment().getPlanExperiment(Model.Name.ToString(), Model.PlanId.ToString());
if (obj > 0)
{
jsonModel.Status = "cf";
jsonModel.Msg = "当前课程下已经有此实验！";
}
else
{
int result = dal.Update(Model);
if (result == 0)
{
jsonModel.Status = "no";
jsonModel.Msg = "添加失败";
}
else
{
jsonModel.Status = "ok";
jsonModel.Msg = "添加成功";
}
}
return(jsonModel);
#region MyRegion
//string[] ClassId = ht["Class"].ToString().Split(',');
//if (string.IsNullOrWhiteSpace(ht["Class"].ToString()))
//{
// ClassId = new string[0];
//}
////定义JSON标准格式实体中
//JsonModel jsonModel = new JsonModel();
////事务
//using (SqlTransaction trans = dal.GetTran())
//{
// try
// {
// int result = dal.Update(trans, Model);
// if (result == 0)
// {
// //回滚
// trans.Rollback();
// jsonModel.Status = "no";
// jsonModel.Msg = "修改失败";
// return jsonModel;
// }
// EmsDAL.ExperimentClassInfo DALEC = new EmsDAL.ExperimentClassInfo();
// //清除实验班级
// DALEC.DeleteEC(trans, Id);
// int AddCount = 0;
// foreach (string id in ClassId)
// {
// EmsModel.ExperimentClassInfo ModelEC = new EmsModel.ExperimentClassInfo();
// ModelEC.ExperimentId = Id;
// ModelEC.ClassId = Convert.ToInt32(id);
// int resultEC = DALEC.Add(trans, ModelEC);
// if (resultEC > 0)
// {
// AddCount++;
// }
// }
// if (ClassId.Length != AddCount)
// {
// //回滚
// trans.Rollback();
// jsonModel.Status = "no";
// jsonModel.Msg = "班级保存失败";
// }
// else
// {
// //提交
// trans.Commit();
// jsonModel.Status = "ok";
// jsonModel.Msg = "修改成功";
// }
// return jsonModel;
// }
// catch (Exception)
// {
// //回滚
// trans.Rollback();
// throw;
// }
//}
#endregion
}
catch (Exception ex)
{
JsonModel jsonModel = new JsonModel();
jsonModel.Status = "error";
jsonModel.Msg = ex.ToString();
return(jsonModel);
}
}
