/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Eyousoft_yhq.Model.Order model)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_Order_Add");
this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, model.OrderID);
this._db.AddInParameter(cmd, "ProductID", DbType.AnsiStringFixedLength, model.ProductID);
this._db.AddOutParameter(cmd, "OrderCode", DbType.AnsiStringFixedLength, 255);
this._db.AddInParameter(cmd, "MemberID", DbType.AnsiStringFixedLength, model.MemberID);
this._db.AddInParameter(cmd, "MemberName", DbType.String, model.MemberName);
this._db.AddInParameter(cmd, "MemberTel", DbType.String, model.MemberTel);
this._db.AddInParameter(cmd, "MemberSex", DbType.Byte, (int)model.MemberSex);
this._db.AddInParameter(cmd, "OrderState", DbType.Byte, (int)model.OrderState);
this._db.AddInParameter(cmd, "PayState", DbType.Byte, (int)model.PayState);
this._db.AddInParameter(cmd, "IsCheck", DbType.AnsiStringFixedLength, this.GetBooleanToStr(model.IsCheck));
this._db.AddInParameter(cmd, "ConfirmCode", DbType.String, model.ConfirmCode);
this._db.AddInParameter(cmd, "OrderPrice", DbType.Decimal, model.OrderPrice);
this._db.AddInParameter(cmd, "PeopleNum", DbType.Int32, model.PeopleNum);
this._db.AddInParameter(cmd, "Remark", DbType.String, model.Remark);
this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4);
_db.AddInParameter(cmd, "WeiDianId", DbType.AnsiStringFixedLength, model.WeiDianId);
DbHelper.RunProcedureWithResult(cmd, this._db);
model.OrderCode = this._db.GetParameterValue(cmd, "OrderCode").ToString();
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")));
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="OrderID"></param>
/// <returns></returns>
public int Delete(string OrderID)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_Order_Delete");
this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, OrderID);
this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")));
}
/// <summary>
/// 设置支付状态
/// </summary>
/// <param name="OrderID"></param>
/// <returns></returns>
public int ZhiFu(MJiPiaoBaoCun model)
{
DbCommand cmd = _db.GetStoredProcCommand("proc_zhifu");
this._db.AddInParameter(cmd, "memnberId", DbType.AnsiStringFixedLength, model.OpeatorID);
this._db.AddInParameter(cmd, "orderid", DbType.AnsiStringFixedLength, model.OrderID);
this._db.AddInParameter(cmd, "price", DbType.Decimal, model.OrderPrice);
this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")));
}
public int SavePDF(Eyousoft_yhq.Model.Order model)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_Order_UpdatePDF");
this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, model.OrderID);
this._db.AddInParameter(cmd, "ComAttachXML", DbType.Xml, CreateComNoticeXML(model.SendFile));
this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")));
}
/// <summary>
/// 账户支付订单
/// </summary>
/// <param name="dingdan">订单</param>
/// <param name="huiyuanbianhao">支付人</param>
/// <returns></returns>
public int XiaoFei(Eyousoft_yhq.Model.Order dingdan, string huiyuanbianhao)
{
DbCommand cmd = _db.GetStoredProcCommand("proc_XiaoFei");
this._db.AddInParameter(cmd, "HuiYuanBianHao", DbType.AnsiStringFixedLength, huiyuanbianhao);
this._db.AddInParameter(cmd, "DingDanBianHao", DbType.AnsiStringFixedLength, dingdan.OrderID);
this._db.AddInParameter(cmd, "DingDanZT", DbType.Byte, dingdan.PayState);
this._db.AddInParameter(cmd, "JinE", DbType.Decimal, dingdan.OrderPrice);
this._db.AddOutParameter(cmd, "result", DbType.Int32, 4);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")));
}
/// <summary>
/// 修改订单支付状态
/// </summary>
/// <param name="OrderID"></param>
/// <returns></returns>
public int UpdatePayState(Eyousoft_yhq.Model.Order Model)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_OrderState_Update");
this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, Model.OrderID);
this._db.AddInParameter(cmd, "PayState", DbType.Byte, (int)Model.PayState);
this._db.AddInParameter(cmd, "ConfirmCode", DbType.AnsiStringFixedLength, Model.ConfirmCode);
this._db.AddInParameter(cmd, "OrderState", DbType.Byte, (int)Model.OrderState);
this._db.AddInParameter(cmd, "JState", DbType.Byte, (int)Model.JIESUAN);
this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")));
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Eyousoft_yhq.Model.Order model)
{
DbCommand cmd = this._db.GetStoredProcCommand("proc_Order_Update");
this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, model.OrderID);
this._db.AddInParameter(cmd, "OrderState", DbType.Byte, (int)model.OrderState);
this._db.AddInParameter(cmd, "OrderPrice", DbType.Decimal, model.OrderPrice);
this._db.AddInParameter(cmd, "Remark", DbType.String, model.Remark);
this._db.AddOutParameter(cmd, "Result", DbType.Int32, 4);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")));
}
/// <summary>
/// 产品添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Eyousoft_yhq.Model.Product model)
{
DbCommand cmd = this._db.GetStoredProcCommand("Proc_Product_Add");
_db.AddInParameter(cmd, "ProductID", DbType.String, model.ProductID);
_db.AddInParameter(cmd, "ProductName", DbType.String, model.ProductName);
_db.AddInParameter(cmd, "ProductType", DbType.Int32, model.ProductType);
_db.AddInParameter(cmd, "TourDate", DbType.DateTime, model.TourDate);
_db.AddInParameter(cmd, "MarketPrice", DbType.Decimal, model.MarketPrice);
_db.AddInParameter(cmd, "AppPrice", DbType.Decimal, model.AppPrice);
_db.AddInParameter(cmd, "FavourCode", DbType.String, model.FavourCode);
_db.AddInParameter(cmd, "LinkTel", DbType.String, model.LinkTel);
_db.AddInParameter(cmd, "ProductDis", DbType.String, model.ProductDis);
_db.AddInParameter(cmd, "TourDis", DbType.String, model.TourDis);
_db.AddInParameter(cmd, "SendTourKnow", DbType.String, model.SendTourKnow);
_db.AddInParameter(cmd, "ValidiDate", DbType.String, model.ValidiDate);
_db.AddInParameter(cmd, "ProductState", DbType.Byte, model.ProductState);
_db.AddInParameter(cmd, "ComAttachXML", DbType.Xml, CreateComNoticeXML(model.AttachList));
_db.AddInParameter(cmd, "IsEveryDay", DbType.Byte, model.IsEveryDay);
_db.AddInParameter(cmd, "IsHot", DbType.Int32, model.IsHot);
_db.AddInParameter(cmd, "ServiceQQ", DbType.String, model.ServiceQQ);
_db.AddInParameter(cmd, "ContractType", DbType.Byte, (int)model.ContractType);
_db.AddInParameter(cmd, "ControlPeople", DbType.Int32, model.ControlPeople);
_db.AddInParameter(cmd, "Scompare", DbType.String, model.Scompare);
#region 车票 门票修改
_db.AddInParameter(cmd, "ProductOpState", DbType.Byte, model.ProductOpState);
_db.AddInParameter(cmd, "ProductSdate", DbType.DateTime, model.ProductSdate);
_db.AddInParameter(cmd, "ZCodeViaDate", DbType.DateTime, model.ZCodeViaDate);
_db.AddInParameter(cmd, "PType", DbType.Int32, model.PType);
#endregion
this._db.AddOutParameter(cmd, "result", DbType.Int32, 4);
_db.AddInParameter(cmd, "FaBuRenId", DbType.AnsiStringFixedLength, model.FaBuRenId);
_db.AddInParameter(cmd, "ShenHeStatus", DbType.Int32, model.ShenHeStatus);
DbHelper.RunProcedureWithResult(cmd, this._db);
return(Convert.ToInt32(this._db.GetParameterValue(cmd, "Result")) > 0 ? true : false);
}
