public static object updatecertificate(string _uid, string _pwd, string postString, ref string error) { Entity.MsSQL.T_MarkUser _user = Dal.MsSQL.T_MarkUser.GetModel(_uid, _pwd); if (_user != null) { Entity.Request.addcertificate _certificate = Untity.HelperJson.DeserializeObject <Entity.Request.addcertificate>(postString); Entity.MsSQL.T_Certificate _model = new Entity.MsSQL.T_Certificate() { Id = Untity.HelperDataCvt.strToLong(_certificate.Id), CategoryName = _certificate.CategoryName, ExamSubject = _certificate.ExamSubject, StartTime = Untity.HelperDataCvt.strToDatetime(_certificate.StartTime), EndTime = Untity.HelperDataCvt.strToDatetime(_certificate.EndTime), Describe = _certificate.Describe, ExamResult = _certificate.ExamResult, NormalResult = _certificate.NormalResult }; return(Dal.MsSQL.T_Certificate.Update(_model).ToString()); } else { error = "账号失效,请重新登陆"; return("-1"); } }
public static object delcertificate(string _uid, string _pwd, string postString, ref string error) { Entity.MsSQL.T_MarkUser _user = Dal.MsSQL.T_MarkUser.GetModel(_uid, _pwd); if (_user != null) { Entity.Request.addcertificate _certificate = Untity.HelperJson.DeserializeObject <Entity.Request.addcertificate>(postString); var result = Dal.MsSQL.T_StudentTicket.GetStudentCountByCertificateId(_certificate.Id); if (result == 0) { //Dal.MsSQL.T_CertifiSubject.Delete(Untity.HelperDataCvt.objToString(_certificate.Id)); //return "0"; Dal.MsSQL.T_Certificate.Delete(Untity.HelperDataCvt.objToString(_certificate.Id)); return("0"); } else { return("1"); } } else { error = "账号失效,请重新登陆"; return("-1"); } }
public static object addcertificate(string _uid, string _pwd, string postString, ref string error) { Entity.MsSQL.T_MarkUser _user = Dal.MsSQL.T_MarkUser.GetModel(_uid, _pwd); if (_user != null) { Entity.Request.addcertificate _certificate = Untity.HelperJson.DeserializeObject <Entity.Request.addcertificate>(postString); Entity.MsSQL.T_Certificate _model = new Entity.MsSQL.T_Certificate() { CategoryName = _certificate.CategoryName, ExamSubject = _certificate.ExamSubject, StartTime = Untity.HelperDataCvt.strToDatetime(_certificate.StartTime), EndTime = Untity.HelperDataCvt.strToDatetime(_certificate.EndTime), Describe = _certificate.Describe, ExamResult = _certificate.ExamResult, NormalResult = _certificate.NormalResult }; long _id = Dal.MsSQL.T_Certificate.Add(_model); if (!string.IsNullOrEmpty(_certificate.SubjectIds)) { foreach (var _subjcetid in _certificate.SubjectIds.Split(',')) { Entity.MsSQL.T_CertifiSubject _subject = new Entity.MsSQL.T_CertifiSubject() { }; } } return(_id.ToString()); } else { error = "账号失效,请重新登陆"; return("-1"); } }