public string AddInf4WF(CourtInf v)
{
string wramStr = "";
if (v.CNumber == "" || v.CNumber == null)
{
wramStr = "法院编号不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
if (v.CName == "" || v.CName == null)
{
wramStr = "法院名称不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
if (v.CLinkman == "" || v.CLinkman == null)
{
wramStr = "联系人不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
if (v.CWorkTelephone == "" || v.CWorkTelephone == null)
{
wramStr = "单位电话不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
string linkman = v.CLinkman.Replace(" ", "+");
string workTelephone = v.CWorkTelephone.Replace(" ", "+");
string p = "";
p += "CNumber=" + v.CNumber;
p += "&CName=" + v.CName;
p += "&CLinkman=" + v.CLinkman;
p += "&CWorkTelephone=" + workTelephone;
p += "&CAddress=" + v.CAddress;
p += "&CLongitude=" + v.CLongitude;
p += "&CLatitude=" + v.CLatitude;
string md5Ciphertext = v.CMD5Ciphertext;//对方传过来的所有字段的MD5密文
//把传过来的信息再次MD5加密，和所有字段的MD5密文进行比对，保证数据在传输过程中没被修改才允许添加到数据库
string md5P = MD5Helper._md5(p);
if (md5Ciphertext == md5P)
{
string sql = "insert into T_CourtInf(CNumber, CName, CLinkman, CWorkTelephone, CAddress, CLongitude, CLatitude) values(@CNumber, @CName, @CLinkman, @WorkTelephone, @CAddress, @CLongitude, @CLatitude)";
workTelephone = RSAHelper.DecryptWithPrivateKey(privateKey, workTelephone);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@CNumber", SqlDbType.NVarChar)
{
Value = v.CNumber
},
new SqlParameter("@CName", SqlDbType.NVarChar)
{
Value = v.CName
},
new SqlParameter("@CLinkman", SqlDbType.NVarChar)
{
Value = RSAHelper.DecryptWithPrivateKey(privateKey, linkman)
},
new SqlParameter("@CWorkTelephone", SqlDbType.NVarChar)
{
Value = RSAHelper.DecryptWithPrivateKey(privateKey, workTelephone)
},
new SqlParameter("@CAddress", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.CAddress)
},
new SqlParameter("@CLongitude", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.CLongitude)
},
new SqlParameter("@CLatitude", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.CLatitude)
}
};
try
{
int result = SQLHelper.ExecuteNonQuery(sql, System.Data.CommandType.StoredProcedure, pms);
return(ConvertHelper.IntToJson(result));
}
catch (Exception e)
{
//在webapi中要想抛出异常必须这样抛出，否则只抛出一个默认500的异常
var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError)
{
Content = new StringContent(e.ToString()),
ReasonPhrase = "error"
};
throw new HttpResponseException(resp);
}
}
else
{
return(ConvertHelper.resultJson(0, "数据传输过程中被篡改"));
}
}
public string AddInf(VisitorAccessInf v)
{
string wramStr = "";
if (v.VName == "" || v.VName == null)
{
wramStr = "姓名不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
if (v.VAddress == "" || v.VAddress == null)
{
wramStr = "身份证中的住址不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
if (v.VCertificateNumber == "" || v.VCertificateNumber == null)
{
wramStr = "证件号不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
//数据在传输过程中，密文中的“+”号会被替换合成“ ”空格号，把它还原回来
string name = v.VName.Replace(" ", "+");
string address = v.VAddress.Replace(" ", "+");
string certificateNumber = v.VCertificateNumber.Replace(" ", "+");
string p = "";
p += "VName=" + name;
p += "&VSex=" + v.VSex;
p += "&VNation=" + v.VNation;
p += "&VBirthDate=" + v.VBirthDate;
p += "&VAddress=" + address;
p += "&VIssuingAuthority=" + v.VIssuingAuthority;
p += "&VExpiryDate=" + v.VExpiryDate;
p += "&VCertificatePhoto=" + DataHelper.IsNullReturnLine(v.VCertificatePhoto, true);
p += "&VLocalePhoto=" + DataHelper.IsNullReturnLine(v.VLocalePhoto, true);
p += "&VCertificateType=" + v.VCertificateType;
p += "&VCertificateNumber=" + certificateNumber;
p += "&VType=" + v.VType;
p += "&VFromCourtId=" + v.VFromCourtId;
p += "&VInTime=" + v.VInTime;
p += "&VOutTime=" + v.VOutTime;
p += "&VInPost=" + v.VInPost;
p += "&VOutPost=" + v.VOutPost;
p += "&VInDoorkeeper=" + v.VInDoorkeeper;
p += "&VOutDoorkeeper=" + v.VOutDoorkeeper;
p += "&VVisitingReason=" + v.VVisitingReason;
p += "&VIntervieweeDept=" + v.VIntervieweeDept;
p += "&VInterviewee=" + v.VInterviewee;
p += "&VOffice=" + v.VOffice;
p += "&VOfficePhone=" + v.VOfficePhone;
p += "&VExtensionPhone=" + v.VExtensionPhone;
p += "&VMobilePhone=" + v.VMobilePhone;
p += "&VRemark=" + v.VRemark;
string md5Ciphertext = v.VMD5Ciphertext;//对方传过来的所有字段的MD5密文
//把传过来的信息再次MD5加密，和所有字段的MD5密文进行比对，保证数据在传输过程中没被修改才允许添加到数据库
string md5P = MD5Helper._md5(p);
if (md5Ciphertext == md5P)
{
string sql = "sp_addVisitorAccessInf";
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@VName", SqlDbType.NVarChar)
{
Value = RSAHelper.DecryptWithPrivateKey(privateKey, name)
},
new SqlParameter("@VSex", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VSex)
},
new SqlParameter("@VNation", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VNation)
},
new SqlParameter("@VBirthDate", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VBirthDate)
},
new SqlParameter("@VAddress", SqlDbType.NVarChar)
{
Value = RSAHelper.DecryptWithPrivateKey(privateKey, address)
},
new SqlParameter("@VIssuingAuthority", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VIssuingAuthority)
},
new SqlParameter("@VExpiryDate", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VExpiryDate)
},
new SqlParameter("@VCertificatePhoto", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VCertificatePhoto, true)
},
new SqlParameter("@VLocalePhoto", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VLocalePhoto, true)
},
new SqlParameter("@VCertificateType", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VCertificateType)
},
new SqlParameter("@VCertificateNumber", SqlDbType.NVarChar)
{
Value = RSAHelper.DecryptWithPrivateKey(privateKey, certificateNumber)
},
new SqlParameter("@VType", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VType)
},
new SqlParameter("@VFromCourtId", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VFromCourtId)
},
new SqlParameter("@VInTime", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VInTime)
},
new SqlParameter("@VOutTime", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VOutTime)
},
new SqlParameter("@VInPost", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VInPost)
},
new SqlParameter("@VOutPost", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VOutPost)
},
new SqlParameter("@VInDoorkeeper", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VInDoorkeeper)
},
new SqlParameter("@VOutDoorkeeper", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VOutDoorkeeper)
},
new SqlParameter("@VVisitingReason", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VVisitingReason)
},
new SqlParameter("@VIntervieweeDept", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VIntervieweeDept)
},
new SqlParameter("@VInterviewee", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VInterviewee)
},
new SqlParameter("@VOffice", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VOffice)
},
new SqlParameter("@VOfficePhone", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VOfficePhone)
},
new SqlParameter("@VExtensionPhone", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VExtensionPhone)
},
new SqlParameter("@VMobilePhone", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VMobilePhone)
},
new SqlParameter("@VRemark", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.VRemark)
}
};
try
{
int result = SQLHelper.ExecuteNonQuery(sql, System.Data.CommandType.StoredProcedure, pms);
return(ConvertHelper.IntToJson(result));
}
catch (Exception e)
{
//在webapi中要想抛出异常必须这样抛出，否则只抛出一个默认500的异常
var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError)
{
Content = new StringContent(e.ToString()),
ReasonPhrase = "error"
};
throw new HttpResponseException(resp);
}
}
else
{
return(ConvertHelper.resultJson(0, "数据传输过程中被篡改"));
}
}
public string AddInf4WF(LawyerInf v)
{
string wramStr = "";
if (v.LName == "" || v.LName == null)
{
wramStr = "姓名不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
if (v.LIdentityNumber == "" || v.LIdentityNumber == null)
{
wramStr = "身份证号不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
//数据在传输过程中，密文中的“+”号会被替换合成“ ”空格号，把它还原回来
string name = v.LName.Replace(" ", "+");
string identityNumber = v.LIdentityNumber.Replace(" ", "+");
string photo = DataHelper.IsNullReturnLine(v.LPhoto, true);
string p = "";
p += "LName=" + name;
p += "&LSex=" + v.LSex;
p += "&LPhoto=" + photo;
p += "&LIdentityNumber=" + identityNumber;
p += "&LActuator=" + v.LActuator;
p += "&LPCType=" + v.LPCType;
p += "&LPCNumber=" + v.LPCNumber;
p += "&LQualifityNumber=" + v.LQualifityNumber;
p += "&LIssuingAuthority=" + v.LIssuingAuthority;
p += "&LIssuingDate=" + v.LIssuingDate;
p += "&LInTime=" + v.LInTime;
p += "&LFromCourtId=" + v.LFromCourtId;
p += "&LRemark=" + v.LRemark;
string md5Ciphertext = v.LMD5Ciphertext;//对方传过来的所有字段的MD5密文
//把传过来的信息再次MD5加密，和所有字段的MD5密文进行比对，保证数据在传输过程中没被修改才允许添加到数据库
string md5P = MD5Helper._md5(p);
if (md5Ciphertext == md5P)
{
string sql1 = "select count(*) from T_LawyerInf where LIdentityNumber=@LIdentityNumber";
SqlParameter[] pms1 = new SqlParameter[] {
new SqlParameter("@LIdentityNumber", SqlDbType.NVarChar)
{
Value = RSAHelper.DecryptWithPrivateKey(privateKey, identityNumber)
}
};
try
{
object c = SQLHelper.ExecuteScalar(sql1, System.Data.CommandType.Text, pms1);
if (Convert.ToInt32(c) > 0)
{
return(ConvertHelper.resultJson(0, "数据库中已存在此身份证号，请勿重复添加！"));
}
else
{
string sql = "sp_addLawyerInf";
name = RSAHelper.DecryptWithPrivateKey(privateKey, name);
identityNumber = RSAHelper.DecryptWithPrivateKey(privateKey, identityNumber);
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@LName", SqlDbType.NVarChar)
{
Value = name
},
new SqlParameter("@LSex", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.LSex)
},
new SqlParameter("@LPhoto", SqlDbType.NVarChar)
{
Value = photo
},
new SqlParameter("@LIdentityNumber", SqlDbType.NVarChar)
{
Value = identityNumber
},
new SqlParameter("@LActuator", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.LActuator)
},
new SqlParameter("@LPCType", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.LPCType)
},
new SqlParameter("@LPCNumber", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.LPCNumber)
},
new SqlParameter("@LQualifityNumber", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.LQualifityNumber)
},
new SqlParameter("@LIssuingAuthority", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.LIssuingAuthority)
},
new SqlParameter("@LIssuingDate", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.LIssuingDate)
},
new SqlParameter("@LInTime", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.LInTime)
},
new SqlParameter("@LFromCourtId", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.LFromCourtId)
},
new SqlParameter("@LRemark", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.LRemark)
}
};
try
{
int result = SQLHelper.ExecuteNonQuery(sql, System.Data.CommandType.StoredProcedure, pms);
return(ConvertHelper.IntToJson(result));
}
catch (Exception e)
{
//在webapi中要想抛出异常必须这样抛出，否则只抛出一个默认500的异常
var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError)
{
Content = new StringContent(e.ToString()),
ReasonPhrase = "error"
};
throw new HttpResponseException(resp);
}
}
}
catch (Exception e)
{
//在webapi中要想抛出异常必须这样抛出，否则之抛出一个默认500的异常
var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError)
{
Content = new StringContent(e.ToString()),
ReasonPhrase = "error"
};
throw new HttpResponseException(resp);
}
}
else
{
return(ConvertHelper.resultJson(0, "数据传输过程中被篡改"));
}
}
public string AddInf4WF(BlacklistInf v)
{
string wramStr = "";
if (v.BName == "" || v.BName == null)
{
wramStr = "姓名不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
if (v.BAddress == "" || v.BAddress == null)
{
wramStr = "身份证中的住址不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
if (v.BCertificateNumber == "" || v.BCertificateNumber == null)
{
wramStr = "证件号不能为空";
return("{\"code\":0,\"msg\":\"" + wramStr + "\"}");
}
//数据在传输过程中，密文中的“+”号会被替换合成“ ”空格号，把它还原回来
string name = v.BName.Replace(" ", "+");
string address = v.BAddress.Replace(" ", "+");
string certificateNumber = v.BCertificateNumber.Replace(" ", "+");
string p = "";
p += "BName=" + name;
p += "&BSex=" + v.BSex;
p += "&BNation=" + v.BNation;
p += "&BBirthDate=" + v.BBirthDate;
p += "&BAddress=" + address;
p += "&BIssuingAuthority=" + v.BIssuingAuthority;
p += "&BExpiryDate=" + v.BExpiryDate;
p += "&BCertificatePhoto=" + DataHelper.IsNullReturnLine(v.BCertificatePhoto, true);
p += "&BLocalePhoto=" + DataHelper.IsNullReturnLine(v.BLocalePhoto, true);
p += "&BCertificateType=" + v.BCertificateType;
p += "&BCertificateNumber=" + certificateNumber;
p += "&BCreateTime=" + v.BCreateTime;
p += "&BFromCourtId=" + v.BFromCourtId;
p += "&BLevel=" + v.BLevel;
p += "&BRemark=" + v.BRemark;
string md5Ciphertext = v.BMD5Ciphertext;//对方传过来的所有字段的MD5密文
//把传过来的信息再次MD5加密，和所有字段的MD5密文进行比对，保证数据在传输过程中没被修改才允许添加到数据库
string md5P = MD5Helper._md5(p);
if (md5Ciphertext == md5P)
{
string sql1 = "select count(*) from T_BlacklistInf where BCertificateNumber=@BCertificateNumber";
SqlParameter[] pms1 = new SqlParameter[] {
new SqlParameter("@BCertificateNumber", SqlDbType.NVarChar)
{
Value = RSAHelper.DecryptWithPrivateKey(privateKey, certificateNumber)
}
};
try
{
object c = SQLHelper.ExecuteScalar(sql1, System.Data.CommandType.Text, pms1);
if (Convert.ToInt32(c) > 0)
{
return(ConvertHelper.resultJson(0, "数据库中已存在此证件号，请勿重复添加！"));
}
else
{
string sql = "sp_addBlacklistInf";
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@BName", SqlDbType.NVarChar)
{
Value = RSAHelper.DecryptWithPrivateKey(privateKey, name)
},
new SqlParameter("@BSex", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BSex)
},
new SqlParameter("@BNation", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BNation)
},
new SqlParameter("@BBirthDate", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BBirthDate)
},
new SqlParameter("@BAddress", SqlDbType.NVarChar)
{
Value = RSAHelper.DecryptWithPrivateKey(privateKey, address)
},
new SqlParameter("@BIssuingAuthority", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BIssuingAuthority)
},
new SqlParameter("@BExpiryDate", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BExpiryDate)
},
new SqlParameter("@BCertificatePhoto", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BCertificatePhoto, true)
},
new SqlParameter("@BLocalePhoto", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BLocalePhoto, true)
},
new SqlParameter("@BCertificateType", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BCertificateType)
},
new SqlParameter("@BCertificateNumber", SqlDbType.NVarChar)
{
Value = RSAHelper.DecryptWithPrivateKey(privateKey, certificateNumber)
},
new SqlParameter("@BCreateTime", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BCreateTime)
},
new SqlParameter("@BFromCourtId", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BFromCourtId)
},
new SqlParameter("@BLevel", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BLevel)
},
new SqlParameter("@BRemark", SqlDbType.NVarChar)
{
Value = DataHelper.IsNullReturnLine(v.BRemark)
}
};
try
{
int result = SQLHelper.ExecuteNonQuery(sql, System.Data.CommandType.StoredProcedure, pms);
return(ConvertHelper.IntToJson(result));
}
catch (Exception e)
{
//在webapi中要想抛出异常必须这样抛出，否则只抛出一个默认500的异常
var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError)
{
Content = new StringContent(e.ToString()),
ReasonPhrase = "error"
};
throw new HttpResponseException(resp);
}
}
}
catch (Exception e)
{
//在webapi中要想抛出异常必须这样抛出，否则只抛出一个默认500的异常
var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError)
{
Content = new StringContent(e.ToString()),
ReasonPhrase = "error"
};
throw new HttpResponseException(resp);
}
}
else
{
return(ConvertHelper.resultJson(0, "数据传输过程中被篡改"));
}
}