/// <summary> /// 增加一条数据 /// </summary> public bool Add(Parking.Core.Model.CR_ORDER_RECORD_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CR_ORDER_RECORD_INFO("); strSql.Append("ID,PARTITION_CODE,IN_CHANNEL_CODE,OUT_CHANNEL_CODE,INOUT_RECODE_ID,TOTAL_TIME,VEHICLE_NO,DUE_MONEY,CHARGE_MONEY,PER_MONEY,ALREADY_PAID,PAY_PLATFORM,PAY_TYPE,IS_PAY,FREE_TIME,CREATE_TIME)"); strSql.Append(" values ("); strSql.Append("@ID,@PARTITION_CODE,@IN_CHANNEL_CODE,@OUT_CHANNEL_CODE,@INOUT_RECODE_ID,@TOTAL_TIME,@VEHICLE_NO,@DUE_MONEY,@CHARGE_MONEY,@PER_MONEY,@ALREADY_PAID,@PAY_PLATFORM,@PAY_TYPE,@IS_PAY,@FREE_TIME,@CREATE_TIME)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 32), new SqlParameter("@PARTITION_CODE", SqlDbType.VarChar, 32), new SqlParameter("@IN_CHANNEL_CODE", SqlDbType.VarChar, 32), new SqlParameter("@OUT_CHANNEL_CODE", SqlDbType.VarChar, 32), new SqlParameter("@INOUT_RECODE_ID", SqlDbType.VarChar, 32), new SqlParameter("@TOTAL_TIME", SqlDbType.Int, 4), new SqlParameter("@VEHICLE_NO", SqlDbType.VarChar, 20), new SqlParameter("@DUE_MONEY", SqlDbType.Decimal, 9), new SqlParameter("@CHARGE_MONEY", SqlDbType.Decimal, 9), new SqlParameter("@PER_MONEY", SqlDbType.Decimal, 9), new SqlParameter("@ALREADY_PAID", SqlDbType.Decimal, 9), new SqlParameter("@PAY_PLATFORM", SqlDbType.Int, 4), new SqlParameter("@PAY_TYPE", SqlDbType.Int, 4), new SqlParameter("@IS_PAY", SqlDbType.Bit, 1), new SqlParameter("@FREE_TIME", SqlDbType.DateTime), new SqlParameter("@CREATE_TIME", SqlDbType.DateTime) }; parameters[0].Value = model.ID; parameters[1].Value = model.PARTITION_CODE; parameters[2].Value = model.IN_CHANNEL_CODE; parameters[3].Value = model.OUT_CHANNEL_CODE; parameters[4].Value = model.INOUT_RECODE_ID; parameters[5].Value = model.TOTAL_TIME; parameters[6].Value = model.VEHICLE_NO; parameters[7].Value = model.DUE_MONEY; parameters[8].Value = model.CHARGE_MONEY; parameters[9].Value = model.PER_MONEY; parameters[10].Value = model.ALREADY_PAID; parameters[11].Value = model.PAY_PLATFORM; parameters[12].Value = model.PAY_TYPE; parameters[13].Value = model.IS_PAY; parameters[14].Value = model.FREE_TIME; parameters[15].Value = model.CREATE_TIME; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 取¨?消?订?单죤 /// </summary> /// <param name="model"></param> public void CancelOrder(Parking.Core.Model.CR_ORDER_RECORD_INFO model) { if (this.Update(model)) { CR_INOUT_RECODE recordDal = new CR_INOUT_RECODE(); var record = recordDal.GetModel(model.INOUT_RECODE_ID); if (null != record) { record.OUT_DEV_ID = string.Empty; record.OUT_OPERATOR_ID = string.Empty; record.OUT_CHANNEL_CODE = string.Empty; record.OUT_TIME = record.IN_TIME; recordDal.Update(record); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Parking.Core.Model.CR_ORDER_RECORD_INFO GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,PARTITION_CODE,IN_CHANNEL_CODE,OUT_CHANNEL_CODE,INOUT_RECODE_ID,TOTAL_TIME,VEHICLE_NO,DUE_MONEY,CHARGE_MONEY,PER_MONEY,ALREADY_PAID,PAY_PLATFORM,PAY_TYPE,IS_PAY,FREE_TIME,CREATE_TIME from CR_ORDER_RECORD_INFO "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 32) }; parameters[0].Value = ID; Parking.Core.Model.CR_ORDER_RECORD_INFO model = new Parking.Core.Model.CR_ORDER_RECORD_INFO(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Parking.Core.Model.CR_ORDER_RECORD_INFO DataRowToModel(DataRow row) { Parking.Core.Model.CR_ORDER_RECORD_INFO model = new Parking.Core.Model.CR_ORDER_RECORD_INFO(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["PARTITION_CODE"] != null) { model.PARTITION_CODE = row["PARTITION_CODE"].ToString(); } if (row["IN_CHANNEL_CODE"] != null) { model.IN_CHANNEL_CODE = row["IN_CHANNEL_CODE"].ToString(); } if (row["OUT_CHANNEL_CODE"] != null) { model.OUT_CHANNEL_CODE = row["OUT_CHANNEL_CODE"].ToString(); } if (row["INOUT_RECODE_ID"] != null) { model.INOUT_RECODE_ID = row["INOUT_RECODE_ID"].ToString(); } if (row["TOTAL_TIME"] != null && row["TOTAL_TIME"].ToString() != "") { model.TOTAL_TIME = int.Parse(row["TOTAL_TIME"].ToString()); } if (row["VEHICLE_NO"] != null) { model.VEHICLE_NO = row["VEHICLE_NO"].ToString(); } if (row["DUE_MONEY"] != null && row["DUE_MONEY"].ToString() != "") { model.DUE_MONEY = decimal.Parse(row["DUE_MONEY"].ToString()); } if (row["CHARGE_MONEY"] != null && row["CHARGE_MONEY"].ToString() != "") { model.CHARGE_MONEY = decimal.Parse(row["CHARGE_MONEY"].ToString()); } if (row["PER_MONEY"] != null && row["PER_MONEY"].ToString() != "") { model.PER_MONEY = decimal.Parse(row["PER_MONEY"].ToString()); } if (row["ALREADY_PAID"] != null && row["ALREADY_PAID"].ToString() != "") { model.ALREADY_PAID = decimal.Parse(row["ALREADY_PAID"].ToString()); } if (row["PAY_PLATFORM"] != null && row["PAY_PLATFORM"].ToString() != "") { model.PAY_PLATFORM = int.Parse(row["PAY_PLATFORM"].ToString()); } if (row["PAY_TYPE"] != null && row["PAY_TYPE"].ToString() != "") { model.PAY_TYPE = int.Parse(row["PAY_TYPE"].ToString()); } if (row["IS_PAY"] != null && row["IS_PAY"].ToString() != "") { if ((row["IS_PAY"].ToString() == "1") || (row["IS_PAY"].ToString().ToLower() == "true")) { model.IS_PAY = true; } else { model.IS_PAY = false; } } if (row["FREE_TIME"] != null && row["FREE_TIME"].ToString() != "") { model.FREE_TIME = DateTime.Parse(row["FREE_TIME"].ToString()); } if (row["CREATE_TIME"] != null && row["CREATE_TIME"].ToString() != "") { model.CREATE_TIME = DateTime.Parse(row["CREATE_TIME"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Parking.Core.Model.CR_ORDER_RECORD_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CR_ORDER_RECORD_INFO set "); strSql.Append("PARTITION_CODE=@PARTITION_CODE,"); strSql.Append("IN_CHANNEL_CODE=@IN_CHANNEL_CODE,"); strSql.Append("OUT_CHANNEL_CODE=@OUT_CHANNEL_CODE,"); strSql.Append("INOUT_RECODE_ID=@INOUT_RECODE_ID,"); strSql.Append("TOTAL_TIME=@TOTAL_TIME,"); strSql.Append("VEHICLE_NO=@VEHICLE_NO,"); strSql.Append("DUE_MONEY=@DUE_MONEY,"); strSql.Append("CHARGE_MONEY=@CHARGE_MONEY,"); strSql.Append("PER_MONEY=@PER_MONEY,"); strSql.Append("ALREADY_PAID=@ALREADY_PAID,"); strSql.Append("PAY_PLATFORM=@PAY_PLATFORM,"); strSql.Append("PAY_TYPE=@PAY_TYPE,"); strSql.Append("IS_PAY=@IS_PAY,"); strSql.Append("FREE_TIME=@FREE_TIME,"); strSql.Append("CREATE_TIME=@CREATE_TIME"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@PARTITION_CODE", SqlDbType.VarChar, 32), new SqlParameter("@IN_CHANNEL_CODE", SqlDbType.VarChar, 32), new SqlParameter("@OUT_CHANNEL_CODE", SqlDbType.VarChar, 32), new SqlParameter("@INOUT_RECODE_ID", SqlDbType.VarChar, 32), new SqlParameter("@TOTAL_TIME", SqlDbType.Int, 4), new SqlParameter("@VEHICLE_NO", SqlDbType.VarChar, 20), new SqlParameter("@DUE_MONEY", SqlDbType.Decimal, 9), new SqlParameter("@CHARGE_MONEY", SqlDbType.Decimal, 9), new SqlParameter("@PER_MONEY", SqlDbType.Decimal, 9), new SqlParameter("@ALREADY_PAID", SqlDbType.Decimal, 9), new SqlParameter("@PAY_PLATFORM", SqlDbType.Int, 4), new SqlParameter("@PAY_TYPE", SqlDbType.Int, 4), new SqlParameter("@IS_PAY", SqlDbType.Bit, 1), new SqlParameter("@FREE_TIME", SqlDbType.DateTime), new SqlParameter("@CREATE_TIME", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.VarChar, 32) }; parameters[0].Value = model.PARTITION_CODE; parameters[1].Value = model.IN_CHANNEL_CODE; parameters[2].Value = model.OUT_CHANNEL_CODE; parameters[3].Value = model.INOUT_RECODE_ID; parameters[4].Value = model.TOTAL_TIME; parameters[5].Value = model.VEHICLE_NO; parameters[6].Value = model.DUE_MONEY; parameters[7].Value = model.CHARGE_MONEY; parameters[8].Value = model.PER_MONEY; parameters[9].Value = model.ALREADY_PAID; parameters[10].Value = model.PAY_PLATFORM; parameters[11].Value = model.PAY_TYPE; parameters[12].Value = model.IS_PAY; parameters[13].Value = model.FREE_TIME; parameters[14].Value = model.CREATE_TIME; parameters[15].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Parking.Core.Model.CR_ORDER_RECORD_INFO model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Parking.Core.Model.CR_ORDER_RECORD_INFO model) { return(dal.Add(model)); }
/// <summary> /// 取¨?消?订?单죤 /// </summary> /// <param name="model"></param> public void CancelOrder(Parking.Core.Model.CR_ORDER_RECORD_INFO model) { dal.CancelOrder(model); }