/// <summary>
/// 获得商品ID
/// </summary>
/// <param name="singleGoodinfo">单个商品对象</param>
/// <returns>商品id</returns>
public static int SingleGoodIDGetGoodFromSingleGood(SingleGoodInfo singleGoodinfo)
{
string sqlstring = "select GoodID from SingleGoodInfo where SingleGoodID='" + singleGoodinfo.SingleGoodID + "'";
Object obj = SqlHelper.ReadSclar(sqlstring);
int TempGoodID = Convert.ToInt32(obj);
return(TempGoodID);
}
/// <summary>
/// 商品ID获取单个商品ID
/// </summary>
/// <param name="singleGoodinfo">单个商品信息</param>
/// <returns>单个商品ID</returns>
public static int mGoodIDGetSingleGoodID(SingleGoodInfo singleGoodinfo)
{
string sqlstring = "select SingleGoodID from SaveSingleGoodInfo where GoodID='" + singleGoodinfo.GoodID + "' and IsDeal =0";
Object obj = SqlHelper.ReadSclar(sqlstring);
int TempSingleGoodID = Convert.ToInt32(obj);
return(TempSingleGoodID);
}
/// <summary>
/// 添加单个商品
/// </summary>
/// <param name="singleGoodinfo">单个商品对象</param>
/// <returns>成功或失败</returns>
public bool AddSingleGoodInfo(SingleGoodInfo singleGoodinfo)
{
string sqlString = "insert SingleGoodInfo(GoodID,StaffID) values('" + singleGoodinfo.GoodID + "','" + singleGoodinfo.StaffID + "')";
if (SqlHelper.ExecuteNonQuery(sqlString) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 对订单的修改
/// </summary>
/// <returns></returns>
public bool AlterOrderStatus(SaveOrders alter)
{
string sqlstring = "update Orders set TradeStatus ='" + alter.TradeStatus + "'" + "where OrderID='" + alter.OrderID + "'" + ";update SaveOrders set TradeStatus ='" + alter.TradeStatus + "'" + "where OrderID='" + alter.OrderID + "'" + ";update SaveOrders set IsDeal ='" + alter.IsDeal + "'" + "where OrderID='" + alter.OrderID + "'" + ";update Orders set IsDeal ='" + alter.IsDeal + "'" + "where OrderID='" + alter.OrderID + "'" + ";update SaveOrders set StaffID='" + alter.StaffID + "'" + "where OrderID='" + alter.OrderID + "'" + ";update Orders set StaffID='" + alter.StaffID + "'" + "where OrderID='" + alter.OrderID + "'";
string sqlstring2 = "select UserInfo.MoneySum from StoreUser left join UserInfo on UserInfo.UserID=StoreUser.UserID where UserName='******'";
StoreUser mStore = new StoreUser();
mStore.UserName = alter.ReceiveStr;
int TempUserID = StoreUser.UserNameGetID(mStore);
int Money = Convert.ToInt32(SqlHelper.ReadSclar(sqlstring2)) + Convert.ToInt32(alter.TotalPrices);
string sqlstring3 = "update UserInfo set MoneySum ='" + Money + "'" + "where UserID='" + TempUserID + "'";
if (alter.TradeStatus == '3' && alter.Number != 0)
{
string sqlstring4 = "select Good.SalesVolume from SaveOrders left join SaveSingleGoodInfo on SaveOrders.SingleGoodID=SaveSingleGoodInfo.SingleGoodID left join Good on SaveSingleGoodInfo.GoodID=Good.GoodID where OrderID='" + alter.OrderID + "'";
string sqlstring5 = "select GoodID from SaveOrders left join SaveSingleGoodInfo on SaveOrders.SingleGoodID=SaveSingleGoodInfo.SingleGoodID where OrderID='" + alter.OrderID + "'";
int SalesVolume = (Convert.ToInt32(SqlHelper.ReadSclar(sqlstring4)) + alter.Number);
int GoodID = Convert.ToInt32(SqlHelper.ReadSclar(sqlstring5));
string sqlstring6 = "update Good set SalesVolume='" + SalesVolume + "'" + " where GoodID='" + GoodID + "'";
string sqlstring8 = "select Good.GoodIncentory from SaveOrders left join SaveSingleGoodInfo on SaveOrders.SingleGoodID=SaveSingleGoodInfo.SingleGoodID left join Good on SaveSingleGoodInfo.GoodID=Good.GoodID where OrderID='" + alter.OrderID + "'";
int GoodIncentory = (Convert.ToInt32(SqlHelper.ReadSclar(sqlstring8)) - alter.Number);
string sqlstring7 = "update Good set GoodIncentory='" + GoodIncentory + "'" + " where GoodID='" + GoodID + "'";
SingleGoodInfo mSingleGoodInfo = new SingleGoodInfo();
mSingleGoodInfo.SingleGoodID = alter.SingleGoodID;
int TempGoodID = SingleGoodInfo.SingleGoodIDGetGood(mSingleGoodInfo);
string sqlstring1 = "delete top(" + alter.Number + ") from SaveSingleGoodInfo where GoodID='" + TempGoodID + "'";
if (SqlHelper.ExecuteNonQuery(sqlstring) > 0 && SqlHelper.ExecuteNonQuery(sqlstring1) > 0 && SqlHelper.ExecuteNonQuery(sqlstring3) > 0 && SqlHelper.ExecuteNonQuery(sqlstring6) > 0 && SqlHelper.ExecuteNonQuery(sqlstring7) > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
if (SqlHelper.ExecuteNonQuery(sqlstring) > 0)
{
return(true);
}
else
{
return(false);
}
}
}
} // 为string类型
/// <summary>
/// 评价订单
/// </summary>
/// <returns>是否评价成功</returns>
public bool OrderEvaluate()
{
string singleGoodid = "select SingleGoodID from Orders where OrderID='" + this.OrderID + "'";
SingleGoodInfo single = new SingleGoodInfo();
single.SingleGoodID = Convert.ToInt32(SqlHelper.ReadSclar(singleGoodid));
int goodID = SingleGoodInfo.SingleGoodIDGetGoodFromSingleGood(single);
string lEvaluate = "insert into GoodEvaluate (GoodID,EvaluateContent, EvaluateTime,UserID,EvaluateGrade,OrderID) values ('" + goodID + "',N'" + this.EvaluateContent + "',getdate(),'" + this.userID + "','" + this.EvaluateGrade + "','" + this.OrderID + "')";
string lIsEvaluate = "update Orders set IsEvaluate='" + 1 + "' where OrderID='" + this.OrderID + "'";
string lIsevaluate = "update SaveOrders set IsEvaluate='" + 1 + "' where OrderID='" + this.OrderID + "'";
if (SqlHelper.ExecuteNonQuery(lEvaluate) > 0 && SqlHelper.ExecuteNonQuery(lIsevaluate) > 0 && SqlHelper.ExecuteNonQuery(lIsEvaluate) > 0)
{
return(true);
}
else
{
return(false);
}
}
