public string GetEmployee(EmployeeModel employeeModel)
{
employeeModel.Sqlprms = new SqlParameter[2];
employeeModel.Sqlprms[0] = new SqlParameter("@EmployeeCD", employeeModel.EmployeeCD);
employeeModel.Sqlprms[1] = new SqlParameter("@EmployeeName", employeeModel.EmployeeName);
return(cKMDL.SelectJson("Employee_Select", ff.GetConnectionWithDefaultPath("PJMS"), employeeModel.Sqlprms));
}
public string GetProject(ProjectModel projectModel)
{
projectModel.Sqlprms = new SqlParameter[3];
projectModel.Sqlprms[0] = new SqlParameter("@ProjectCD", projectModel.ProjectCD);
projectModel.Sqlprms[1] = new SqlParameter("@ProjectName", projectModel.ProjectName);
projectModel.Sqlprms[2] = new SqlParameter("@ProjectType", projectModel.ProjectTypeCD);
return(cKMDL.SelectJson("Project_Select", ff.GetConnectionWithDefaultPath("PJMS"), projectModel.Sqlprms));
}
public string GetProgress(ProgressModel progressModel)
{
progressModel.Sqlprms = new SqlParameter[1];
progressModel.Sqlprms[0] = new SqlParameter("@ProgressCD", progressModel.ProgressCD);
//progressModel.Sqlprms[0] = new SqlParameter("@ProgressRate", progressModel.ProgressRate);
return(cKMDL.SelectJson("Progress_Select", ff.GetConnectionWithDefaultPath("PJMS"), progressModel.Sqlprms));
}
public string GetUser(UserModel userModel)
{
userModel.Sqlprms = new SqlParameter[2];
userModel.Sqlprms[0] = new SqlParameter("@UserID", userModel.UserID);
userModel.Sqlprms[1] = new SqlParameter("@Password", userModel.Password);
return(cKMDL.SelectJson("User_Select", ff.GetConnectionWithDefaultPath("PJMS"), userModel.Sqlprms));
}
public string M_Message_Select(MessageModel Mmodel)
{
Mmodel.Sqlprms = new SqlParameter[1];
Mmodel.Sqlprms[0] = new SqlParameter("@MessageID", Mmodel.MessageID);
return(cKMDL.SelectJson("M_Message_Select", ff.GetConnectionWithDefaultPath("PJMS"), Mmodel.Sqlprms));
}