/// <summary>
/// 验证机构名是否存在
/// </summary>
/// <param name="sysflag">系统标识</param>
/// <param name="cid">车辆id</param>
/// <returns>0:不重复;1：重复</returns>
private int OrgJudge(string sysflag, string orgnoname)
{
int res = 0;
try
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@OrgName", orgnoname)
};
res = Convert.ToInt32(csh.ExecuteSPScalar(sysflag, WebProc.Proc("ALProc_OrgJugde"), Parameters));
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
/// <summary>
/// 校验车辆信息是否更改
/// </summary>
/// <param name="cid">车辆ID</param>
/// <param name="carno">车牌号</param>
/// <returns>0：未更改；1：更改</returns>
private int IsCarChange(string sysflag, string cid, string carno)
{
int res = 0;
try
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@CID", cid),
new SqlParameter("@CarNo", carno)
};
res = Convert.ToInt32(csh.ExecuteSPScalar(sysflag, WebProc.Proc("ALProc_IsCarChange"), Parameters));
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
/// <summary>
/// 验证车辆ID是否重复
/// </summary>
/// <param name="sysflag">系统标识</param>
/// <param name="cid">车辆id</param>
/// <returns>0:不重复;1：重复</returns>
private int AddJudge(string sysflag, string cid)
{
int res = 0;
try
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@CID", cid)
};
res = Convert.ToInt32(csh.ExecuteSPScalar(sysflag, WebProc.Proc("ALProc_LoanInfo_Car_AddJugde"), Parameters));
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
/// <summary>
/// 新增机构
/// </summary>
/// <param name="sysflag">系统标识</param>
/// <param name="cid">机构名称</param>
/// <returns>0:不重复;1：重复</returns>
private int AddOrg(string sysflag, string orgnoname, string sysuid)
{
int res = 0;
try
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@OrgName", orgnoname),
new SqlParameter("@UserId", sysuid)
};
res = Convert.ToInt32(csh.ExecuteSPScalar(sysflag, WebProc.Proc("ALProc_InsertLoanOrg"), Parameters));
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
private int EditJudge(string sysflag, string cid, string carno, string dph, string fdjh, string cardno)
{
int res = 0;
try
{
ComSqlHelper csh = new ComSqlHelper();
SqlParameter[] Parameters =
{
new SqlParameter("@CID", cid),
new SqlParameter("@CarNo", carno),
new SqlParameter("@DPH", dph),
new SqlParameter("@FDJH", fdjh),
new SqlParameter("@CarDNo", cardno)
};
res = Convert.ToInt32(csh.ExecuteSPScalar(sysflag, WebProc.Proc("QWProc_Wm_Car_Edit_Judge"), Parameters));
}
catch (Exception ex)
{
throw ex;
}
return(res);
}