/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_OrderEntity Entity, string DishListJson)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@PKCode", SqlDbType.VarChar, 32)
{
Value = Entity.PKCode
},
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@OrderMoney", Entity.OrderMoney),
new SqlParameter("@Remar", Entity.Remar),
new SqlParameter("@DisNum", Entity.DisNum),
new SqlParameter("@OrderType", Entity.OrderType),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_Order_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 1)
{
Entity.PKCode = sqlParameters[0].Value.ToString();
int disRel = -1;
try
{
//解析json拼接SQL
DataTable dtDish = JsonHelper.ToDataTable(DishListJson);
string dishSql = " declare @odiscode varchar(32);";
dishSql += " declare @podiscode varchar(32);";
dishSql += " set @podiscode='';";
string checkmoneySql = " declare @allmoney decimal(18,2);";
checkmoneySql += " set @allmoney=0; ";
if (dtDish != null && dtDish.Rows.Count > 0)
{
foreach (DataRow dr in dtDish.Rows)
{
string disPrice = dr["price"].ToString();
string totalmoney = "0";
totalmoney = disPrice + "*" + dr["disnum"].ToString() + "+" + dr["cookmoney"].ToString();
string tempSql = " exec[dbo].[p_GetOrderCode] @odiscode output;";
tempSql += " insert into TB_OrderDish([StoCode],[OrderCode],[DisCode],[DisName],[Price],[DisNum],[PKCode],[CookName],[CookMoney],[TotalMoney]) ";
tempSql += " values('" + Entity.StoCode + "','" + Entity.PKCode + "','" + dr["discode"] + "','" + dr["disname"] + "'," + dr["price"] + "," + dr["disnum"] + ",@odiscode,'" + dr["cookname"] + "'," + dr["cookmoney"] + "," + totalmoney + ");";
dishSql += tempSql;
}
disRel = DBHelper.ExecuteNonQuery(dishSql, CommandType.Text, new SqlParameter[] { });
}
}
catch (Exception ex) {}
if (disRel != 0)
{
//删除订单信息，返回失败
string meg = "";
Delete(Entity.PKCode, Entity.StoCode, ref meg);
intReturn = -1;
}
}
return(intReturn);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(string GUID, string UID, TB_OrderEntity UEntity)
{
//更新数据
int result = dal.Update(UEntity);
//检测执行结果
CheckResult(result, "");
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private TB_OrderEntity SetEntityInfo(DataRow dr)
{
TB_OrderEntity Entity = new TB_OrderEntity();
Entity.Id = StringHelper.StringToLong(dr["Id"].ToString());
Entity.StoCode = dr["StoCode"].ToString();
Entity.CCode = dr["CCode"].ToString();
Entity.CCname = dr["CCname"].ToString();
Entity.TStatus = dr["TStatus"].ToString();
Entity.PKCode = dr["PKCode"].ToString();
Entity.OrderMoney = StringHelper.StringToDecimal(dr["OrderMoney"].ToString());
Entity.Remar = dr["Remar"].ToString();
Entity.CheckTime = StringHelper.StringToDateTime(dr["CheckTime"].ToString());
return(Entity);
}
private void Update(Dictionary <string, object> dicPar)
{
//要检测的参数信息
List <string> pra = new List <string>()
{
"GUID", "USER_ID", "Id", "BusCode", "StoCode", "CCode", "CCname", "TStatus", "PKCode", "OpenCodeList", "OrderMoney", "DisNum", "DisTypeNum", "Remar", "CheckTime", "BillCode"
};
//检测方法需要的参数
if (!CheckActionParameters(dicPar, pra))
{
return;
}
//获取参数信息
string GUID = dicPar["GUID"].ToString();
string USER_ID = dicPar["USER_ID"].ToString();
string Id = dicPar["Id"].ToString();
string BusCode = dicPar["BusCode"].ToString();
string StoCode = dicPar["StoCode"].ToString();
string CCode = dicPar["CCode"].ToString();
string CCname = dicPar["CCname"].ToString();
string TStatus = dicPar["TStatus"].ToString();
string PKCode = dicPar["PKCode"].ToString();
string OrderMoney = dicPar["OrderMoney"].ToString();
string Remar = dicPar["Remar"].ToString();
string CheckTime = dicPar["CheckTime"].ToString();
string BillCode = dicPar["BillCode"].ToString();
//调用逻辑
TB_OrderEntity UEntity = bll.GetEntitySigInfo("where pkcode='" + PKCode + "'");
UEntity.Remar = Remar;
UEntity.TStatus = TStatus;
bll.Update(GUID, USER_ID, UEntity);
ReturnResultJson(bll.oResult.Code, bll.oResult.Msg);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(TB_OrderEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@PKCode", Entity.PKCode),
new SqlParameter("@OrderMoney", Entity.OrderMoney),
new SqlParameter("@Remar", Entity.Remar),
new SqlParameter("@CheckTime", Entity.CheckTime),
new SqlParameter("@OrderType", Entity.OrderType),
new SqlParameter("@PayMoney", Entity.PayMoney),
new SqlParameter("@CouponMoney", Entity.CouponMoney),
new SqlParameter("@WxBillCode", Entity.WxBillCode),
new SqlParameter("@CouponCode", Entity.CouponCode),
new SqlParameter("@FTime", Entity.FTime),
};
return(DBHelper.ExecuteNonQuery("dbo.p_TB_Order_Update", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
public bool CheckPageInfo(string type, string Id, string StoCode, string CCode, string CCname, string TStatus, string PKCode, string OrderMoney, string Remar, int OrderType)
{
bool rel = false;
try
{
Entity = new TB_OrderEntity();
Entity.Id = StringHelper.StringToLong(Id);
Entity.StoCode = StoCode;
Entity.CCode = CCode;
Entity.CCname = CCname;
Entity.TStatus = TStatus;
Entity.PKCode = PKCode;
Entity.OrderMoney = StringHelper.StringToDecimal(OrderMoney);
Entity.Remar = Remar;
Entity.OrderType = OrderType;
rel = true;
}
catch (System.Exception)
{
}
return(rel);
}
