/// <summary>
/// 修改银行分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateBankInfo(BankInfoModel model)
{
if (model == null)
{
return(false);
}
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//登陆日志
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.CustNo);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = BankInfoDBHelper.UpdateBankInfo(model);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception)
{
return(false);
throw;
}
}
/// <summary>
/// 插入银行分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool InsertBankInfo(BankInfoModel model)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
if (model == null)
{
return(false);
}
//登陆日志
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.CustNo);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
succ = BankInfoDBHelper.InsertBankInfo(model);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex);
return(false);
}
}
public ActionResult GetbankInfo()
{
var token = GetUserToken();
if (string.IsNullOrEmpty(token))
{
return(Json(new { status = "UnAuthorized" }, JsonRequestBehavior.AllowGet));
}
BankInfoModel res = _userManager.GetBankInfo(token);
return(Json(new { res.BankName, res.BankAccountNo, res.BankCardNo, res.BankCardImageId, IsBankCardPicUploaded = (res.Base64BankCardPic != null) }));
}
/// <summary>
/// 获取银行信息
/// </summary>
/// <returns></returns>
public static DataTable GetBankInfo(BankInfoModel model, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT a.ID ");
sql.AppendLine(" ,a.CustNo ");
sql.AppendLine(" ,isnull(a.CustName,'')as CustName ");
sql.AppendLine(" ,isnull(a.CustNam,'') as CustNam ");
sql.AppendLine(" ,a.PYShort ");
sql.AppendLine(" ,a.ContactName ");
sql.AppendLine(" ,a.Tel ");
sql.AppendLine(" ,a.Fax ");
sql.AppendLine(" ,a.Mobile ");
sql.AppendLine(" ,a.Addr ");
sql.AppendLine(" ,a.Remark ");
sql.AppendLine(" ,a.UsedStatus ");
sql.AppendLine(" ,isnull(a.Creator,'') as Creator ");
sql.AppendLine(" ,isnull(b.EmployeeName,'') as CreaterName ");
sql.AppendLine(" ,isnull( CONVERT(CHAR(10), a.CreateDate, 23),'') as CreateDate ");
sql.AppendLine(" ,a.ModifiedDate ");
sql.AppendLine(" ,a.ModifiedUserID ");
sql.AppendLine(" FROM officedba.BankInfo as a left join officedba.EmployeeInfo as b on a.Creator =b.ID where a.CompanyCD=@CompanyCD ");
if (!string.IsNullOrEmpty(model.CustNo))
{
sql.AppendLine(" and a.CustNo LIKE @CustNo ");
}
if (!string.IsNullOrEmpty(model.CustName))
{
sql.AppendLine(" and a.CustName LIKE @CustName ");
}
if (!string.IsNullOrEmpty(model.UsedStatus))
{
sql.AppendLine(" and a.UsedStatus =@UsedStatus ");
}
if (!string.IsNullOrEmpty(model.ContactName))
{
sql.AppendLine(" and a.ContactName LIKE @ContactName ");
}
if (!string.IsNullOrEmpty(model.PYShort))
{
sql.AppendLine(" and a.PYShort like @PYShort ");
}
SqlParameter[] param = new SqlParameter[6];
param[0] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
param[1] = SqlHelper.GetParameter("@CustNo", "%" + model.CustNo + "%");
param[2] = SqlHelper.GetParameter("@UsedStatus", model.UsedStatus);
param[3] = SqlHelper.GetParameter("@CustName", "%" + model.CustName + "%");
param[4] = SqlHelper.GetParameter("@ContactName", "%" + model.ContactName + "%");
param[5] = SqlHelper.GetParameter("@PYShort", "%" + model.PYShort + "%");
DataTable dt = SqlHelper.CreateSqlByPageExcuteSql(sql.ToString(), pageIndex, pageCount, OrderBy, param, ref totalCount);
return(dt);
}
public ActionResult SubmitBankInfo(BankInfoModel model)
{
if (ModelState.IsValid)
{
var token = GetUserToken();
if (string.IsNullOrEmpty(token))
{
return(Json(new { status = "UnAuthorized" }, JsonRequestBehavior.AllowGet));
}
var res = _userManager.SubmitBankInfo(model, token);
return(Json(res, JsonRequestBehavior.AllowGet));
}
return(Json(new { uploaded = "ERROR", status = "WrongInfo" }, JsonRequestBehavior.AllowGet));
}
public BankInfoModel GetBankInfo(string token)
{
var client = new RestClient(ApiUrl);
var request = new RestRequest("GetBankInfo", Method.POST);
request.AddHeader("Authorization", "Bearer " + token);
IRestResponse response = client.Execute(request);
JavaScriptSerializer js = new JavaScriptSerializer();
BankInfoModel bankModel = new BankInfoModel();
if (!string.IsNullOrWhiteSpace(response.Content))
{
bankModel = js.Deserialize <BankInfoModel>(response.Content);
}
return(bankModel);
}
/// <summary>
/// 获取银行信息
/// </summary>
/// <returns></returns>
public static DataTable GetBankInfo(BankInfoModel model, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
if (model == null)
{
return(null);
}
try
{
return(BankInfoDBHelper.GetBankInfo(model, pageIndex, pageCount, OrderBy, ref totalCount));
}
catch (Exception)
{
return(null);
throw;
}
}
public ActionResult GetBankCardImage()
{
var token = GetUserToken();
if (string.IsNullOrEmpty(token))
{
return(Json(new { status = "UnAuthorized" }, JsonRequestBehavior.AllowGet));
}
BankInfoModel res = _userManager.GetBankInfo(token);
if (res.Base64BankCardPic != null)
{
var bytes = Convert.FromBase64String(res.Base64BankCardPic);
return(new FileContentResult(bytes, "image/jpeg"));
}
return(null);
}
/// <summary>
/// 修改银行信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateBankInfo(BankInfoModel model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE [officedba].[BankInfo] ");
sql.AppendLine(" SET ");
sql.AppendLine(" CustName = @CustName ");
sql.AppendLine(" ,CustNam = @CustNam ");
sql.AppendLine(" ,PYShort = @PYShort ");
sql.AppendLine(" ,ContactName = @ContactName ");
sql.AppendLine(" ,Tel = @Tel ");
sql.AppendLine(" ,Fax = @Fax ");
sql.AppendLine(" ,Mobile = @Mobile ");
sql.AppendLine(" ,Addr = @Addr ");
sql.AppendLine(" ,Remark = @Remark ");
sql.AppendLine(" ,UsedStatus = @UsedStatus ");
sql.AppendLine(" ,Creator = @Creator ");
sql.AppendLine(" ,CreateDate = @CreateDate ");
sql.AppendLine(" ,ModifiedDate = @ModifiedDate ");
sql.AppendLine(" ,ModifiedUserID =@ModifiedUserID ");
sql.AppendLine(" WHERE ID=@ID and CompanyCD=@CompanyCD ");
//设置参数
SqlParameter[] param = new SqlParameter[16];
int i = 0;
param[i++] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
param[i++] = SqlHelper.GetParameter("@ID", model.ID);
param[i++] = SqlHelper.GetParameter("@CustNam", model.CustNam);
param[i++] = SqlHelper.GetParameter("@CustName", model.CustName);
param[i++] = SqlHelper.GetParameter("@PYShort", model.PYShort);
param[i++] = SqlHelper.GetParameter("@ContactName", model.ContactName);
param[i++] = SqlHelper.GetParameter("@Tel", model.Tel);
param[i++] = SqlHelper.GetParameter("@Fax", model.Fax);
param[i++] = SqlHelper.GetParameter("@Mobile", model.Mobile);
param[i++] = SqlHelper.GetParameter("@Addr", model.Addr);
param[i++] = SqlHelper.GetParameter("@Remark", model.Remark);
param[i++] = SqlHelper.GetParameter("@UsedStatus", model.UsedStatus);
param[i++] = SqlHelper.GetParameter("@Creator", model.Creator);
param[i++] = SqlHelper.GetParameter("@CreateDate", model.CreateDate);
param[i++] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now);
param[i++] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID);
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return(SqlHelper.Result.OprateCount > 0 ? true : false);
}
public RequestReponse SubmitBankInfo(BankInfoModel model, string token)
{
var client = new RestClient(ApiUrl);
var request = new RestRequest("InsertBankInfo", Method.POST);
request.AddHeader("Authorization", "Bearer " + token);
request.AddHeader("Content-Type", "multipart/form-data");
request.AddParameter("BankName", model.BankName);
request.AddParameter("BankAccountNo", model.BankAccountNo);
request.AddParameter("BankCardNo", model.BankCardNo);
IRestResponse response = client.Execute(request);
JavaScriptSerializer js = new JavaScriptSerializer();
RequestReponse bankInfoResponseModel = new RequestReponse();
if (!string.IsNullOrWhiteSpace(response.Content))
{
bankInfoResponseModel = js.Deserialize <RequestReponse>(response.Content);
}
return(bankInfoResponseModel);
}
/// <summary>
/// 插入银行分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool InsertBankInfo(BankInfoModel model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO [officedba].[BankInfo]");
sql.AppendLine(" (CompanyCD ");
sql.AppendLine(" ,BigType ");
sql.AppendLine(" ,CustNo ");
sql.AppendLine(" ,CustName ");
sql.AppendLine(" ,CustNam ");
sql.AppendLine(" ,PYShort ");
sql.AppendLine(" ,ContactName ");
sql.AppendLine(" ,Tel ");
sql.AppendLine(" ,Fax ");
sql.AppendLine(" ,Mobile ");
sql.AppendLine(" ,Addr ");
sql.AppendLine(" ,Remark ");
sql.AppendLine(" ,UsedStatus ");
sql.AppendLine(" ,Creator ");
sql.AppendLine(" ,CreateDate ");
sql.AppendLine(" ,ModifiedDate ");
sql.AppendLine(" ,ModifiedUserID) ");
sql.AppendLine(" VALUES ");
sql.AppendLine(" (@CompanyCD ");
sql.AppendLine(" ,@BigType ");
sql.AppendLine(" ,@CustNo ");
sql.AppendLine(" ,@CustName ");
sql.AppendLine(" ,@CustNam ");
sql.AppendLine(" ,@PYShort ");
sql.AppendLine(" ,@ContactName ");
sql.AppendLine(" ,@Tel ");
sql.AppendLine(" ,@Fax ");
sql.AppendLine(" ,@Mobile ");
sql.AppendLine(" ,@Addr ");
sql.AppendLine(" ,@Remark ");
sql.AppendLine(" ,@UsedStatus ");
sql.AppendLine(" ,@Creator ");
sql.AppendLine(" ,@CreateDate ");
sql.AppendLine(" ,@ModifiedDate ");
sql.AppendLine(" ,@ModifiedUserID)");
//设置参数
SqlParameter[] param = new SqlParameter[17];
int i = 0;
param[i++] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
param[i++] = SqlHelper.GetParameter("@BigType", ConstUtil.BankTypeFlag);
param[i++] = SqlHelper.GetParameter("@CustNo", model.CustNo);
param[i++] = SqlHelper.GetParameter("@CustName", model.CustName);
param[i++] = SqlHelper.GetParameter("@CustNam", model.CustNam);
param[i++] = SqlHelper.GetParameter("@PYShort", model.PYShort);
param[i++] = SqlHelper.GetParameter("@ContactName", model.ContactName);
param[i++] = SqlHelper.GetParameter("@Tel", model.Tel);
param[i++] = SqlHelper.GetParameter("@Fax", model.Fax);
param[i++] = SqlHelper.GetParameter("@Mobile", model.Mobile);
param[i++] = SqlHelper.GetParameter("@Addr", model.Addr);
param[i++] = SqlHelper.GetParameter("@Remark", model.Remark);
param[i++] = SqlHelper.GetParameter("@UsedStatus", model.UsedStatus);
param[i++] = SqlHelper.GetParameter("@Creator", model.Creator == null
? SqlInt32.Null
: SqlInt32.Parse(model.Creator.ToString()));
param[i++] = SqlHelper.GetParameter("@CreateDate", model.CreateDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(model.CreateDate.ToString()));
param[i++] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now);
param[i++] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID);
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return(SqlHelper.Result.OprateCount > 0 ? true : false);
}
