public QPS.NEW.Model.Room GetModel(int Id)
{
QPS.NEW.Model.Room room = null;
DataTable dt = sqlHelper_.GetDataTable(
"select * from Room where Id=@id",
CommandType.Text,
new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@id", Id)
}
);
if (dt != null && dt.Rows.Count > 0)
{
room = new Model.Room();
room.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
room.Name = dt.Rows[0]["Name"].ToString();
room.RoomType = dt.Rows[0]["RoomType"].ToString();
room.RoomPrice = Convert.ToDecimal(dt.Rows[0]["RoomPrice"]);
room.Are = dt.Rows[0]["Are"].ToString();
room.Address = dt.Rows[0]["Address"].ToString();
room.ImagePath = dt.Rows[0]["ImagePath"].ToString();
room.Content = dt.Rows[0]["Content"].ToString();
room.RoomState = Convert.ToInt32(dt.Rows[0]["RoomState"]);
room.OwnerID = Convert.ToInt32(dt.Rows[0]["OwnerID"]);
room.IfRecommend = Convert.ToInt32(dt.Rows[0]["IfRecommend"]);
room.Examine = Convert.ToInt32(dt.Rows[0]["IfExamine"]);
room.RecommendTime = dt.Rows[0]["RecommendTime"].ToString();
}
return(room);
}
public bool Update(QPS.NEW.Model.Room model)
{
bool res = false;
string[] filedName = new string[50];
string[] paramName = new string[50];
SqlParameter[] sqlParams = new SqlParameter[50];
int Count = 0;
if (model.Id == -999)
{
return(false);
}
if (model.Id != -999)
{
filedName[Count] = "Id";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Id);
Count++;
}
if (model.Name != null)
{
filedName[Count] = "Name";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Name);
Count++;
}
if (model.RoomType != null)
{
filedName[Count] = "RoomType";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.RoomType);
Count++;
}
if (model.RoomPrice != -999)
{
filedName[Count] = "RoomPrice";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.RoomPrice);
Count++;
}
if (model.Are != null)
{
filedName[Count] = "Are";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Are);
Count++;
}
if (model.Address != null)
{
filedName[Count] = "Address";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Address);
Count++;
}
if (model.ImagePath != null)
{
filedName[Count] = "ImagePath";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.ImagePath);
Count++;
}
if (model.Content != null)
{
filedName[Count] = "Content";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Content);
Count++;
}
if (model.RoomState != -999)
{
filedName[Count] = "RoomState";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.RoomState);
Count++;
}
if (model.OwnerID != -999)
{
filedName[Count] = "OwnerID";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.OwnerID);
Count++;
}
if (model.IfRecommend != -999)
{
filedName[Count] = "IfRecommend";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.IfRecommend);
Count++;
}
if (model.Examine != -999)
{
filedName[Count] = "IfExamine";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Examine);
Count++;
}
if (model.RecommendTime != null)
{
filedName[Count] = "RecommendTime";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.RecommendTime);
Count++;
}
StringBuilder strSql = new StringBuilder();
strSql.Append("update Room set ");
for (int i = 1; i < Count; i++)
{
strSql.Append(filedName[i]);
strSql.Append("=");
strSql.Append(paramName[i]);
if (i != Count - 1)
{
strSql.Append(",");
}
}
strSql.Append(" where ");
strSql.Append(filedName[0] + "=" + paramName[0]);
int num = Convert.ToInt32(sqlHelper_.ExecuteCommand(
strSql.ToString(),
CommandType.Text,
sqlParams
));
if (num != 1)
{
res = false;
}
else
{
res = true;
}
return(res);
}
public int Add(QPS.NEW.Model.Room model)
{
string[] filedName = new string[50];
string[] paramName = new string[50];
SqlParameter[] sqlParams = new SqlParameter[50];
int Count = 0;
if (model.Name != null)
{
filedName[Count] = "Name";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Name);
Count++;
}
if (model.RoomType != null)
{
filedName[Count] = "RoomType";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.RoomType);
Count++;
}
if (model.RoomPrice != -999)
{
filedName[Count] = "RoomPrice";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.RoomPrice);
Count++;
}
if (model.Are != null)
{
filedName[Count] = "Are";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Are);
Count++;
}
if (model.Address != null)
{
filedName[Count] = "Address";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Address);
Count++;
}
if (model.ImagePath != null)
{
filedName[Count] = "ImagePath";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.ImagePath);
Count++;
}
if (model.Content != null)
{
filedName[Count] = "Content";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Content);
Count++;
}
if (model.RoomState != -999)
{
filedName[Count] = "RoomState";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.RoomState);
Count++;
}
if (model.OwnerID != -999)
{
filedName[Count] = "OwnerID";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.OwnerID);
Count++;
}
if (model.IfRecommend != -999)
{
filedName[Count] = "IfRecommend";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.IfRecommend);
Count++;
}
if (model.Examine != -999)
{
filedName[Count] = "IfExamine";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Examine);
Count++;
}
if (model.RecommendTime != null)
{
filedName[Count] = "RecommendTime";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.RecommendTime);
Count++;
}
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Room(");
for (int i = 0; i < Count; i++)
{
strSql.Append(filedName[i]);
if (i != Count - 1)
{
strSql.Append(",");
}
}
strSql.Append(")values(");
for (int i = 0; i < Count; i++)
{
strSql.Append(paramName[i]);
if (i != Count - 1)
{
strSql.Append(",");
}
}
strSql.Append(")");
int res = -1;
res = sqlHelper_.ExecuteCommand(
strSql.ToString(),
CommandType.Text,
sqlParams
);
if (res != 1)
{
return(0);
}
return(1);
}