/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.OrderingList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OrderingList(");
strSql.Append("EmployeeID,DateTime,OrderOne,DinOne,OrderOneTime,DiningOneTime,OrderTwo,DinTwo,OrdeTwoTime,DiningTwoTime,OrderThree,DinThree,OrdeThreeTime,DiningThreeTime,OrderCount,DinCount,Money,IsSum)");
strSql.Append(" values (");
strSql.Append("@EmployeeID,@DateTime,@OrderOne,@DinOne,@OrderOneTime,@DiningOneTime,@OrderTwo,@DinTwo,@OrdeTwoTime,@DiningTwoTime,@OrderThree,@DinThree,@OrdeThreeTime,@DiningThreeTime,@OrderCount,@DinCount,@Money,@IsSum)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@EmployeeID", SqlDbType.Int, 4),
new SqlParameter("@DateTime", SqlDbType.DateTime),
new SqlParameter("@OrderOne", SqlDbType.Int, 4),
new SqlParameter("@DinOne", SqlDbType.Int, 4),
new SqlParameter("@OrderOneTime", SqlDbType.DateTime),
new SqlParameter("@DiningOneTime", SqlDbType.DateTime),
new SqlParameter("@OrderTwo", SqlDbType.Int, 4),
new SqlParameter("@DinTwo", SqlDbType.Int, 4),
new SqlParameter("@OrdeTwoTime", SqlDbType.DateTime),
new SqlParameter("@DiningTwoTime", SqlDbType.DateTime),
new SqlParameter("@OrderThree", SqlDbType.Int, 4),
new SqlParameter("@DinThree", SqlDbType.Int, 4),
new SqlParameter("@OrdeThreeTime", SqlDbType.DateTime),
new SqlParameter("@DiningThreeTime", SqlDbType.DateTime),
new SqlParameter("@OrderCount", SqlDbType.Int, 4),
new SqlParameter("@DinCount", SqlDbType.Int, 4),
new SqlParameter("@Money", SqlDbType.Decimal, 9),
new SqlParameter("@IsSum", SqlDbType.Bit, 1)
};
parameters[0].Value = model.EmployeeID;
parameters[1].Value = model.DateTime;
parameters[2].Value = model.OrderOne;
parameters[3].Value = model.DinOne;
parameters[4].Value = model.OrderOneTime;
parameters[5].Value = model.DiningOneTime;
parameters[6].Value = model.OrderTwo;
parameters[7].Value = model.DinTwo;
parameters[8].Value = model.OrdeTwoTime;
parameters[9].Value = model.DiningTwoTime;
parameters[10].Value = model.OrderThree;
parameters[11].Value = model.DinThree;
parameters[12].Value = model.OrdeThreeTime;
parameters[13].Value = model.DiningThreeTime;
parameters[14].Value = model.OrderCount;
parameters[15].Value = model.DinCount;
parameters[16].Value = model.Money;
parameters[17].Value = model.IsSum;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Hownet.Model.OrderingList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OrderingList set ");
strSql.Append("EmployeeID=@EmployeeID,");
strSql.Append("DateTime=@DateTime,");
strSql.Append("OrderOne=@OrderOne,");
strSql.Append("DinOne=@DinOne,");
strSql.Append("OrderOneTime=@OrderOneTime,");
strSql.Append("DiningOneTime=@DiningOneTime,");
strSql.Append("OrderTwo=@OrderTwo,");
strSql.Append("DinTwo=@DinTwo,");
strSql.Append("OrdeTwoTime=@OrdeTwoTime,");
strSql.Append("DiningTwoTime=@DiningTwoTime,");
strSql.Append("OrderThree=@OrderThree,");
strSql.Append("DinThree=@DinThree,");
strSql.Append("OrdeThreeTime=@OrdeThreeTime,");
strSql.Append("DiningThreeTime=@DiningThreeTime,");
strSql.Append("OrderCount=@OrderCount,");
strSql.Append("DinCount=@DinCount,");
strSql.Append("Money=@Money,");
strSql.Append("IsSum=@IsSum");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@EmployeeID", SqlDbType.Int, 4),
new SqlParameter("@DateTime", SqlDbType.DateTime),
new SqlParameter("@OrderOne", SqlDbType.Int, 4),
new SqlParameter("@DinOne", SqlDbType.Int, 4),
new SqlParameter("@OrderOneTime", SqlDbType.DateTime),
new SqlParameter("@DiningOneTime", SqlDbType.DateTime),
new SqlParameter("@OrderTwo", SqlDbType.Int, 4),
new SqlParameter("@DinTwo", SqlDbType.Int, 4),
new SqlParameter("@OrdeTwoTime", SqlDbType.DateTime),
new SqlParameter("@DiningTwoTime", SqlDbType.DateTime),
new SqlParameter("@OrderThree", SqlDbType.Int, 4),
new SqlParameter("@DinThree", SqlDbType.Int, 4),
new SqlParameter("@OrdeThreeTime", SqlDbType.DateTime),
new SqlParameter("@DiningThreeTime", SqlDbType.DateTime),
new SqlParameter("@OrderCount", SqlDbType.Int, 4),
new SqlParameter("@DinCount", SqlDbType.Int, 4),
new SqlParameter("@Money", SqlDbType.Decimal, 9),
new SqlParameter("@IsSum", SqlDbType.Bit, 1)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.EmployeeID;
parameters[2].Value = model.DateTime;
parameters[3].Value = model.OrderOne;
parameters[4].Value = model.DinOne;
parameters[5].Value = model.OrderOneTime;
parameters[6].Value = model.DiningOneTime;
parameters[7].Value = model.OrderTwo;
parameters[8].Value = model.DinTwo;
parameters[9].Value = model.OrdeTwoTime;
parameters[10].Value = model.DiningTwoTime;
parameters[11].Value = model.OrderThree;
parameters[12].Value = model.DinThree;
parameters[13].Value = model.OrdeThreeTime;
parameters[14].Value = model.DiningThreeTime;
parameters[15].Value = model.OrderCount;
parameters[16].Value = model.DinCount;
parameters[17].Value = model.Money;
parameters[18].Value = model.IsSum;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Hownet.Model.OrderingList GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,EmployeeID,DateTime,OrderOne,DinOne,OrderOneTime,DiningOneTime,OrderTwo,DinTwo,OrdeTwoTime,DiningTwoTime,OrderThree,DinThree,OrdeThreeTime,DiningThreeTime,OrderCount,DinCount,Money,IsSum from OrderingList ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Hownet.Model.OrderingList model = new Hownet.Model.OrderingList();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["EmployeeID"].ToString() != "")
{
model.EmployeeID = int.Parse(ds.Tables[0].Rows[0]["EmployeeID"].ToString());
}
if (ds.Tables[0].Rows[0]["DateTime"].ToString() != "")
{
model.DateTime = DateTime.Parse(ds.Tables[0].Rows[0]["DateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderOne"].ToString() != "")
{
model.OrderOne = int.Parse(ds.Tables[0].Rows[0]["OrderOne"].ToString());
}
if (ds.Tables[0].Rows[0]["DinOne"].ToString() != "")
{
model.DinOne = int.Parse(ds.Tables[0].Rows[0]["DinOne"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderOneTime"].ToString() != "")
{
model.OrderOneTime = DateTime.Parse(ds.Tables[0].Rows[0]["OrderOneTime"].ToString());
}
if (ds.Tables[0].Rows[0]["DiningOneTime"].ToString() != "")
{
model.DiningOneTime = DateTime.Parse(ds.Tables[0].Rows[0]["DiningOneTime"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderTwo"].ToString() != "")
{
model.OrderTwo = int.Parse(ds.Tables[0].Rows[0]["OrderTwo"].ToString());
}
if (ds.Tables[0].Rows[0]["DinTwo"].ToString() != "")
{
model.DinTwo = int.Parse(ds.Tables[0].Rows[0]["DinTwo"].ToString());
}
if (ds.Tables[0].Rows[0]["OrdeTwoTime"].ToString() != "")
{
model.OrdeTwoTime = DateTime.Parse(ds.Tables[0].Rows[0]["OrdeTwoTime"].ToString());
}
if (ds.Tables[0].Rows[0]["DiningTwoTime"].ToString() != "")
{
model.DiningTwoTime = DateTime.Parse(ds.Tables[0].Rows[0]["DiningTwoTime"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderThree"].ToString() != "")
{
model.OrderThree = int.Parse(ds.Tables[0].Rows[0]["OrderThree"].ToString());
}
if (ds.Tables[0].Rows[0]["DinThree"].ToString() != "")
{
model.DinThree = int.Parse(ds.Tables[0].Rows[0]["DinThree"].ToString());
}
if (ds.Tables[0].Rows[0]["OrdeThreeTime"].ToString() != "")
{
model.OrdeThreeTime = DateTime.Parse(ds.Tables[0].Rows[0]["OrdeThreeTime"].ToString());
}
if (ds.Tables[0].Rows[0]["DiningThreeTime"].ToString() != "")
{
model.DiningThreeTime = DateTime.Parse(ds.Tables[0].Rows[0]["DiningThreeTime"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderCount"].ToString() != "")
{
model.OrderCount = int.Parse(ds.Tables[0].Rows[0]["OrderCount"].ToString());
}
if (ds.Tables[0].Rows[0]["DinCount"].ToString() != "")
{
model.DinCount = int.Parse(ds.Tables[0].Rows[0]["DinCount"].ToString());
}
if (ds.Tables[0].Rows[0]["Money"].ToString() != "")
{
model.Money = decimal.Parse(ds.Tables[0].Rows[0]["Money"].ToString());
}
if (ds.Tables[0].Rows[0]["IsSum"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsSum"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsSum"].ToString().ToLower() == "true"))
{
model.IsSum = true;
}
else
{
model.IsSum = false;
}
}
model.A = 1;
return(model);
}
else
{
return(null);
}
}
public string Ordering(string EID)
{
try
{
int _eid = Convert.ToInt32(EID);
}
catch
{
return("员工不正确");
}
bool t = false;
Hownet.BLL.MiniEmp bllME = new Hownet.BLL.MiniEmp();
Hownet.Model.MiniEmp modME = bllME.GetModel(Convert.ToInt32(EID));
if (modME == null)
{
return("员工不正确");
}
if (Convert.ToDateTime(modME.DimDate) > Convert.ToDateTime("1900-1-1"))
{
return("员工已离职！");
}
string mes = string.Empty;
int olTypeID = GetTypeID();
if (olTypeID < 4)
{
DataTable dtOL = new DataTable();
Hownet.BLL.OrderingList bllOL = new Hownet.BLL.OrderingList();
Hownet.Model.OrderingList modOL;
if (BasicTable.modST.OderOne > BasicTable.modST.OderThree && olTypeID == 1)
{
dtOL = bllOL.GetList("(EmployeeID=" + EID + ") And (DateTime='" + DateTime.Today.AddDays(BasicTable.modST.OrderDays + 1) + "')").Tables[0];
}
else
{
dtOL = bllOL.GetList("(EmployeeID=" + EID + ") And (DateTime='" + DateTime.Today.AddDays(BasicTable.modST.OrderDays) + "')").Tables[0];
}
if (dtOL.Rows.Count == 0)
{
modOL = new Hownet.Model.OrderingList();
modOL.EmployeeID = Convert.ToInt32(EID);
modOL.DateTime = DateTime.Today.AddDays(BasicTable.modST.OrderDays);
if (olTypeID == 1)
{
if (BasicTable.modST.OderOne > BasicTable.modST.OderThree)
{
modOL.DateTime = DateTime.Today.AddDays(BasicTable.modST.OrderDays + 1);
}
modOL.OrderOne = 1;
modOL.DinOne = modOL.OrderTwo = modOL.DinTwo = modOL.OrderThree = modOL.DinThree = 0;
modOL.OrderOneTime = DateTime.Now;
modOL.DiningOneTime = modOL.OrdeTwoTime = modOL.DiningTwoTime = modOL.OrdeThreeTime = modOL.DiningThreeTime = DateTime.Parse("1900-1-1");
modOL.OrderCount = 1;
modOL.DinCount = 0;
}
else if (olTypeID == 2)
{
modOL.OrderTwo = 1;
modOL.DinOne = modOL.OrderOne = modOL.DinTwo = modOL.OrderThree = modOL.DinThree = 0;
modOL.OrdeTwoTime = DateTime.Now;
modOL.DiningOneTime = modOL.OrderOneTime = modOL.DiningTwoTime = modOL.OrdeThreeTime = modOL.DiningThreeTime = DateTime.Parse("1900-1-1");
modOL.OrderCount = 1;
modOL.DinCount = 0;
}
else if (olTypeID == 3)
{
modOL.OrderThree = 1;
modOL.DinOne = modOL.OrderOne = modOL.DinTwo = modOL.OrderTwo = modOL.DinThree = 0;
modOL.OrdeThreeTime = DateTime.Now;
modOL.DiningOneTime = modOL.OrderOneTime = modOL.DiningTwoTime = modOL.OrdeTwoTime = modOL.DiningThreeTime = DateTime.Parse("1900-1-1");
modOL.OrderCount = 1;
modOL.DinCount = 0;
}
bllOL.Add(modOL);
}
else
{
modOL = bllOL.GetModel(Convert.ToInt32(dtOL.Rows[0]["ID"]));
if (olTypeID == 1)
{
if (modOL.OrderOne == 0)
{
modOL.OrderOne = 1;
modOL.OrderOneTime = DateTime.Now;
t = true;
}
}
else if (olTypeID == 2)
{
if (modOL.OrderTwo == 0)
{
modOL.OrderTwo = 1;
modOL.OrdeTwoTime = DateTime.Now;
t = true;
}
}
else if (olTypeID == 3)
{
if (modOL.OrderThree == 0)
{
modOL.OrderThree = 1;
modOL.OrdeThreeTime = DateTime.Now;
t = true;
}
}
}
if (t)
{
modOL.OrderCount += 1;
bllOL.Update(modOL);
}
mes = modME.Name + " 预订";
if (BasicTable.modST.OderOne > BasicTable.modST.OderThree && olTypeID == 1)
{
mes = mes + DateTime.Today.AddDays(BasicTable.modST.OrderDays + 1).Day.ToString() + "日";
}
else
{
mes = mes + DateTime.Today.AddDays(BasicTable.modST.OrderDays).Day.ToString() + "日";
}
if (olTypeID == 1)
{
mes = mes + "早餐";
}
if (olTypeID == 2)
{
mes = mes + "午餐";
}
if (olTypeID == 3)
{
mes = mes + "晚餐";
}
mes = mes + "成功";
}
else
{
mes = "已经打烊不订餐了";
}
return(mes);
}
