protected void gdvOrder_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//得到单位编号
string rowToDelete = this.gdvOrder.DataKeys[e.RowIndex].Values[0].ToString();
//转换为整数
int ID = Convert.ToInt32(rowToDelete);
QPS.NEW.BLL.Orderform Border = new QPS.NEW.BLL.Orderform();
QPS.NEW.Model.Orderform morder = Border.GetModel(ID);
morder.IsDelete = 1;
Border.Update(morder);
gdvOrder.DataSource = databind();
gdvOrder.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
orderid = Convert.ToInt32(Request.QueryString["id"]);
QPS.NEW.BLL.Orderform Border = new QPS.NEW.BLL.Orderform();
QPS.NEW.Model.Orderform Morder = Border.GetModel(orderid);
QPS.NEW.BLL.Users u = new QPS.NEW.BLL.Users();
QPS.NEW.BLL.Room r = new QPS.NEW.BLL.Room();
int roomid = (int)Morder.Roomid;
int userid = (int)Morder.Userid;
txfRoomName.Value = r.GetModel(roomid).Name;
txfUserName.Value = u.GetModel(userid).Username;
//txfBeverageCost.Text =Border.GetModel(orderid).Beveragecost.ToString();
txfOrderId.Value = orderid.ToString();
}
protected void btnCreate_Click(object sender, EventArgs e)
{
try
{ //转换为整数
int ID = Convert.ToInt32(orderid);
QPS.NEW.BLL.Orderform Border = new QPS.NEW.BLL.Orderform();
QPS.NEW.Model.Orderform order = Border.GetModel(ID);
order.Beveragecost = Convert.ToDecimal(txfBeverageCost.Text);
if (Border.Update(order))
{
Response.Write("<script>alert('订单修改成功！')</script>");
Response.Write("<script>window.close()</script>");
}
}
catch (Exception ex)
{
Response.Write("<script>alert('订单修改失败！')</script>");
}
}
protected void gdvOrder_RowCommand(object sender, GridViewCommandEventArgs e)
{
////得到单位编号
//string rowUpdate = this.gdvOrder.DataKeys[].Values[0].ToString();
////转换为整数
//int ID = Convert.ToInt32(rowUpdate);
//QPS.BLL.Orderform Border = new QPS.BLL.Orderform();
//QPS.Model.Orderform Morder = new QPS.Model.Orderform();
//Morder.Id = ID;
//Morder.Beveragecost = (decimal)this.gdvOrder.DataKeys[e.RowIndex].Values[3];
//Border.Update(Morder);
//gdvOrder.DataSource = databind();
//gdvOrder.DataBind();
string strArgument = e.CommandArgument.ToString();
if (e.CommandName == "IsValidate")
{
string[] Argument = strArgument.Split('|');
string id = Argument[0].ToString();
string type = Argument[1].ToString();
int ok;
if (type == "0")
{
ok = 1;
}
else
{
ok = 0;
}
QPS.NEW.BLL.Orderform Border = new QPS.NEW.BLL.Orderform();
QPS.NEW.Model.Orderform order = Border.GetModel(Convert.ToInt32(id));
Border.UpdateType(id, type);
//订单有效 则加上积分 否则 如果存在积分 则删除
QPS.NEW.BLL.Integral Bint = new QPS.NEW.BLL.Integral();
QPS.NEW.Model.Integral Mint = new QPS.NEW.Model.Integral();
if (Bint.GetList("OrderId='" + id + "'").Tables[0].Rows.Count > 0) //删除已有积分
{
Bint.Delete(Convert.ToInt32(Bint.GetList("OrderId='" + id + "'").Tables[0].Rows[0]["Id"]));
}
if (ok == 1)//有效
{
QPS.NEW.BLL.Room Broom = new QPS.NEW.BLL.Room();
QPS.NEW.Model.Room r = Broom.GetModel(order.Roomid);
//Mint.OrderId = Convert.ToInt32(id);
//Mint.RoomId = order.Roomid;
Mint.UserID = order.Userid;
//Mint.CreateTime = order.StartTime;
TimeSpan ts = (TimeSpan)(order.endTime - order.StartTime);
Mint.BankMoney = Convert.ToInt32((ts.Hours * (double)r.RoomPrice));
if (order.Beveragecost != null)
{
Mint.BankMoney += (int)order.Beveragecost;
}
Bint.Add(Mint);
}
}
gdvOrder.DataSource = databind();
gdvOrder.DataBind();
}
public bool Update(QPS.NEW.Model.Orderform 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.OrderNumber != null)
{
filedName[Count] = "OrderNumber";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.OrderNumber);
Count++;
}
if (model.StartTime != null)
{
filedName[Count] = "StartTime";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.StartTime);
Count++;
}
if (model.endTime != null)
{
filedName[Count] = "endTime";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.endTime);
Count++;
}
if (model.Userid != -999)
{
filedName[Count] = "Userid";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Userid);
Count++;
}
if (model.Roomid != -999)
{
filedName[Count] = "Roomid";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Roomid);
Count++;
}
if (model.RoomType != null)
{
filedName[Count] = "RoomType";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.RoomType);
Count++;
}
if (model.Beveragecost != null)
{
filedName[Count] = "Beveragecost";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Beveragecost);
Count++;
}
if (model.IsDelete != -999)
{
filedName[Count] = "IsDelete";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.IsDelete);
Count++;
}
if (model.IsValidity != null)
{
filedName[Count] = "IsValidity";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.IsValidity);
Count++;
}
StringBuilder strSql = new StringBuilder();
strSql.Append("update Orderform set ");
for (int i = 1; i < Count; i++) // i begin with 0 !!!
{
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 QPS.NEW.Model.Orderform GetModel(int Id)
{
QPS.NEW.Model.Orderform orderform = null;
DataTable dt = sqlHelper_.GetDataTable(
"select * from Orderform where Id=@id",
CommandType.Text,
new System.Data.SqlClient.SqlParameter[]
{
new SqlParameter("@id", Id)
}
);
if (dt != null && dt.Rows.Count > 0)
{
orderform = new Model.Orderform();
orderform.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
orderform.OrderNumber = dt.Rows[0]["OrderNumber"].ToString();
if (dt.Rows[0]["StartTime"] == DBNull.Value)
{
orderform.StartTime = null;
}
else
{
orderform.StartTime = Convert.ToDateTime(dt.Rows[0]["StartTime"]);
}
if (dt.Rows[0]["endTime"] == DBNull.Value)
{
orderform.endTime = null;
}
else
{
orderform.endTime = Convert.ToDateTime(dt.Rows[0]["endTime"]);
}
orderform.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
orderform.Roomid = Convert.ToInt32(dt.Rows[0]["Roomid"]);
if (dt.Rows[0]["RoomType"] == DBNull.Value)
{
orderform.RoomType = null;
}
else
{
orderform.RoomType = Convert.ToInt32(dt.Rows[0]["RoomType"]);
}
if (dt.Rows[0]["Beveragecost"] == DBNull.Value)
{
orderform.Beveragecost = null;
}
else
{
orderform.Beveragecost = Convert.ToDecimal(dt.Rows[0]["Beveragecost"]);
}
orderform.IsDelete = Convert.ToInt32(dt.Rows[0]["IsDelete"]);
if (dt.Rows[0]["IsValidity"] == DBNull.Value)
{
orderform.IsValidity = null;
}
else
{
orderform.IsValidity = Convert.ToInt32(dt.Rows[0]["IsValidity"]);
}
}
return(orderform);
}
public int Add(QPS.NEW.Model.Orderform model)
{
int res = 0;
bool isOrdered = false;
string strSql =
"select count(*) from Orderform where Roomid=@roomid and IsDelete=0 and IsValidity=1";
int num = Convert.ToInt32(
sqlHelper_.GetSingle(
strSql,
CommandType.Text,
new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@roomid", model.Roomid)
}
)
);
if (num > 0)
{
isOrdered = true;
}
if (num < 0)
{
res = -1;
throw new Exception("Error:查询数据库失败");
}
if (isOrdered)
{
res = -1;
throw new Exception("Error:房间已被预定");
}
else
{
string[] filedName = new string[50];
string[] paramName = new string[50];
SqlParameter[] sqlParams = new SqlParameter[50];
int Count = 0;
if (model.OrderNumber != null)
{
filedName[Count] = "OrderNumber";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.OrderNumber);
Count++;
}
if (model.StartTime != null)
{
filedName[Count] = "StartTime";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.StartTime);
Count++;
}
if (model.endTime != null)
{
filedName[Count] = "endTime";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.endTime);
Count++;
}
if (model.Userid != -999)
{
filedName[Count] = "Userid";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Userid);
Count++;
}
if (model.Roomid != -999)
{
filedName[Count] = "Roomid";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Roomid);
Count++;
}
if (model.RoomType != null)
{
filedName[Count] = "RoomType";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.RoomType);
Count++;
}
if (model.Beveragecost != null)
{
filedName[Count] = "Beveragecost";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.Beveragecost);
Count++;
}
if (model.IsDelete != -999)
{
filedName[Count] = "IsDelete";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.IsDelete);
Count++;
}
if (model.IsValidity != null)
{
filedName[Count] = "IsValidity";
paramName[Count] = "@" + filedName[Count];
sqlParams[Count] = new SqlParameter(paramName[Count], model.IsValidity);
Count++;
}
StringBuilder strSql_bs = new StringBuilder();
strSql_bs.Append("insert into Orderform(");
for (int i = 0; i < Count; i++)
{
strSql_bs.Append(filedName[i]);
if (i != Count - 1)
{
strSql_bs.Append(",");
}
}
strSql_bs.Append(")values(");
for (int i = 0; i < Count; i++)
{
strSql_bs.Append(paramName[i]);
if (i != Count - 1)
{
strSql_bs.Append(",");
}
}
strSql_bs.Append(")");
num = sqlHelper_.ExecuteCommand(
strSql_bs.ToString(),
CommandType.Text,
sqlParams
);
if (num != 1)
{
res = -1;
throw new Exception("Error:写入数据库失败");
}
else
{
res = 1;
}
}
return(res);
}
