/// <summary> /// 将DataRow赋值到实体 /// </summary> private TICKET_RWYEntity SetDsToEntity(DataSet ds, TICKET_RWYEntity model) { if (ds.Tables[0].Rows[0]["SysNo"].ToString() != "") { model.SysNo = int.Parse(ds.Tables[0].Rows[0]["SysNo"].ToString()); } model.TicketId = ds.Tables[0].Rows[0]["TicketId"].ToString(); model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); model.ScenicId = ds.Tables[0].Rows[0]["ScenicId"].ToString(); model.Status = ds.Tables[0].Rows[0]["Status"].ToString(); model.Description = ds.Tables[0].Rows[0]["Description"].ToString(); model.EndOfTime = ds.Tables[0].Rows[0]["EndOfTime"].ToString(); model.Notice = ds.Tables[0].Rows[0]["Notice"].ToString(); model.OrderAdvanceHours = ds.Tables[0].Rows[0]["OrderAdvanceHours"].ToString(); model.OrderAdvanceDays = ds.Tables[0].Rows[0]["OrderAdvanceDays"].ToString(); model.OrderBeforeHour = ds.Tables[0].Rows[0]["OrderBeforeHour"].ToString(); model.OrderBeforeMin = ds.Tables[0].Rows[0]["OrderBeforeMin"].ToString(); model.MaxOrderAdvanceDays = ds.Tables[0].Rows[0]["MaxOrderAdvanceDays"].ToString(); model.RefundAdvanceHours = ds.Tables[0].Rows[0]["RefundAdvanceHours"].ToString(); model.UseAdvanceHours = ds.Tables[0].Rows[0]["UseAdvanceHours"].ToString(); model.AdditionalInfo = ds.Tables[0].Rows[0]["AdditionalInfo"].ToString(); model.EffectiveDate = ds.Tables[0].Rows[0]["EffectiveDate"].ToString(); model.ValidWeeks = ds.Tables[0].Rows[0]["ValidWeeks"].ToString(); model.ValidDates = ds.Tables[0].Rows[0]["ValidDates"].ToString(); model.InvalidDates = ds.Tables[0].Rows[0]["InvalidDates"].ToString(); model.IsInvtLimit = ds.Tables[0].Rows[0]["IsInvtLimit"].ToString(); model.MaxOrderNum = ds.Tables[0].Rows[0]["MaxOrderNum"].ToString(); model.MinOrderNum = ds.Tables[0].Rows[0]["MinOrderNum"].ToString(); model.ImgUrl = ds.Tables[0].Rows[0]["ImgUrl"].ToString(); model.SalePrice = ds.Tables[0].Rows[0]["SalePrice"].ToString(); model.SuggestPrice = ds.Tables[0].Rows[0]["SuggestPrice"].ToString(); model.MarketPrice = ds.Tables[0].Rows[0]["MarketPrice"].ToString(); return(model); }
public TICKET_RWYEntity GetModelByRWYTicketID(string RWYTicketID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM dbo.TICKET_RWY "); strSql.Append(" WHERE TicketId = @TicketId "); SqlParameter[] parameters = { new SqlParameter("@TicketId", SqlDbType.NVarChar, 64) }; parameters[0].Value = RWYTicketID; TICKET_RWYEntity model = new TICKET_RWYEntity(); DataSet ds = SqlHelper.ExecuteDataSet(AppConfig.Conn_IPP, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { SetDsToEntity(ds, model); return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TICKET_RWYEntity GetModel(int SysNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from dbo.TICKET_RWY"); strSql.Append(" where SysNo=@SysNo "); SqlParameter[] parameters = { new SqlParameter("@SysNo", SqlDbType.Int, 4) }; parameters[0].Value = SysNo; TICKET_RWYEntity model = new TICKET_RWYEntity(); DataSet ds = SqlHelper.ExecuteDataSet(AppConfig.Conn_IPP, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { SetDsToEntity(ds, model); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TICKET_RWYEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dbo.TICKET_RWY("); strSql.Append("TicketId,Name,ScenicId,Status,Description,EndOfTime,Notice,OrderAdvanceHours,OrderAdvanceDays,OrderBeforeHour,OrderBeforeMin,MaxOrderAdvanceDays,RefundAdvanceHours,UseAdvanceHours,AdditionalInfo,EffectiveDate,ValidWeeks,ValidDates,InvalidDates,IsInvtLimit,MaxOrderNum,MinOrderNum,ImgUrl,SalePrice,SuggestPrice,MarketPrice)"); strSql.Append(" values ("); strSql.Append("@TicketId,@Name,@ScenicId,@Status,@Description,@EndOfTime,@Notice,@OrderAdvanceHours,@OrderAdvanceDays,@OrderBeforeHour,@OrderBeforeMin,@MaxOrderAdvanceDays,@RefundAdvanceHours,@UseAdvanceHours,@AdditionalInfo,@EffectiveDate,@ValidWeeks,@ValidDates,@InvalidDates,@IsInvtLimit,@MaxOrderNum,@MinOrderNum,@ImgUrl,@SalePrice,@SuggestPrice,@MarketPrice)"); strSql.Append(";select @@IDENTITY"); SqlCommand cmd = new SqlCommand(strSql.ToString()); SqlParameter[] parameters = { new SqlParameter("@TicketId", SqlDbType.NVarChar, 64), new SqlParameter("@Name", SqlDbType.NVarChar, 64), new SqlParameter("@ScenicId", SqlDbType.NVarChar, 64), new SqlParameter("@Status", SqlDbType.NVarChar, 64), new SqlParameter("@Description", SqlDbType.NText, 2147483646), new SqlParameter("@EndOfTime", SqlDbType.NVarChar, 64), new SqlParameter("@Notice", SqlDbType.NVarChar, 64), new SqlParameter("@OrderAdvanceHours", SqlDbType.NVarChar, 64), new SqlParameter("@OrderAdvanceDays", SqlDbType.NVarChar, 64), new SqlParameter("@OrderBeforeHour", SqlDbType.NVarChar, 64), new SqlParameter("@OrderBeforeMin", SqlDbType.NVarChar, 64), new SqlParameter("@MaxOrderAdvanceDays", SqlDbType.NVarChar, 64), new SqlParameter("@RefundAdvanceHours", SqlDbType.NVarChar, 64), new SqlParameter("@UseAdvanceHours", SqlDbType.NVarChar, 64), new SqlParameter("@AdditionalInfo", SqlDbType.NVarChar, 400), new SqlParameter("@EffectiveDate", SqlDbType.NVarChar, 64), new SqlParameter("@ValidWeeks", SqlDbType.NVarChar, 64), new SqlParameter("@ValidDates", SqlDbType.NVarChar, 400), new SqlParameter("@InvalidDates", SqlDbType.NVarChar, 400), new SqlParameter("@IsInvtLimit", SqlDbType.NVarChar, 64), new SqlParameter("@MaxOrderNum", SqlDbType.NVarChar, 64), new SqlParameter("@MinOrderNum", SqlDbType.NVarChar, 64), new SqlParameter("@ImgUrl", SqlDbType.NVarChar, 200), new SqlParameter("@SalePrice", SqlDbType.NVarChar, 64), new SqlParameter("@SuggestPrice", SqlDbType.NVarChar, 64), new SqlParameter("@MarketPrice", SqlDbType.NVarChar, 64), }; if (model.TicketId != AppConst.StringNull) { parameters[0].Value = model.TicketId; } else { parameters[0].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[0]); if (model.Name != AppConst.StringNull) { parameters[1].Value = model.Name; } else { parameters[1].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[1]); if (model.ScenicId != AppConst.StringNull) { parameters[2].Value = model.ScenicId; } else { parameters[2].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[2]); if (model.Status != AppConst.StringNull) { parameters[3].Value = model.Status; } else { parameters[3].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[3]); if (model.Description != AppConst.StringNull) { parameters[4].Value = model.Description; } else { parameters[4].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[4]); if (model.EndOfTime != AppConst.StringNull) { parameters[5].Value = model.EndOfTime; } else { parameters[5].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[5]); if (model.Notice != AppConst.StringNull) { parameters[6].Value = model.Notice; } else { parameters[6].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[6]); if (model.OrderAdvanceHours != AppConst.StringNull) { parameters[7].Value = model.OrderAdvanceHours; } else { parameters[7].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[7]); if (model.OrderAdvanceDays != AppConst.StringNull) { parameters[8].Value = model.OrderAdvanceDays; } else { parameters[8].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[8]); if (model.OrderBeforeHour != AppConst.StringNull) { parameters[9].Value = model.OrderBeforeHour; } else { parameters[9].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[9]); if (model.OrderBeforeMin != AppConst.StringNull) { parameters[10].Value = model.OrderBeforeMin; } else { parameters[10].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[10]); if (model.MaxOrderAdvanceDays != AppConst.StringNull) { parameters[11].Value = model.MaxOrderAdvanceDays; } else { parameters[11].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[11]); if (model.RefundAdvanceHours != AppConst.StringNull) { parameters[12].Value = model.RefundAdvanceHours; } else { parameters[12].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[12]); if (model.UseAdvanceHours != AppConst.StringNull) { parameters[13].Value = model.UseAdvanceHours; } else { parameters[13].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[13]); if (model.AdditionalInfo != AppConst.StringNull) { parameters[14].Value = model.AdditionalInfo; } else { parameters[14].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[14]); if (model.EffectiveDate != AppConst.StringNull) { parameters[15].Value = model.EffectiveDate; } else { parameters[15].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[15]); if (model.ValidWeeks != AppConst.StringNull) { parameters[16].Value = model.ValidWeeks; } else { parameters[16].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[16]); if (model.ValidDates != AppConst.StringNull) { parameters[17].Value = model.ValidDates; } else { parameters[17].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[17]); if (model.InvalidDates != AppConst.StringNull) { parameters[18].Value = model.InvalidDates; } else { parameters[18].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[18]); if (model.IsInvtLimit != AppConst.StringNull) { parameters[19].Value = model.IsInvtLimit; } else { parameters[19].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[19]); if (model.MaxOrderNum != AppConst.StringNull) { parameters[20].Value = model.MaxOrderNum; } else { parameters[20].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[20]); if (model.MinOrderNum != AppConst.StringNull) { parameters[21].Value = model.MinOrderNum; } else { parameters[21].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[21]); if (model.ImgUrl != AppConst.StringNull) { parameters[22].Value = model.ImgUrl; } else { parameters[22].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[22]); if (model.SalePrice != AppConst.StringNull) { parameters[23].Value = model.SalePrice; } else { parameters[23].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[23]); if (model.SuggestPrice != AppConst.StringNull) { parameters[24].Value = model.SuggestPrice; } else { parameters[24].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[24]); if (model.MarketPrice != AppConst.StringNull) { parameters[25].Value = model.MarketPrice; } else { parameters[25].Value = System.DBNull.Value; } cmd.Parameters.Add(parameters[25]); return(Convert.ToInt32(SqlHelper.ExecuteScalar(AppConfig.Conn_IPP, cmd))); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(TICKET_RWYEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dbo.TICKET_RWY set "); SqlCommand cmd = new SqlCommand(); if (model.SysNo != AppConst.IntNull) { SqlParameter param = new SqlParameter("@SysNo", SqlDbType.Int, 4); param.Value = model.SysNo; cmd.Parameters.Add(param); } if (model.TicketId != AppConst.StringNull) { strSql.Append("TicketId=@TicketId,"); SqlParameter param = new SqlParameter("@TicketId", SqlDbType.NVarChar, 64); param.Value = model.TicketId; cmd.Parameters.Add(param); } if (model.Name != AppConst.StringNull) { strSql.Append("Name=@Name,"); SqlParameter param = new SqlParameter("@Name", SqlDbType.NVarChar, 64); param.Value = model.Name; cmd.Parameters.Add(param); } if (model.ScenicId != AppConst.StringNull) { strSql.Append("ScenicId=@ScenicId,"); SqlParameter param = new SqlParameter("@ScenicId", SqlDbType.NVarChar, 64); param.Value = model.ScenicId; cmd.Parameters.Add(param); } if (model.Status != AppConst.StringNull) { strSql.Append("Status=@Status,"); SqlParameter param = new SqlParameter("@Status", SqlDbType.NVarChar, 64); param.Value = model.Status; cmd.Parameters.Add(param); } if (model.Description != AppConst.StringNull) { strSql.Append("Description=@Description,"); SqlParameter param = new SqlParameter("@Description", SqlDbType.NText, 2147483646); param.Value = model.Description; cmd.Parameters.Add(param); } if (model.EndOfTime != AppConst.StringNull) { strSql.Append("EndOfTime=@EndOfTime,"); SqlParameter param = new SqlParameter("@EndOfTime", SqlDbType.NVarChar, 64); param.Value = model.EndOfTime; cmd.Parameters.Add(param); } if (model.Notice != AppConst.StringNull) { strSql.Append("Notice=@Notice,"); SqlParameter param = new SqlParameter("@Notice", SqlDbType.NVarChar, 64); param.Value = model.Notice; cmd.Parameters.Add(param); } if (model.OrderAdvanceHours != AppConst.StringNull) { strSql.Append("OrderAdvanceHours=@OrderAdvanceHours,"); SqlParameter param = new SqlParameter("@OrderAdvanceHours", SqlDbType.NVarChar, 64); param.Value = model.OrderAdvanceHours; cmd.Parameters.Add(param); } if (model.OrderAdvanceDays != AppConst.StringNull) { strSql.Append("OrderAdvanceDays=@OrderAdvanceDays,"); SqlParameter param = new SqlParameter("@OrderAdvanceDays", SqlDbType.NVarChar, 64); param.Value = model.OrderAdvanceDays; cmd.Parameters.Add(param); } if (model.OrderBeforeHour != AppConst.StringNull) { strSql.Append("OrderBeforeHour=@OrderBeforeHour,"); SqlParameter param = new SqlParameter("@OrderBeforeHour", SqlDbType.NVarChar, 64); param.Value = model.OrderBeforeHour; cmd.Parameters.Add(param); } if (model.OrderBeforeMin != AppConst.StringNull) { strSql.Append("OrderBeforeMin=@OrderBeforeMin,"); SqlParameter param = new SqlParameter("@OrderBeforeMin", SqlDbType.NVarChar, 64); param.Value = model.OrderBeforeMin; cmd.Parameters.Add(param); } if (model.MaxOrderAdvanceDays != AppConst.StringNull) { strSql.Append("MaxOrderAdvanceDays=@MaxOrderAdvanceDays,"); SqlParameter param = new SqlParameter("@MaxOrderAdvanceDays", SqlDbType.NVarChar, 64); param.Value = model.MaxOrderAdvanceDays; cmd.Parameters.Add(param); } if (model.RefundAdvanceHours != AppConst.StringNull) { strSql.Append("RefundAdvanceHours=@RefundAdvanceHours,"); SqlParameter param = new SqlParameter("@RefundAdvanceHours", SqlDbType.NVarChar, 64); param.Value = model.RefundAdvanceHours; cmd.Parameters.Add(param); } if (model.UseAdvanceHours != AppConst.StringNull) { strSql.Append("UseAdvanceHours=@UseAdvanceHours,"); SqlParameter param = new SqlParameter("@UseAdvanceHours", SqlDbType.NVarChar, 64); param.Value = model.UseAdvanceHours; cmd.Parameters.Add(param); } if (model.AdditionalInfo != AppConst.StringNull) { strSql.Append("AdditionalInfo=@AdditionalInfo,"); SqlParameter param = new SqlParameter("@AdditionalInfo", SqlDbType.NVarChar, 400); param.Value = model.AdditionalInfo; cmd.Parameters.Add(param); } if (model.EffectiveDate != AppConst.StringNull) { strSql.Append("EffectiveDate=@EffectiveDate,"); SqlParameter param = new SqlParameter("@EffectiveDate", SqlDbType.NVarChar, 64); param.Value = model.EffectiveDate; cmd.Parameters.Add(param); } if (model.ValidWeeks != AppConst.StringNull) { strSql.Append("ValidWeeks=@ValidWeeks,"); SqlParameter param = new SqlParameter("@ValidWeeks", SqlDbType.NVarChar, 64); param.Value = model.ValidWeeks; cmd.Parameters.Add(param); } if (model.ValidDates != AppConst.StringNull) { strSql.Append("ValidDates=@ValidDates,"); SqlParameter param = new SqlParameter("@ValidDates", SqlDbType.NVarChar, 400); param.Value = model.ValidDates; cmd.Parameters.Add(param); } if (model.InvalidDates != AppConst.StringNull) { strSql.Append("InvalidDates=@InvalidDates,"); SqlParameter param = new SqlParameter("@InvalidDates", SqlDbType.NVarChar, 400); param.Value = model.InvalidDates; cmd.Parameters.Add(param); } if (model.IsInvtLimit != AppConst.StringNull) { strSql.Append("IsInvtLimit=@IsInvtLimit,"); SqlParameter param = new SqlParameter("@IsInvtLimit", SqlDbType.NVarChar, 64); param.Value = model.IsInvtLimit; cmd.Parameters.Add(param); } if (model.MaxOrderNum != AppConst.StringNull) { strSql.Append("MaxOrderNum=@MaxOrderNum,"); SqlParameter param = new SqlParameter("@MaxOrderNum", SqlDbType.NVarChar, 64); param.Value = model.MaxOrderNum; cmd.Parameters.Add(param); } if (model.MinOrderNum != AppConst.StringNull) { strSql.Append("MinOrderNum=@MinOrderNum,"); SqlParameter param = new SqlParameter("@MinOrderNum", SqlDbType.NVarChar, 64); param.Value = model.MinOrderNum; cmd.Parameters.Add(param); } if (model.ImgUrl != AppConst.StringNull) { strSql.Append("ImgUrl=@ImgUrl,"); SqlParameter param = new SqlParameter("@ImgUrl", SqlDbType.NVarChar, 200); param.Value = model.ImgUrl; cmd.Parameters.Add(param); } if (model.SalePrice != AppConst.StringNull) { strSql.Append("SalePrice=@SalePrice,"); SqlParameter param = new SqlParameter("@SalePrice", SqlDbType.NVarChar, 64); param.Value = model.SalePrice; cmd.Parameters.Add(param); } if (model.SuggestPrice != AppConst.StringNull) { strSql.Append("SuggestPrice=@SuggestPrice,"); SqlParameter param = new SqlParameter("@SuggestPrice", SqlDbType.NVarChar, 64); param.Value = model.SuggestPrice; cmd.Parameters.Add(param); } if (model.MarketPrice != AppConst.StringNull) { strSql.Append("MarketPrice=@MarketPrice,"); SqlParameter param = new SqlParameter("@MarketPrice", SqlDbType.NVarChar, 64); param.Value = model.MarketPrice; cmd.Parameters.Add(param); } strSql.Remove(strSql.Length - 1, 1); strSql.Append(" where SysNo=@SysNo "); cmd.CommandText = strSql.ToString(); return(SqlHelper.ExecuteNonQuery(AppConfig.Conn_IPP, cmd)); }