/// <summary> /// update /// </summary> /// <param name="OpenAccountRecord"></param> /// <returns></returns> public void Update(OpenAccountRecord model, SqlConnection connection = null, SqlTransaction transaction = null) { var str = GetUpdateStr(model); var dict = GetParameters(model); SqlHelper.Instance.ExcuteNon(str, dict, connection, transaction); }
/// <summary> /// add /// </summary> /// <param name="OpenAccountRecord"></param> /// <returns></returns> public int Add(OpenAccountRecord model, SqlConnection connection = null, SqlTransaction transaction = null) { var str = GetInsertStr(model) + " select @@identity"; var dict = GetParameters(model); return(Convert.ToInt32(SqlHelper.Instance.ExecuteScalar(str, dict, connection, transaction))); }
/// <summary> /// 新增开户记录 /// </summary> /// <param name="customer"></param> /// <param name="device"></param> /// <param name="recordId"></param> /// <param name="conn"></param> /// <param name="tran"></param> /// <returns></returns> public bool AddOpenAccountRecord(CustomerInfo customer, DeviceInfo device, out int recordId, SqlConnection conn, SqlTransaction tran) { recordId = 0; OpenAccountRecord model = new OpenAccountRecord { customerNo = customer.customerNo, customerType = customer.customerType, customerName = customer.customerName, estateNo = customer.estateNo, address = customer.address, meterNo = device.meterNo.ToString(), meterTypeNo = device.meterTypeNo, factoryNo = device.factoryNo, Opentime = DateTime.Now, OpenType = 0 }; recordId = Add(model, conn, tran); return(true); }
/// <summary> /// 插入 /// </summary> /// <param name="openaccountrecord"></param> /// <returns>是否成功</returns> public string GetInsertStr(OpenAccountRecord openaccountrecord) { StringBuilder part1 = new StringBuilder(); StringBuilder part2 = new StringBuilder(); if (openaccountrecord.customerNo != null) { part1.Append("customerNo,"); part2.Append("@customerNo,"); } if (openaccountrecord.customerType != null) { part1.Append("customerType,"); part2.Append("@customerType,"); } if (openaccountrecord.customerName != null) { part1.Append("customerName,"); part2.Append("@customerName,"); } if (openaccountrecord.estateNo != null) { part1.Append("estateNo,"); part2.Append("@estateNo,"); } if (openaccountrecord.address != null) { part1.Append("address,"); part2.Append("@address,"); } if (openaccountrecord.meterNo != null) { part1.Append("meterNo,"); part2.Append("@meterNo,"); } if (openaccountrecord.meterTypeNo != null) { part1.Append("meterTypeNo,"); part2.Append("@meterTypeNo,"); } if (openaccountrecord.factoryNo != null) { part1.Append("factoryNo,"); part2.Append("@factoryNo,"); } if (openaccountrecord.OpenType != null) { part1.Append("OpenType,"); part2.Append("@OpenType,"); } if (openaccountrecord.Opentime != null) { part1.Append("Opentime,"); part2.Append("@Opentime,"); } if (openaccountrecord.Operator != null) { part1.Append("Operator,"); part2.Append("@Operator,"); } if (openaccountrecord.BranchNo != null) { part1.Append("BranchNo,"); part2.Append("@BranchNo,"); } if (openaccountrecord.PosNo != null) { part1.Append("PosNo,"); part2.Append("@PosNo,"); } StringBuilder sql = new StringBuilder(); sql.Append("insert into openaccountrecord(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")"); return(sql.ToString()); }
/// <summary> /// 获取参数 /// </summary> /// <param name="openaccountrecord"></param> /// <returns></returns> public Dictionary <string, string> GetParameters(OpenAccountRecord openaccountrecord) { Dictionary <string, string> dict = new Dictionary <string, string>(); if (openaccountrecord.Id != null) { dict.Add("@Id", openaccountrecord.Id.ToString()); } if (openaccountrecord.customerNo != null) { dict.Add("@customerNo", openaccountrecord.customerNo.ToString()); } if (openaccountrecord.customerType != null) { dict.Add("@customerType", openaccountrecord.customerType.ToString()); } if (openaccountrecord.customerName != null) { dict.Add("@customerName", openaccountrecord.customerName.ToString()); } if (openaccountrecord.estateNo != null) { dict.Add("@estateNo", openaccountrecord.estateNo.ToString()); } if (openaccountrecord.address != null) { dict.Add("@address", openaccountrecord.address.ToString()); } if (openaccountrecord.meterNo != null) { dict.Add("@meterNo", openaccountrecord.meterNo.ToString()); } if (openaccountrecord.meterTypeNo != null) { dict.Add("@meterTypeNo", openaccountrecord.meterTypeNo.ToString()); } if (openaccountrecord.factoryNo != null) { dict.Add("@factoryNo", openaccountrecord.factoryNo.ToString()); } if (openaccountrecord.OpenType != null) { dict.Add("@OpenType", openaccountrecord.OpenType.ToString()); } if (openaccountrecord.Opentime != null) { dict.Add("@Opentime", openaccountrecord.Opentime.ToString()); } if (openaccountrecord.Operator != null) { dict.Add("@Operator", openaccountrecord.Operator.ToString()); } if (openaccountrecord.BranchNo != null) { dict.Add("@BranchNo", openaccountrecord.BranchNo.ToString()); } if (openaccountrecord.PosNo != null) { dict.Add("@PosNo", openaccountrecord.PosNo.ToString()); } return(dict); }
/// <summary> /// 更新 /// </summary> /// <param name="openaccountrecord"></param> /// <returns>是否成功</returns> public string GetUpdateStr(OpenAccountRecord openaccountrecord) { StringBuilder part1 = new StringBuilder(); part1.Append("update openaccountrecord set "); if (openaccountrecord.customerNo != null) { part1.Append("customerNo = @customerNo,"); } if (openaccountrecord.customerType != null) { part1.Append("customerType = @customerType,"); } if (openaccountrecord.customerName != null) { part1.Append("customerName = @customerName,"); } if (openaccountrecord.estateNo != null) { part1.Append("estateNo = @estateNo,"); } if (openaccountrecord.address != null) { part1.Append("address = @address,"); } if (openaccountrecord.meterNo != null) { part1.Append("meterNo = @meterNo,"); } if (openaccountrecord.meterTypeNo != null) { part1.Append("meterTypeNo = @meterTypeNo,"); } if (openaccountrecord.factoryNo != null) { part1.Append("factoryNo = @factoryNo,"); } if (openaccountrecord.OpenType != null) { part1.Append("OpenType = @OpenType,"); } if (openaccountrecord.Opentime != null) { part1.Append("Opentime = @Opentime,"); } if (openaccountrecord.Operator != null) { part1.Append("Operator = @Operator,"); } if (openaccountrecord.BranchNo != null) { part1.Append("BranchNo = @BranchNo,"); } if (openaccountrecord.PosNo != null) { part1.Append("PosNo = @PosNo,"); } int n = part1.ToString().LastIndexOf(","); part1.Remove(n, 1); part1.Append(" where Id= @Id "); return(part1.ToString()); }