/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CdHotelManage.Model.hourse_scheme model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update hourse_scheme set ");
strSql.Append("hs_room=@hs_room,");
strSql.Append("hs_name=@hs_name,");
strSql.Append("hs_psmoney=@hs_psmoney,");
strSql.Append("hs_Discount=@hs_Discount,");
strSql.Append("hs_type=@hs_type,");
strSql.Append("hs_jgtype=@hs_jgtype,");
strSql.Append("hs_source_id=@hs_source_id,");
strSql.Append("Hs_isAll=@Hs_isAll,");
strSql.Append("Hs_Strat=@Hs_Strat,");
strSql.Append("Hs_End=@Hs_End,");
strSql.Append("Hs_zdr=@Hs_zdr,");
strSql.Append("Hs_Reamrk=@Hs_Reamrk");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@hs_room", SqlDbType.Int, 4),
new SqlParameter("@hs_name", SqlDbType.NVarChar, 50),
new SqlParameter("@hs_psmoney", SqlDbType.Money, 8),
new SqlParameter("@hs_Discount", SqlDbType.NVarChar, 10),
new SqlParameter("@hs_type", SqlDbType.Int, 4),
new SqlParameter("@hs_jgtype", SqlDbType.Int, 4),
new SqlParameter("@hs_source_id", SqlDbType.Int, 4),
new SqlParameter("@Hs_isAll", SqlDbType.Bit, 1),
new SqlParameter("@Hs_Strat", SqlDbType.DateTime),
new SqlParameter("@Hs_End", SqlDbType.DateTime),
new SqlParameter("@Hs_zdr", SqlDbType.Money, 8),
new SqlParameter("@Hs_Reamrk", SqlDbType.NVarChar, 500),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.hs_room;
parameters[1].Value = model.hs_name;
parameters[2].Value = model.hs_psmoney;
parameters[3].Value = model.hs_Discount;
parameters[4].Value = model.hs_type;
parameters[5].Value = model.hs_jgtype;
parameters[6].Value = model.hs_source_id;
parameters[7].Value = model.Hs_isAll;
parameters[8].Value = model.Hs_Strat;
parameters[9].Value = model.Hs_End;
parameters[10].Value = model.Hs_zdr;
parameters[11].Value = model.Hs_Reamrk;
parameters[12].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CdHotelManage.Model.hourse_scheme model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into hourse_scheme(");
strSql.Append("hs_room,hs_name,hs_psmoney,hs_Discount,hs_type,hs_jgtype,hs_source_id,Hs_isAll,Hs_Strat,Hs_End,Hs_zdr,Hs_Reamrk)");
strSql.Append(" values (");
strSql.Append("@hs_room,@hs_name,@hs_psmoney,@hs_Discount,@hs_type,@hs_jgtype,@hs_source_id,@Hs_isAll,@Hs_Strat,@Hs_End,@Hs_zdr,@Hs_Reamrk)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@hs_room", SqlDbType.Int, 4),
new SqlParameter("@hs_name", SqlDbType.NVarChar, 50),
new SqlParameter("@hs_psmoney", SqlDbType.Money, 8),
new SqlParameter("@hs_Discount", SqlDbType.NVarChar, 10),
new SqlParameter("@hs_type", SqlDbType.Int, 4),
new SqlParameter("@hs_jgtype", SqlDbType.Int, 4),
new SqlParameter("@hs_source_id", SqlDbType.Int, 4),
new SqlParameter("@Hs_isAll", SqlDbType.Bit, 1),
new SqlParameter("@Hs_Strat", SqlDbType.DateTime),
new SqlParameter("@Hs_End", SqlDbType.DateTime),
new SqlParameter("@Hs_zdr", SqlDbType.Money, 8),
new SqlParameter("@Hs_Reamrk", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.hs_room;
parameters[1].Value = model.hs_name;
parameters[2].Value = model.hs_psmoney;
parameters[3].Value = model.hs_Discount;
parameters[4].Value = model.hs_type;
parameters[5].Value = model.hs_jgtype;
parameters[6].Value = model.hs_source_id;
parameters[7].Value = model.Hs_isAll;
parameters[8].Value = model.Hs_Strat;
parameters[9].Value = model.Hs_End;
parameters[10].Value = model.Hs_zdr;
parameters[11].Value = model.Hs_Reamrk;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CdHotelManage.Model.hourse_scheme GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,hs_room,hs_name,hs_psmoney,hs_Discount,hs_type,hs_jgtype,hs_source_id,Hs_isAll,Hs_Strat,Hs_End,Hs_zdr,Hs_Reamrk from hourse_scheme ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
CdHotelManage.Model.hourse_scheme model = new CdHotelManage.Model.hourse_scheme();
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 CdHotelManage.Model.hourse_scheme DataRowToModel(DataRow row)
{
CdHotelManage.Model.hourse_scheme model = new CdHotelManage.Model.hourse_scheme();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["hs_room"] != null && row["hs_room"].ToString() != "")
{
model.hs_room = int.Parse(row["hs_room"].ToString());
}
if (row["hs_name"] != null)
{
model.hs_name = row["hs_name"].ToString();
}
if (row["hs_psmoney"] != null && row["hs_psmoney"].ToString() != "")
{
model.hs_psmoney = decimal.Parse(row["hs_psmoney"].ToString());
}
if (row["hs_Discount"] != null)
{
model.hs_Discount = row["hs_Discount"].ToString();
}
if (row["hs_type"] != null && row["hs_type"].ToString() != "")
{
model.hs_type = int.Parse(row["hs_type"].ToString());
}
if (row["hs_jgtype"] != null && row["hs_jgtype"].ToString() != "")
{
model.hs_jgtype = int.Parse(row["hs_jgtype"].ToString());
}
if (row["hs_source_id"] != null && row["hs_source_id"].ToString() != "")
{
model.hs_source_id = int.Parse(row["hs_source_id"].ToString());
}
if (row["Hs_isAll"] != null && row["Hs_isAll"].ToString() != "")
{
if ((row["Hs_isAll"].ToString() == "1") || (row["Hs_isAll"].ToString().ToLower() == "true"))
{
model.Hs_isAll = true;
}
else
{
model.Hs_isAll = false;
}
}
if (row["Hs_Strat"] != null && row["Hs_Strat"].ToString() != "")
{
model.Hs_Strat = DateTime.Parse(row["Hs_Strat"].ToString());
}
if (row["Hs_End"] != null && row["Hs_End"].ToString() != "")
{
model.Hs_End = DateTime.Parse(row["Hs_End"].ToString());
}
if (row["Hs_zdr"] != null && row["Hs_zdr"].ToString() != "")
{
model.Hs_zdr = decimal.Parse(row["Hs_zdr"].ToString());
}
if (row["Hs_Reamrk"] != null)
{
model.Hs_Reamrk = row["Hs_Reamrk"].ToString();
}
}
return(model);
}