public HttpResponseBase GetCertificateCategory()
{
string json = string.Empty;
int totalCount = 0;
List<CertificateCategoryQuery> stores = new List<CertificateCategoryQuery>();
CertificateCategoryQuery query = new CertificateCategoryQuery();
try
{
if (!string.IsNullOrEmpty(Request.Params["searchcontent"]))
{
query.searchcon = Request.Params["searchcontent"].ToString().Trim();
}
_inspectionReport = new InspectionReportMgr(mySqlConnectionString);
stores = _inspectionReport.GetCertificateCategoryList(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, Newtonsoft.Json.Formatting.Indented, timeConverter) + "}";//返回json數據
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public List<CertificateCategoryQuery> GetCertificateCategoryList(CertificateCategoryQuery query, out int totalCount)
{
try
{
return _inspectionReport.GetCertificateCategoryList(query, out totalCount);
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->GetCertificateCategoryList-->" + ex.Message, ex);
}
}
public int UpdateActive(CertificateCategoryQuery query)
{
try
{
return _inspectionReport.UpdateActive(query);
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->UpdateActive-->" + ex.Message, ex);
}
}
public int DeleteCertificateCategory(CertificateCategoryQuery query)
{
try
{
return _inspectionReport.DeleteCertificateCategory(query);
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->DeleteCertificateCategory-->" + ex.Message, ex);
}
}
public int UpdateActive(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("UPDATE certificate_category SET `status`='{0}' WHERE rowID='{1}'", query.status, query.rowID);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->UpdateActive-->" + ex.Message + sb.ToString(), ex);
}
}
public int CheckOnly(CertificateCategoryQuery query)
{
List<CertificateCategoryQuery> list = new List<CertificateCategoryQuery>();
try
{
list = _inspectionReport.CheckOnly(query);
return list.Count;
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->CheckOnly-->" + ex.Message , ex);
}
}
public List<CertificateCategoryQuery> CheckOnly(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat(" SELECT rowID FROM certificate_category WHERE certificate_categoryfid='{0}'", query.frowID);
return _access.getDataTableForObj<CertificateCategoryQuery>(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->CheckOnly-->" + ex.Message + sb.ToString(), ex);
}
}
public bool DeleteCCByTransaction(CertificateCategoryQuery query)
{
try
{
if (_inspectionReport.DeleteCCByTransaction(query) > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->DeleteCCByTransaction-->" + ex.Message, ex);
}
}
public List<CertificateCategoryQuery> GetCertificateCategoryList(CertificateCategoryQuery query, out int totalCount)
{
StringBuilder sb = new StringBuilder();
StringBuilder sbwhere = new StringBuilder();
StringBuilder sbcount = new StringBuilder();
totalCount = 0;
try
{
sb.AppendFormat(@" SELECT cc.rowID,cc.certificate_categoryname AS certificate_category_childname,cc.certificate_categorycode AS certificate_category_childcode,cc.certificate_categoryfid as frowID ,cc2.certificate_categoryname,cc2.certificate_categorycode,u.user_username as k_user_tostring,cc.k_date,cc.`status` ");
sbwhere.Append(" FROM certificate_category cc ");
sbwhere.AppendFormat(" LEFT JOIN (SELECT cc1.rowID,cc1.certificate_categoryname,cc1.certificate_categorycode,cc1.certificate_categoryfid FROM certificate_category cc1 WHERE cc1.certificate_categoryfid=0 ) cc2 ON cc2.rowID=cc.certificate_categoryfid ");
sbwhere.Append(" LEFT JOIN manage_user u ON u.user_id=cc.k_user ");
sbwhere.AppendFormat(" where cc.certificate_categoryfid<>0 ");
sbcount.Append(" select count(cc.rowID) as totalCount ");
if (!string.IsNullOrEmpty(query.searchcon))
{
sbwhere.AppendFormat(" and (cc.certificate_categoryname like N'%{0}%' OR cc.certificate_categorycode like N'%{0}%' or cc2.certificate_categoryname like N'%{0}%' OR cc2.certificate_categorycode like N'%{0}%') ",query.searchcon);
}
if (query.IsPage)
{
sbcount.Append(sbwhere.ToString());
DataTable dt = new DataTable();
dt = _access.getDataTable(sbcount.ToString());
if (dt != null && dt.Rows.Count > 0)
{
totalCount = Convert.ToInt32(dt.Rows[0]["totalCount"]);
}
}
sbwhere.AppendFormat(" limit {0},{1} ", query.Start, query.Limit);
sb.Append(sbwhere.ToString());
return _access.getDataTableForObj<CertificateCategoryQuery>(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->GetCertificateCategoryList-->" + ex.Message + sb.ToString(), ex);
}
}
public int DeleteCCByTransaction(CertificateCategoryQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(" DELETE FROM certificate_category WHERE rowID in ({0}); ", query.frowIDs);//刪除大類
MySqlConnection conn = new MySqlConnection(connStr);//在这里CONN_STRING也就是连接Mysql数据库的语句
conn.Open();//打开
MySqlCommand command = conn.CreateCommand();//在这里也可以写成MySqlCommand command=new MySqlCommand();
MySqlTransaction transaction = null;
transaction = conn.BeginTransaction(); //这两句也可以写成 MySqlTransaction transaction =new MySqlTransaction();
command.Connection = conn;
command.Transaction = transaction;
int count = 0;
try
{
command.CommandText = sql.ToString();
count = command.ExecuteNonQuery();
transaction.Commit(); //进行执行
}
catch
{
transaction.Rollback();//发生异常进行回滚
}
return count;
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->DeleteCCByTransaction-->" + ex.Message + sql.ToString(), ex);
}
}
public bool CheckCode(CertificateCategoryQuery query)
{
try
{
List<CertificateCategoryQuery> list = new List<Model.Query.CertificateCategoryQuery>();
list=_inspectionReport.CheckCode(query);
if (list != null && list.Count > 0)
{
return true;
}
else {
return false;
}
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->CheckCode-->" + ex.Message, ex);
}
}
public bool Update(CertificateCategoryQuery query)
{
try
{
int res = _inspectionReport.Update(query);
if (res > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->Update-->" + ex.Message, ex);
}
}
public int GetNewCertificateCategoryId(CertificateCategoryQuery query)
{
try
{
DataTable dt = _inspectionReport.GetNewCertificateCategoryId(query);
return Convert.ToInt32(dt.Rows[0][0]);
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->GetNewCertificateCategoryId-->" + ex.Message, ex);
}
}
public int DeleteCertificateCategory(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("DELETE FROM certificate_category WHERE rowID in ({0})", query.rowIDs);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->DeleteCertificateCategory-->" + ex.Message + sb.ToString(), ex);
}
}
public int UpdateCertificateCategory(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("UPDATE certificate_category SET certificate_categorycode='{0}' ", query.certificate_categorycode);
if (!string.IsNullOrEmpty(query.certificate_categoryname))
{
sb.AppendFormat(" ,certificate_categoryname='{0}' ", query.certificate_categoryname);
}
sb.AppendFormat(" WHERE rowID='{0}' ",query.frowID);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->UpdateCertificateCategory-->" + ex.Message + sb.ToString(), ex);
}
}
public int AddSave(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("INSERT INTO certificate_category (certificate_categoryname,certificate_categorycode,certificate_categoryfid,k_user,k_date,status) VALUES('{0}','{1}','{2}','{3}','{4}','{5}')", query.certificate_category_childname, query.certificate_category_childcode, query.frowID,query.k_user,Common.CommonFunction.DateTimeToString(query.k_date),1);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->AddSave-->" + ex.Message + sb.ToString(), ex);
}
}
public List<CertificateCategoryQuery> CheckBigCode(CertificateCategoryQuery query)
{
string folder = string.Empty;
try
{
return _inspectionReport.CheckCode(query);
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->CheckBigCode-->" + ex.Message, ex);
}
}
public List<CertificateCategoryQuery> GetLsit(CertificateCategoryQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(" SELECT cc.rowID FROM certificate_category cc WHERE cc.certificate_categoryfid='{0}' AND cc.certificate_categorycode='{1}';", query.frowID,query.certificate_category_childcode);
return _access.getDataTableForObj<CertificateCategoryQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->GetLsit-->" + sql.ToString() + ex.Message, ex);
}
}
public List<CertificateCategoryQuery> GetType2Store(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("SELECT cc.certificate_categoryname,cc.rowID AS frowID,cc.certificate_categorycode FROM certificate_category cc WHERE cc.certificate_categoryfid='{0}';", query.rowID);
return _access.getDataTableForObj<CertificateCategoryQuery>(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->GetType1Store-->" + ex.Message + sb.ToString(), ex);
}
}
public List<CertificateCategoryQuery> CheckCode(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.Append("SELECT cc.certificate_categoryname,cc.rowID FROM certificate_category cc WHERE 1=1");
if (!string.IsNullOrEmpty(query.certificate_categorycode))
{
sb.AppendFormat(" and cc.certificate_categorycode='{0}' ", query.certificate_categorycode);
}
else if (!string.IsNullOrEmpty(query.certificate_category_childcode))
{
sb.AppendFormat(" and cc.certificate_categorycode='{0}' ", query.certificate_category_childcode);
}
return _access.getDataTableForObj<CertificateCategoryQuery>(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->CheckCode-->" + ex.Message + sb.ToString(), ex);
}
}
public List<CertificateCategoryQuery> CheckChildName(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("SELECT cc.certificate_categoryname FROM certificate_category cc WHERE cc.certificate_categoryfid<>0 AND cc.certificate_categoryname='{0}'", query.certificate_category_childname);
return _access.getDataTableForObj<CertificateCategoryQuery>(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->CheckChildName-->" + ex.Message + sb.ToString(), ex);
}
}
public JsonResult UpdateActive()
{
try
{
CertificateCategoryQuery query = new CertificateCategoryQuery();
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
query.rowID = Convert.ToInt32(Request.Params["id"]);
}
if (!string.IsNullOrEmpty(Request.Params["active"]))
{
query.status = Convert.ToInt32(Request.Params["active"]);
}
_inspectionReport = new InspectionReportMgr(mySqlConnectionString);
int res = _inspectionReport.UpdateActive(query);
if (res > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
return Json(new { success = "false", msg = "" });
}
}
public bool BeforeDelete( string rowIDs)
{
string json = string.Empty;
bool b = false;
CertificateCategoryQuery query = new CertificateCategoryQuery();
try
{
if (rowIDs.IndexOf("|") != -1)
{
foreach (string id in rowIDs.Split('|'))
{
if (!string.IsNullOrEmpty(id))
{
string[] data = id.Split(',');
query = new CertificateCategoryQuery();
query.rowID = Convert.ToInt32(data[0]);
query.frowID = Convert.ToInt32(data[1]);
DataTable _dt = _inspectionReport.BeforeDelete(query);
if (_dt.Rows.Count > 0)
{
b = false;
break;
}
else
{
json = "{success:true,msg:'1'}";
b = true;
}
}
}
}
return b;
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->BeforeDelete-->" + ex.Message, ex);
}
}
public int Update(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("UPDATE certificate_category SET certificate_categorycode='{0}',certificate_categoryname='{1}',certificate_categoryfid='{2}' WHERE rowID='{3}'", query.certificate_category_childcode,query.certificate_category_childname,query.frowID,query.rowID);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->Update-->" + ex.Message + sb.ToString(), ex);
}
}
public List<CertificateCategoryQuery> GetLsit(CertificateCategoryQuery query)
{
string json = string.Empty;
DataTable _dt = new DataTable();
try
{
return _inspectionReport.GetLsit(query);
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->GetLsit-->" + ex.Message, ex);
}
}
public List<CertificateCategoryQuery> GetCertificateCategoryInfo(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("SELECT cc.certificate_categoryname,cc.certificate_categorycode,cc.rowID FROM certificate_category cc WHERE cc.rowID='{0}'",query.rowID);
//if (query.frowID > 0)
//{
// sb.AppendFormat(" and cc.certificate_categoryfid='{0}' ",query.frowID);
//}
return _access.getDataTableForObj<CertificateCategoryQuery>(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->GetCertificateCategoryInfo-->" + ex.Message + sb.ToString(), ex);
}
}
public DataTable BeforeDelete(CertificateCategoryQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(" select rowID from inspection_report where certificate_type1='{0}' and certificate_type2='{1}';",query.frowID,query.rowID);
return _access.getDataTable(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->BeforeDelete-->" + sql.ToString() + ex.Message, ex);
}
}
public DataTable GetNewCertificateCategoryId(CertificateCategoryQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("INSERT INTO certificate_category (certificate_categorycode,certificate_categoryfid,certificate_categoryname,k_user,k_date,status) VALUES('{0}','{1}','{2}','{3}','{4}','{5}');select @@identity", query.certificate_categorycode,query.frowID,query.certificate_categoryname,query.k_user,Common.CommonFunction.DateTimeToString(query.k_date),1);
return _access.getDataTable(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("InspectionReportDao-->GetNewCertificateCategoryId-->" + ex.Message + sb.ToString(), ex);
}
}
public List<CertificateCategoryQuery> GetStore(CertificateCategoryQuery query)
{
try
{
return _inspectionReport.GetStore(query);
}
catch (Exception ex)
{
throw new Exception("InspectionReportMgr-->GetStore-->" + ex.Message, ex);
}
}
public HttpResponseBase InspectionReportSave()
{
string json = string.Empty;
List<CertificateCategoryQuery> list = new List<CertificateCategoryQuery>();
List<CertificateCategoryQuery> oldlist = new List<CertificateCategoryQuery>();
List<CertificateCategoryQuery> oldbiglist = new List<CertificateCategoryQuery>();
_inspectionReport = new InspectionReportMgr(mySqlConnectionString);
try
{
CertificateCategoryQuery query = new CertificateCategoryQuery();
string fid = string.Empty;
if (!string.IsNullOrEmpty(Request.Params["frowname"]))
{
fid = Request.Params["frowname"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["rowID"]))
{
query.rowID = Convert.ToInt32(Request.Params["rowID"]);
}
if (!string.IsNullOrEmpty(Request.Params["frowID"]))
{
query.frowID = Convert.ToInt32(Request.Params["frowID"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["f_code"]))
{
query.certificate_categorycode = Request.Params["f_code"].ToString().ToUpper();
}
if (!string.IsNullOrEmpty(Request.Params["child_name"]))
{
query.certificate_category_childname = Request.Params["child_name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["child_code"]))
{
query.certificate_category_childcode = Request.Params["child_code"].ToString().ToUpper();
}
uint unum = 0;
if (uint.TryParse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(), out unum))
{
query.k_user = unum;
}
query.k_date = DateTime.Now;
int isnum = 0;
//查詢小類信息以供編輯時查重
CertificateCategoryQuery oldquery = new CertificateCategoryQuery();
oldquery.rowID = query.rowID;
oldlist = _inspectionReport.GetCertificateCategoryInfo(oldquery);
//查詢大類信息以供編輯時查重
CertificateCategoryQuery oldbigquery = new CertificateCategoryQuery();
oldbigquery.rowID = query.frowID;
oldbiglist = _inspectionReport.GetCertificateCategoryInfo(oldbigquery);
#region 編輯處理
if (query.rowID != 0)
{//編輯
#region 編輯時選擇大類非編輯大類
if (int.TryParse(fid, out isnum))//編輯選擇大類
{
bool res = true;
query.frowID = isnum;
query.certificate_categoryname = string.Empty;
if (oldbiglist.Count > 0 && oldbiglist[0].certificate_categorycode != query.certificate_categorycode)//檔大類code被編輯時
{
//檢查大類code是否重複
CertificateCategoryQuery bigquery = new CertificateCategoryQuery();
bigquery.certificate_categorycode = query.certificate_categorycode;
res = _inspectionReport.CheckCode(bigquery);
if (res)
{
json = "{success:true,type:1,msg:'證書-大類CODE不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
}
}
#endregion
#region 編輯時修改大類
else
{
query.certificate_categoryname = fid;
if (_inspectionReport.CheckCertificateCategoryName(query))
{
json = "{success:true,type:1,msg:'證書-大類名稱不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
//檢查大類code是否重複
if (oldbiglist.Count > 0 && oldbiglist[0].certificate_categorycode != query.certificate_categorycode)
{
CertificateCategoryQuery bigquery = new CertificateCategoryQuery();
bigquery.certificate_categorycode = query.certificate_categorycode;
if (_inspectionReport.CheckCode(bigquery))
{
json = "{success:true,type:1,msg:'證書-大類CODE不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
}
}
#endregion
#region 編輯時檔小類名稱修改時
if (oldlist.Count > 0 && oldlist[0].certificate_categoryname != query.certificate_category_childname)//證書-小類被修改
{
if (_inspectionReport.CheckChildName(query))//檔小類名稱存在時
{
json = "{success:true,type:1,msg:'證書-小類名稱不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
}
#endregion
#region 編輯時檔小類code修改時
if (oldlist[0].certificate_categorycode != query.certificate_category_childcode)//檔小類code被修改時
{
CertificateCategoryQuery smallquery = new CertificateCategoryQuery();
smallquery.certificate_categorycode = query.certificate_category_childcode;
if (_inspectionReport.CheckCode(smallquery))
{
json = "{success:true,type:1,msg:'證書-小類CODE不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
}
#endregion
#region 判斷大類小類code是否一樣
if (query.certificate_category_childcode == query.certificate_categorycode)
{
json = "{success:true,type:1,msg:'證書-小類名稱不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
#endregion
#region 更新大類
//更新大類
int istrue = _inspectionReport.UpdateCertificateCategory(query);
if (istrue <= 0)
{
json = "{success:true,type:0,msg:'證書-大類修改失敗!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
#endregion
#region 更新小類
if (_inspectionReport.Update(query))
{
json = "{success:true,type:0,msg:'修改成功!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
else
{
json = "{success:true,type:0,msg:'修改失敗!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
}
#endregion
#endregion
#region 新增處理
else
{ //新增
bool res = true;
#region 大類是選擇出來的
if (int.TryParse(fid, out isnum))
{
query.frowID = isnum;
//檢查證書-大類code是否重複
if (oldbiglist.Count > 0 && oldbiglist[0].certificate_categorycode != query.certificate_categorycode)//大類code被修改
{
CertificateCategoryQuery bigquery = new CertificateCategoryQuery();
bigquery.certificate_categorycode = query.certificate_categorycode;
res = _inspectionReport.CheckCode(bigquery);
if (res)
{
json = "{success:true,type:1,msg:'證書-大類CODE不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
}
//檢查小類名稱是否重複
res = _inspectionReport.CheckChildName(query);
if (res)
{
json = "{success:true,type:1,msg:'證書-小類名稱不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
//檢查小類code是否重複
CertificateCategoryQuery smallquery = new CertificateCategoryQuery();
smallquery.certificate_categorycode = query.certificate_category_childcode;
res = _inspectionReport.CheckCode(smallquery);
if (res)
{
json = "{success:true,type:1,msg:'證書-小類CODE不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
int num = _inspectionReport.UpdateCertificateCategory(query);//更新大類信息
if (num <= 0)
{
json = "{success:true,type:0,msg:'證書-大類新增失敗!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
#region 新增小類
if (_inspectionReport.AddSave(query) > 0)//新增保存
{
json = "{success:true,type:0,msg:'新增成功!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
else
{
json = "{success:true,type:0,msg:'新增失敗!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
#endregion
}
#endregion
#region 大類也是新增
else
{
query.certificate_categoryname = fid;
if (_inspectionReport.CheckCertificateCategoryName(query))
{
json = "{success:true,type:1,msg:'證書-大類名稱不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
CertificateCategoryQuery bigquery = new CertificateCategoryQuery();
bigquery.certificate_categorycode = query.certificate_categorycode;
if (_inspectionReport.CheckCode(bigquery))
{
json = "{success:true,type:1,msg:'證書-大類CODE不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
//檢查小類名稱是否重複
if (query.certificate_category_childcode == query.certificate_categorycode)
{
json = "{success:true,type:1,msg:'證書-小類名稱不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
res = _inspectionReport.CheckChildName(query);
if (res)
{
json = "{success:true,type:1,msg:'證書-小類名稱不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
//檢查小類code是否重複
CertificateCategoryQuery smallquery = new CertificateCategoryQuery();
smallquery.certificate_categorycode = query.certificate_category_childcode;
res = _inspectionReport.CheckCode(smallquery);
if (res)
{
json = "{success:true,type:1,msg:'證書-小類CODE不能重複!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
#region 新增大類
query.frowID = 0;
query.frowID = _inspectionReport.GetNewCertificateCategoryId(query);
if (query.frowID <= 0)
{
json = "{success:true,type:0,msg:'證書-大類新增失敗!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
#endregion
#region 新增小類
if (_inspectionReport.AddSave(query) > 0)//新增保存
{
json = "{success:true,type:0,msg:'新增成功!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
else
{
json = "{success:true,type:0,msg:'新增失敗!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
#endregion
}
#endregion
//#region 新增大類
//int num = _inspectionReport.UpdateCertificateCategory(query);//更新大類信息
//if (num <= 0)
//{
// json = "{success:true,type:0,msg:'證書-大類新增失敗!'}";
// this.Response.Clear();
// this.Response.Write(json);
// this.Response.End();
// return this.Response;
//}
//#endregion
}
#endregion
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
