/// <summary> /// 得到一个对象实体 /// </summary> public Model.Order.Bank.OrderBankCodePay DataRowToModel(DataRow row) { var model = new Model.Order.Bank.OrderBankCodePay(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["sysOrderNo"] != null) { model.sysOrderNo = row["sysOrderNo"].ToString(); } if (row["channel"] != null && row["channel"].ToString() != "") { model.channel = int.Parse(row["channel"].ToString()); } if (row["codeImgUrl"] != null) { model.codeImgUrl = row["codeImgUrl"].ToString(); } if (row["addTime"] != null && row["addTime"].ToString() != "") { model.addTime = DateTime.Parse(row["addTime"].ToString()); } if (row["updateTime"] != null && row["updateTime"].ToString() != "") { model.updateTime = DateTime.Parse(row["updateTime"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Order.Bank.OrderBankCodePay model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@sysOrderNo", SqlDbType.VarChar, 30), new SqlParameter("@channel", SqlDbType.Int, 4), new SqlParameter("@codeImgUrl", SqlDbType.VarChar, 400), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@updateTime", SqlDbType.DateTime) }; parameters[0].Value = model.id; parameters[1].Value = model.sysOrderNo; parameters[2].Value = model.channel; parameters[3].Value = model.codeImgUrl; parameters[4].Value = model.addTime; parameters[5].Value = model.updateTime; DbHelperSQL.RunProcedure("proc_orderbankcodepay_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Order.Bank.OrderBankCodePay model) { try { return(dal.Add(model)); } catch (Exception exception) { ExceptionHandler.HandleException(exception); return(0); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Order.Bank.OrderBankCodePay GetModel(string orderno) { IDataParameter[] parameters = { new SqlParameter("@orderno", SqlDbType.VarChar, 30) }; parameters[0].Value = orderno; var model = new Model.Order.Bank.OrderBankCodePay(); DataSet ds = DbHelperSQL.RunProcedure("proc_orderbankcodepay_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Order.Bank.OrderBankCodePay model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@sysOrderNo", SqlDbType.VarChar, 30), new SqlParameter("@channel", SqlDbType.Int, 4), new SqlParameter("@codeImgUrl", SqlDbType.VarChar, 400), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@updateTime", SqlDbType.DateTime) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.sysOrderNo; parameters[2].Value = model.channel; parameters[3].Value = model.codeImgUrl; parameters[4].Value = model.addTime; parameters[5].Value = model.updateTime; DbHelperSQL.RunProcedure("proc_orderbankcodepay_add", parameters, out rowsAffected); return((int)parameters[0].Value); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Order.Bank.OrderBankCodePay model) { return(dal.Update(model)); }