public string SaveDepartment(Common_Department objDepartment)
{
string rv = "";
try
{
Insert_Update_Department("sp_Insert_Department", "saveDepartmentinfo", objDepartment);
rv = Operation.Success.ToString();
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public DataTable Insert_Update_Department(string procedure, string callname, Common_Department objDepartment)
{
dbConn = new SqlConnection(ConnectionString);
dbConn.Open();
cmd = new SqlCommand(procedure, dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@call_name", callname));
cmd.Parameters.Add(new SqlParameter("@p_DepartmentId", objDepartment.DepartmentID));
cmd.Parameters.Add(new SqlParameter("@p_DepartmentName", objDepartment.DepartmentName));
cmd.Parameters.Add(new SqlParameter("@p_DepartmentNameBan", objDepartment.DepartmentNameBan));
cmd.Parameters.Add(new SqlParameter("@p_IsActive", objDepartment.IsActive));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public string SaveDepartment(Common_Department objDepartment)
{
return(_dataService.SaveDepartment(objDepartment));
}
public ActionResult SaveDepartment(Common_Department objDepartment)
{
var res = _departmentRepository.SaveDepartment(objDepartment);
return(Json(res, JsonRequestBehavior.AllowGet));
}
protected override void Seed(EasySystemDBContext context)
{
Random r = new Random();
#region 部门数据
Common_Department[] departments = new Common_Department[]
{
new Common_Department()
{
DepartmentName = "市政分院"
},
new Common_Department()
{
DepartmentName = "建筑分院"
},
new Common_Department()
{
DepartmentName = "景观分院"
}
};
context.Common_Departments.AddRange(departments);
context.SaveChanges();
#endregion
#region 项目数据
for (int i = 1; i < 31; i++)
{
Business_Project project = new Business_Project()
{
ProjectName = "项目" + i,
ProjectLeader = "某某某",
Company = "建设单位" + i,
DesignNo = "2017S0" + i.ToString().PadLeft(2, '0')
};
context.Business_Projects.Add(project);
}
for (int i = 1; i < 31; i++)
{
Business_Project project = new Business_Project()
{
ProjectName = "项目" + (i + 30),
ProjectLeader = "某某某",
Company = "建设单位" + (i + 30),
DesignNo = "2017J0" + i.ToString().PadLeft(2, '0')
};
context.Business_Projects.Add(project);
}
context.SaveChanges();
#endregion
#region 业务类型
List <Business_ServiceType> serviceTypes = new List <Business_ServiceType>();
#endregion
#region 任务数据
List <Business_Task> tasks = new List <Business_Task>();
for (int i = 1; i < 31; i++)
{
tasks.Add(new Business_Task()
{
ProjectID = i,
DepartmentID = 1,
BusinessType = Common_BusinessType.Inside,
Contact = "某某某"
});
}
for (int i = 31; i < 61; i++)
{
tasks.Add(new Business_Task()
{
ProjectID = i,
DepartmentID = 2,
BusinessType = Common_BusinessType.Inside,
Contact = "某某某"
});
}
context.Business_Tasks.AddRange(tasks);
context.SaveChanges();
List <Business_TaskItem> taskItems = new List <Business_TaskItem>();
for (int i = 1; i < 31; i++)
{
taskItems.Add(new Business_TaskItem()
{
TaskID = i,
ItemName = "第一册",
Subject = "道路、景观、照明",
A1 = r.Next(1, 6),
A2 = r.Next(1, 21),
A3 = r.Next(80, 200),
Copies = 9
});
taskItems.Add(new Business_TaskItem()
{
TaskID = i,
ItemName = "第二册",
Subject = "排水",
A1 = r.Next(1, 6),
A2 = r.Next(1, 11),
A3 = r.Next(50, 100),
Copies = 9
});
taskItems.Add(new Business_TaskItem()
{
TaskID = i,
ItemName = "第三册",
Subject = "桥梁",
A2 = r.Next(1, 6),
A3 = r.Next(30, 70),
Copies = 9
});
}
for (int i = 31; i < 61; i++)
{
for (int j = 1; j < 6; j++)
{
taskItems.Add(new Business_TaskItem()
{
TaskID = i,
ItemName = j + "#栋",
Subject = "建筑",
A0 = r.Next(1, 6),
A1 = r.Next(10, 20),
Copies = 8
});
taskItems.Add(new Business_TaskItem()
{
TaskID = i,
ItemName = j + "#栋",
Subject = "结构",
A0 = r.Next(1, 6),
A1 = r.Next(10, 20),
Copies = 8
});
taskItems.Add(new Business_TaskItem()
{
TaskID = i,
ItemName = j + "#栋",
Subject = "给排水",
A0 = r.Next(1, 6),
A1 = r.Next(10, 20),
Copies = 8
});
taskItems.Add(new Business_TaskItem()
{
TaskID = i,
ItemName = j + "#栋",
Subject = "电气",
A0 = r.Next(1, 6),
A1 = r.Next(10, 20),
Copies = 8
});
taskItems.Add(new Business_TaskItem()
{
TaskID = i,
ItemName = j + "#栋",
Subject = "暖通",
A0 = r.Next(1, 6),
A1 = r.Next(10, 20),
Copies = 8
});
}
}
context.Business_TaskItems.AddRange(taskItems);
context.SaveChanges();
#endregion
base.Seed(context);
}
