/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(iRan.Model.CheckIn model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CheckIn set ");
strSql.Append("Oid=@Oid,");
strSql.Append("Uid=@Uid,");
strSql.Append("CheckinTime=@CheckinTime,");
strSql.Append("CheckinDays=@CheckinDays,");
strSql.Append("cTotalPrice=@cTotalPrice,");
strSql.Append("CheckinStatus=@CheckinStatus");
strSql.Append(" where Cid=@Cid");
SqlParameter[] parameters =
{
new SqlParameter("@Oid", SqlDbType.Decimal, 9),
new SqlParameter("@Uid", SqlDbType.Int, 4),
new SqlParameter("@CheckinTime", SqlDbType.DateTime),
new SqlParameter("@CheckinDays", SqlDbType.Int, 4),
new SqlParameter("@cTotalPrice", SqlDbType.Float, 8),
new SqlParameter("@CheckinStatus", SqlDbType.Int, 4),
new SqlParameter("@Cid", SqlDbType.BigInt, 8),
new SqlParameter("@Gid", SqlDbType.Int, 4)
};
parameters[0].Value = model.Oid;
parameters[1].Value = model.Uid;
parameters[2].Value = model.CheckinTime;
parameters[3].Value = model.CheckinDays;
parameters[4].Value = model.cTotalPrice;
parameters[5].Value = model.CheckinStatus;
parameters[6].Value = model.Cid;
parameters[7].Value = model.Gid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public iRan.Model.CheckIn DataRowToModel(DataRow row)
{
iRan.Model.CheckIn model = new iRan.Model.CheckIn();
if (row != null)
{
if (row["Cid"] != null && row["Cid"].ToString() != "")
{
model.Cid = long.Parse(row["Cid"].ToString());
}
if (row["Oid"] != null && row["Oid"].ToString() != "")
{
model.Oid = decimal.Parse(row["Oid"].ToString());
}
if (row["Gid"] != null && row["Gid"].ToString() != "")
{
model.Gid = int.Parse(row["Gid"].ToString());
}
if (row["Uid"] != null && row["Uid"].ToString() != "")
{
model.Uid = int.Parse(row["Uid"].ToString());
}
if (row["CheckinTime"] != null && row["CheckinTime"].ToString() != "")
{
model.CheckinTime = DateTime.Parse(row["CheckinTime"].ToString());
}
if (row["CheckinDays"] != null && row["CheckinDays"].ToString() != "")
{
model.CheckinDays = int.Parse(row["CheckinDays"].ToString());
}
if (row["cTotalPrice"] != null && row["cTotalPrice"].ToString() != "")
{
model.cTotalPrice = decimal.Parse(row["cTotalPrice"].ToString());
}
if (row["CheckinStatus"] != null && row["CheckinStatus"].ToString() != "")
{
model.CheckinStatus = int.Parse(row["CheckinStatus"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(iRan.Model.CheckIn model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CheckIn(");
strSql.Append("Oid,Gid,Uid,CheckinTime,CheckinDays,cTotalPrice,CheckinStatus)");
strSql.Append(" values (");
strSql.Append("@Oid,@Gid,@Uid,@CheckinTime,@CheckinDays,@cTotalPrice,@CheckinStatus)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Oid", SqlDbType.Decimal, 9),
new SqlParameter("@Gid", SqlDbType.Int, 4),
new SqlParameter("@Uid", SqlDbType.Int, 4),
new SqlParameter("@CheckinTime", SqlDbType.DateTime),
new SqlParameter("@CheckinDays", SqlDbType.Int, 4),
new SqlParameter("@cTotalPrice", SqlDbType.Float, 8),
new SqlParameter("@CheckinStatus", SqlDbType.Int, 4)
};
parameters[0].Value = model.Oid;
parameters[1].Value = model.Gid;
parameters[2].Value = model.Uid;
parameters[3].Value = model.CheckinTime;
parameters[4].Value = model.CheckinDays;
parameters[5].Value = model.cTotalPrice;
parameters[6].Value = model.CheckinStatus;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public iRan.Model.CheckIn GetModel(long Cid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Cid,Oid,Gid,Uid,CheckinTime,CheckinDays,cTotalPrice,CheckinStatus from CheckIn ");
strSql.Append(" where Cid=@Cid");
SqlParameter[] parameters =
{
new SqlParameter("@Cid", SqlDbType.BigInt)
};
parameters[0].Value = Cid;
iRan.Model.CheckIn model = new iRan.Model.CheckIn();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}