1363 lines
68 KiB
C#
1363 lines
68 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Text;
|
|
using System.Data.SqlClient;
|
|
|
|
|
|
namespace Mtxfw.DAL
|
|
{
|
|
/// <summary>
|
|
/// 数据访问类:business_info
|
|
/// </summary>
|
|
public partial class order_info : Mtxfw.Utility.Myabstract
|
|
{
|
|
public order_info()
|
|
: base("order_info")
|
|
{ }
|
|
|
|
/// <summary>
|
|
/// 增加一条数据
|
|
/// </summary>
|
|
public int Add(Mtxfw.Model.order_info model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("insert into order_info(");
|
|
strSql.Append("pid,poid,pcount,ypcount,addressid,orderid,selcolor,guige,Contactname,Contacttel,Province,City,County,IFFill,Tradingarea,Address,Zipcode,Guests,Totalprice,JFTotalprice,Totalprice0,Totalprice1,Totalprice2,Totalprice3,Totalprice4,Totalprice5,Totalprice6,Totalprice7,Totalprice8,Totalprice9,Totalprice10,Totalnum,O_Submit,O_yhj,UserID,MemberId,ZTMemberId,utype,ttype,ttype0,ptype,ptgroup,ifxnhy,ypznum,ifxhpt,peitype,gtype)");
|
|
strSql.Append(" values (");
|
|
strSql.Append("@pid,@poid,@pcount,@ypcount,@addressid,@orderid,@selcolor,@guige,@Contactname,@Contacttel,@Province,@City,@County,@IFFill,@Tradingarea,@Address,@Zipcode,@Guests,@Totalprice,@JFTotalprice,@Totalprice0,@Totalprice1,@Totalprice2,@Totalprice3,@Totalprice4,@Totalprice5,@Totalprice6,@Totalprice7,@Totalprice8,@Totalprice9,@Totalprice10,@Totalnum,@O_Submit,@O_yhj,@UserID,@MemberId,@ZTMemberId,@utype,@ttype,@ttype0,@ptype,@ptgroup,@ifxnhy,@ypznum,@ifxhpt,@peitype,@gtype)");
|
|
strSql.Append(";select SCOPE_IDENTITY()");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@pid", SqlDbType.Int),
|
|
new SqlParameter("@poid", SqlDbType.Int),
|
|
new SqlParameter("@pcount", SqlDbType.Int),
|
|
new SqlParameter("@ypcount", SqlDbType.Int),
|
|
new SqlParameter("@addressid", SqlDbType.Int),
|
|
new SqlParameter("@orderid", SqlDbType.VarChar,50),
|
|
new SqlParameter("@selcolor", SqlDbType.VarChar,100),
|
|
new SqlParameter("@guige", SqlDbType.VarChar,100),
|
|
new SqlParameter("@Contactname", SqlDbType.VarChar,100),
|
|
new SqlParameter("@Contacttel", SqlDbType.VarChar,50),
|
|
new SqlParameter("@Province", SqlDbType.VarChar,50),
|
|
new SqlParameter("@City", SqlDbType.VarChar,50),
|
|
new SqlParameter("@County", SqlDbType.VarChar,50),
|
|
new SqlParameter("@IFFill", SqlDbType.Int),
|
|
new SqlParameter("@Tradingarea", SqlDbType.VarChar,100),
|
|
new SqlParameter("@Address", SqlDbType.VarChar,100),
|
|
new SqlParameter("@Zipcode", SqlDbType.VarChar,100),
|
|
new SqlParameter("@Guests", SqlDbType.VarChar,8000),
|
|
new SqlParameter("@Totalprice", SqlDbType.Money),
|
|
new SqlParameter("@JFTotalprice", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice0", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice1", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice2", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice3", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice4", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice5", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice6", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice7", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice8", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice9", SqlDbType.Money),
|
|
new SqlParameter("@Totalprice10", SqlDbType.Money),
|
|
new SqlParameter("@Totalnum", SqlDbType.Int),
|
|
new SqlParameter("@O_Submit", SqlDbType.VarChar,50),
|
|
new SqlParameter("@O_yhj", SqlDbType.VarChar,100),
|
|
new SqlParameter("@UserID", SqlDbType.Int),
|
|
new SqlParameter("@MemberId", SqlDbType.Int),
|
|
new SqlParameter("@ZTMemberId", SqlDbType.Int),
|
|
new SqlParameter("@utype", SqlDbType.VarChar,20),
|
|
new SqlParameter("@ttype", SqlDbType.Int),
|
|
new SqlParameter("@ttype0", SqlDbType.Int),
|
|
new SqlParameter("@ptype", SqlDbType.Int),
|
|
new SqlParameter("@ptgroup", SqlDbType.Int),
|
|
new SqlParameter("@ifxnhy", SqlDbType.Int),
|
|
new SqlParameter("@ypznum", SqlDbType.Int),
|
|
new SqlParameter("@ifxhpt", SqlDbType.Int),
|
|
new SqlParameter("@peitype", SqlDbType.Int),
|
|
new SqlParameter("@gtype", SqlDbType.Int)};
|
|
parameters[0].Value = model.pid;
|
|
parameters[1].Value = model.poid;
|
|
parameters[2].Value = model.pcount;
|
|
parameters[3].Value = model.ypcount;
|
|
parameters[4].Value = model.addressid;
|
|
parameters[5].Value = model.orderid;
|
|
parameters[6].Value = model.selcolor;
|
|
parameters[7].Value = model.guige;
|
|
parameters[8].Value = model.Contactname;
|
|
parameters[9].Value = model.Contacttel;
|
|
parameters[10].Value = model.Province;
|
|
parameters[11].Value = model.City;
|
|
parameters[12].Value = model.County;
|
|
parameters[13].Value = model.IFFill;
|
|
parameters[14].Value = model.Tradingarea;
|
|
parameters[15].Value = model.Address;
|
|
parameters[16].Value = model.Zipcode;
|
|
parameters[17].Value = model.Guests;
|
|
parameters[18].Value = model.Totalprice;
|
|
parameters[19].Value = model.JFTotalprice;
|
|
parameters[20].Value = model.Totalprice0;
|
|
parameters[21].Value = model.Totalprice1;
|
|
parameters[22].Value = model.Totalprice2;
|
|
parameters[23].Value = model.Totalprice3;
|
|
parameters[24].Value = model.Totalprice4;
|
|
parameters[25].Value = model.Totalprice5;
|
|
parameters[26].Value = model.Totalprice6;
|
|
parameters[27].Value = model.Totalprice7;
|
|
parameters[28].Value = model.Totalprice8;
|
|
parameters[29].Value = model.Totalprice9;
|
|
parameters[30].Value = model.Totalprice10;
|
|
parameters[31].Value = model.Totalnum;
|
|
parameters[32].Value = model.O_Submit;
|
|
parameters[33].Value = model.O_yhj;
|
|
parameters[34].Value = model.UserID;
|
|
parameters[35].Value = model.MemberId;
|
|
parameters[36].Value = model.ZTMemberId;
|
|
parameters[37].Value = model.utype;
|
|
parameters[38].Value = model.ttype;
|
|
parameters[39].Value = model.ttype0;
|
|
parameters[40].Value = model.ptype;
|
|
parameters[41].Value = model.ptgroup;
|
|
parameters[42].Value = model.ifxnhy;
|
|
parameters[43].Value = model.ypznum;
|
|
parameters[44].Value = model.ifxhpt;
|
|
parameters[45].Value = model.peitype;
|
|
parameters[46].Value = model.gtype;
|
|
object obj = Mtxfw.Utility.SqlDbHelper_U.GetObject(strSql.ToString(), parameters);
|
|
if (obj.ToString() == "")
|
|
{
|
|
return 0;
|
|
}
|
|
else
|
|
{
|
|
return Convert.ToInt32(obj);
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 更新送货信息
|
|
/// </summary>
|
|
public int Update(Mtxfw.Model.order_info model)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
strSql.Append("Contactname=@Contactname");
|
|
strSql.Append(",Contacttel=@Contacttel");
|
|
strSql.Append(",Province=@Province");
|
|
strSql.Append(",City=@City");
|
|
strSql.Append(",County=@County");
|
|
strSql.Append(",IFFill=@IFFill");
|
|
strSql.Append(",Tradingarea=@Tradingarea");
|
|
strSql.Append(",Address=@Address");
|
|
strSql.Append(",Zipcode=@Zipcode");
|
|
strSql.Append(",Guests=@Guests");
|
|
strSql.Append(" where Id=@Id");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@Contactname", SqlDbType.VarChar,100),
|
|
new SqlParameter("@Contacttel", SqlDbType.VarChar,50),
|
|
new SqlParameter("@Province", SqlDbType.VarChar,50),
|
|
new SqlParameter("@City", SqlDbType.VarChar,50),
|
|
new SqlParameter("@County", SqlDbType.VarChar,50),
|
|
new SqlParameter("@IFFill", SqlDbType.Int),
|
|
new SqlParameter("@Tradingarea", SqlDbType.VarChar,100),
|
|
new SqlParameter("@Address", SqlDbType.VarChar,100),
|
|
new SqlParameter("@Zipcode", SqlDbType.VarChar,100),
|
|
new SqlParameter("@Guests", SqlDbType.VarChar,8000),
|
|
new SqlParameter("@Id", SqlDbType.Int,4)};
|
|
parameters[0].Value = model.Contactname;
|
|
parameters[1].Value = model.Contacttel;
|
|
parameters[2].Value = model.Province;
|
|
parameters[3].Value = model.City;
|
|
parameters[4].Value = model.County;
|
|
parameters[5].Value = model.IFFill;
|
|
parameters[6].Value = model.Tradingarea;
|
|
parameters[7].Value = model.Address;
|
|
parameters[8].Value = model.Zipcode;
|
|
parameters[9].Value = model.Guests;
|
|
parameters[10].Value = model.Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新配送信息
|
|
/// </summary>
|
|
public int Updateaddressid(int addressid, int Id)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
strSql.Append("addressid=@addressid");
|
|
strSql.Append(" where Id=@Id");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@addressid", SqlDbType.Int),
|
|
new SqlParameter("@Id", SqlDbType.Int,4)};
|
|
parameters[0].Value = addressid;
|
|
parameters[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新总价
|
|
/// </summary>
|
|
public int UpdateTotalprice(Double Totalprice, int Id)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
strSql.Append("Totalprice=@Totalprice");
|
|
strSql.Append(" where Id=@Id");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@Totalprice", SqlDbType.Money),
|
|
new SqlParameter("@Id", SqlDbType.Int,4)};
|
|
parameters[0].Value = Totalprice;
|
|
parameters[1].Value = Id;
|
|
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新Totalprice8
|
|
/// </summary>
|
|
public int UpdateTotalprice8(Double Totalprice, int Id)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
strSql.Append("Totalprice8=Totalprice8+@Totalprice");
|
|
strSql.Append(" where Id=@Id");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@Totalprice", SqlDbType.Money),
|
|
new SqlParameter("@Id", SqlDbType.Int,4)};
|
|
parameters[0].Value = Totalprice;
|
|
parameters[1].Value = Id;
|
|
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新Totalprice9
|
|
/// </summary>
|
|
public int UpdateTotalprice9(Double Totalprice, int Id)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
strSql.Append("Totalprice9=Totalprice9+@Totalprice");
|
|
strSql.Append(" where Id=@Id");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@Totalprice", SqlDbType.Money),
|
|
new SqlParameter("@Id", SqlDbType.Int,4)};
|
|
parameters[0].Value = Totalprice;
|
|
parameters[1].Value = Id;
|
|
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新Totalprice10
|
|
/// </summary>
|
|
public int UpdateTotalprice10(Double Totalprice, int Id)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
strSql.Append("Totalprice10=Totalprice10+@Totalprice");
|
|
strSql.Append(" where Id=@Id");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@Totalprice", SqlDbType.Money),
|
|
new SqlParameter("@Id", SqlDbType.Int,4)};
|
|
parameters[0].Value = Totalprice;
|
|
parameters[1].Value = Id;
|
|
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新状态
|
|
/// </summary>
|
|
public int UpdateqyState(int P, string SelValue, DateTime SelValue2, int Id)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
if (P == 0)
|
|
{
|
|
strSql.Append("O_Payed=@SelValue,O_Payed_Date=@SelValue2");
|
|
}
|
|
else if (P == 1)
|
|
{
|
|
strSql.Append("O_Shipped=@SelValue,O_Shipped_Date=@SelValue2");
|
|
}
|
|
else if (P == 2)
|
|
{
|
|
strSql.Append("O_received=@SelValue,O_received_Date=@SelValue2");
|
|
}
|
|
else if (P == 3)
|
|
{
|
|
strSql.Append("O_Return=@SelValue,O_Return_Date=@SelValue2");
|
|
}
|
|
else if (P == 4)
|
|
{
|
|
strSql.Append("O_Returned=@SelValue,O_Returned_Date=@SelValue2");
|
|
}
|
|
else if (P == 5)
|
|
{
|
|
strSql.Append("O_recReturn=@SelValue,O_recReturn_Date=@SelValue2");
|
|
}
|
|
strSql.Append(" where Id=@Id");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@SelValue", SqlDbType.VarChar,50),
|
|
new SqlParameter("@SelValue2", SqlDbType.DateTime),
|
|
new SqlParameter("@Id", SqlDbType.Int)};
|
|
parameters[0].Value = SelValue;
|
|
parameters[1].Value = SelValue2;
|
|
parameters[2].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新状态
|
|
/// </summary>
|
|
public int UpdateqyState(int P, string SelValue, DateTime SelValue2, string OID)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
if (P == 0)
|
|
{
|
|
strSql.Append("O_Payed=@SelValue,O_Payed_Date=@SelValue2");
|
|
}
|
|
else if (P == 1)
|
|
{
|
|
strSql.Append("O_Shipped=@SelValue,O_Shipped_Date=@SelValue2");
|
|
}
|
|
else if (P == 2)
|
|
{
|
|
strSql.Append("O_received=@SelValue,O_received_Date=@SelValue2");
|
|
}
|
|
else if (P == 3)
|
|
{
|
|
strSql.Append("O_Return=@SelValue,O_Return_Date=@SelValue2");
|
|
}
|
|
else if (P == 4)
|
|
{
|
|
strSql.Append("O_Returned=@SelValue,O_Returned_Date=@SelValue2");
|
|
}
|
|
else if (P == 5)
|
|
{
|
|
strSql.Append("O_recReturn=@SelValue,O_recReturn_Date=@SelValue2");
|
|
}
|
|
|
|
strSql.Append(" where orderid=@OID");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@SelValue", SqlDbType.VarChar,50),
|
|
new SqlParameter("@SelValue2", SqlDbType.DateTime),
|
|
new SqlParameter("@OID", SqlDbType.VarChar,50)};
|
|
parameters[0].Value = SelValue;
|
|
parameters[1].Value = SelValue2;
|
|
parameters[2].Value = OID;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新运单号
|
|
/// </summary>
|
|
public int Updateyundanhao(string yundanhao, string kdcompay, string wlremarks, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set yundanhao=@yundanhao,kdcompay=@kdcompay,wlremarks=@wlremarks where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@yundanhao", SqlDbType.VarChar,100),
|
|
new SqlParameter("@kdcompay", SqlDbType.VarChar,50),
|
|
new SqlParameter("@wlremarks", SqlDbType.VarChar,8000),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = yundanhao;
|
|
para[1].Value = kdcompay;
|
|
para[2].Value = wlremarks;
|
|
para[3].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新微信支付订单号和商户订单号
|
|
/// </summary>
|
|
public int Updatetranid(string transaction_id, string out_trade_no, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set transaction_id=@transaction_id,out_trade_no=@out_trade_no where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@transaction_id", SqlDbType.VarChar,50),
|
|
new SqlParameter("@out_trade_no", SqlDbType.VarChar,50),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = transaction_id;
|
|
para[1].Value = out_trade_no;
|
|
para[2].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新订单号微信退款refund_id
|
|
/// </summary>
|
|
public int Updaterefund_id(string refund_id, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set refund_id=@refund_id where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@refund_id", SqlDbType.VarChar,50),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = refund_id;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新退货理由
|
|
/// </summary>
|
|
public int UpdateReturnReason(string O_ReturnReason, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set O_ReturnReason=@O_ReturnReason where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@O_ReturnReason", SqlDbType.VarChar,500),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = O_ReturnReason;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新订单号微信退款状态
|
|
/// </summary>
|
|
public int Updaterefundstatus(int refundstatus, string refund_channel, string user_received_account, string success_time, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set refundstatus=@refundstatus,refund_channel=@refund_channel,user_received_account=@user_received_account,success_time=@success_time where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@refundstatus", SqlDbType.Int),
|
|
new SqlParameter("@refund_channel", SqlDbType.VarChar,50),
|
|
new SqlParameter("@user_received_account", SqlDbType.VarChar,50),
|
|
new SqlParameter("@success_time", SqlDbType.VarChar,50),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = refundstatus;
|
|
para[1].Value = refund_channel;
|
|
para[2].Value = user_received_account;
|
|
para[3].Value = success_time;
|
|
para[4].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新是否已上传发货信息
|
|
/// </summary>
|
|
public int Updateifxnhy(int ifxnhy, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set ifxnhy=@ifxnhy where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@ifxnhy", SqlDbType.Int),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = ifxnhy;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新openid
|
|
/// </summary>
|
|
public int Updateopenid(string openid, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set openid=@openid where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@openid", SqlDbType.VarChar,250),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = openid;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新已阅读
|
|
/// </summary>
|
|
public int UpdatehasRead(int hasRead, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set hasRead=@hasRead where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@hasRead", SqlDbType.Int),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = hasRead;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新poid
|
|
/// </summary>
|
|
public int Updatepoid(Int32 xaddweek, Int32 yaddweek)
|
|
{
|
|
String sql = "update [order_info] set poid=@xaddweek where ttype=2 and ptype=1 And IFDelete=0 and poid=@yaddweek and pcount=0 and O_Seef=0";
|
|
SqlParameter[] para = { new SqlParameter("@xaddweek", SqlDbType.Int),
|
|
new SqlParameter("@yaddweek", SqlDbType.Int) };
|
|
para[0].Value = xaddweek;
|
|
para[1].Value = yaddweek;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新拼单数量
|
|
/// </summary>
|
|
public int Updateypcount(int ypcount, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set ypcount=ypcount+@ypcount where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@ypcount", SqlDbType.Int),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = ypcount;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新是否不中
|
|
/// </summary>
|
|
public int UpdateIsbuzhong(int Isbuzhong, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set Isbuzhong=@Isbuzhong where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@Isbuzhong", SqlDbType.Int),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = Isbuzhong;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新拼中订单组数
|
|
/// </summary>
|
|
public int Updateptgroup(int ptgroup, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set ptgroup=@ptgroup where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@ptgroup", SqlDbType.Int),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = ptgroup;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新是否拼单或开团中
|
|
/// </summary>
|
|
public int Updateifpd(int ifpd, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set ifpd=@ifpd where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@ifpd", SqlDbType.Int),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = ifpd;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新是否包含真实会员拼单
|
|
/// </summary>
|
|
public int Updateifbhzshy(int ifbhzshy, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set ifbhzshy=@ifbhzshy where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@ifbhzshy", SqlDbType.Int),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = ifbhzshy;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新int字段
|
|
/// </summary>
|
|
public int Updatesel(string sel, int selvalue, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set " + sel + "=" + sel + "+@selvalue where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@selvalue", SqlDbType.Int),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = selvalue;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新int字段
|
|
/// </summary>
|
|
public int Updatesel0(string sel, int selvalue, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set " + sel + "=@selvalue where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@selvalue", SqlDbType.Int),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = selvalue;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新Money字段
|
|
/// </summary>
|
|
public int Updateselprice(string sel,Double price, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set " + sel + "=" + sel + "+@price where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@price", SqlDbType.Money),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = price;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新拼单状态
|
|
/// </summary>
|
|
public int UpdatePayed(string SelValue, DateTime SelValue2, int poid)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
strSql.Append("O_Payed=@SelValue,O_Payed_Date=@SelValue2");
|
|
strSql.Append(" where id=@poid or poid=@poid");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@SelValue", SqlDbType.VarChar,50),
|
|
new SqlParameter("@SelValue2", SqlDbType.DateTime),
|
|
new SqlParameter("@poid", SqlDbType.VarChar,50)};
|
|
parameters[0].Value = SelValue;
|
|
parameters[1].Value = SelValue2;
|
|
parameters[2].Value = poid;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新付款时间
|
|
/// </summary>
|
|
public int UpdatePayedDate(DateTime SelValue2, int poid)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
strSql.Append("O_Payed_Date=@SelValue2");
|
|
strSql.Append(" where id=@poid");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@SelValue2", SqlDbType.DateTime),
|
|
new SqlParameter("@poid", SqlDbType.VarChar,50)};
|
|
parameters[0].Value = SelValue2;
|
|
parameters[1].Value = poid;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新会员id
|
|
/// </summary>
|
|
public int UpdateUserId(int ptype, int UserId, int id)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("update order_info set ");
|
|
strSql.Append("ptype=@ptype,UserId=@UserId");
|
|
strSql.Append(" where id=@id");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@ptype", SqlDbType.Int),
|
|
new SqlParameter("@UserId", SqlDbType.Int),
|
|
new SqlParameter("@id", SqlDbType.Int)};
|
|
parameters[0].Value = ptype;
|
|
parameters[1].Value = UserId;
|
|
parameters[2].Value = id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新自提地址
|
|
/// </summary>
|
|
public int UpdateAddress0(string Address0, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set Address0=@Address0 where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@Address0", SqlDbType.VarChar,2000),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = Address0;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 更新orderhxm
|
|
/// </summary>
|
|
public int Updateorderhxm(string orderhxm, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set orderhxm=@orderhxm where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@orderhxm", SqlDbType.VarChar,50),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = orderhxm;
|
|
para[1].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 删除一条数据
|
|
/// </summary>
|
|
public bool Delete(int Id)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("delete from order_info ");
|
|
strSql.Append(" where Id=@Id");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@Id", SqlDbType.Int,4)
|
|
};
|
|
parameters[0].Value = Id;
|
|
|
|
int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除一条数据
|
|
/// </summary>
|
|
public bool DeleteList(string Idlist)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("delete from order_info ");
|
|
strSql.Append(" where Id in (" + Idlist + ") ");
|
|
int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString());
|
|
if (rows > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 得到一个对象实体
|
|
/// </summary>
|
|
public Mtxfw.Model.order_info GetModel(int Id)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select top 1 * from order_info a");
|
|
strSql.Append(" where Id=@Id");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@Id", SqlDbType.Int,4)
|
|
};
|
|
parameters[0].Value = Id;
|
|
|
|
Mtxfw.Model.order_info model = new Mtxfw.Model.order_info();
|
|
DataSet ds = Mtxfw.Utility.SqlDbHelper_U.GetDataSet(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]["pid"].ToString() != "")
|
|
{
|
|
model.pid = int.Parse(ds.Tables[0].Rows[0]["pid"].ToString());
|
|
}
|
|
model.poid = int.Parse(ds.Tables[0].Rows[0]["poid"].ToString());
|
|
model.pcount = int.Parse(ds.Tables[0].Rows[0]["pcount"].ToString());
|
|
model.ypcount = int.Parse(ds.Tables[0].Rows[0]["ypcount"].ToString());
|
|
if (ds.Tables[0].Rows[0]["addressid"].ToString() != "")
|
|
{
|
|
model.addressid = int.Parse(ds.Tables[0].Rows[0]["addressid"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["orderid"].ToString() != "")
|
|
{
|
|
model.orderid = ds.Tables[0].Rows[0]["orderid"].ToString();
|
|
}
|
|
model.orderhxm = ds.Tables[0].Rows[0]["orderhxm"].ToString();
|
|
model.selcolor = ds.Tables[0].Rows[0]["selcolor"].ToString();
|
|
model.guige = ds.Tables[0].Rows[0]["guige"].ToString();
|
|
model.Contactname = ds.Tables[0].Rows[0]["Contactname"].ToString();
|
|
model.Contacttel = ds.Tables[0].Rows[0]["Contacttel"].ToString();
|
|
model.Province = ds.Tables[0].Rows[0]["Province"].ToString();
|
|
model.City = ds.Tables[0].Rows[0]["City"].ToString();
|
|
model.County = ds.Tables[0].Rows[0]["County"].ToString();
|
|
model.IFFill = Convert.ToInt32(ds.Tables[0].Rows[0]["IFFill"].ToString());
|
|
model.Tradingarea = ds.Tables[0].Rows[0]["Tradingarea"].ToString();
|
|
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
|
|
model.Address0 = ds.Tables[0].Rows[0]["Address0"].ToString();
|
|
model.Zipcode = ds.Tables[0].Rows[0]["Zipcode"].ToString();
|
|
model.yundanhao = ds.Tables[0].Rows[0]["yundanhao"].ToString();
|
|
model.kdcompay = ds.Tables[0].Rows[0]["kdcompay"].ToString();
|
|
model.Guests = ds.Tables[0].Rows[0]["Guests"].ToString();
|
|
model.wlremarks = ds.Tables[0].Rows[0]["wlremarks"].ToString();
|
|
if (ds.Tables[0].Rows[0]["Totalprice"].ToString() != "")
|
|
{
|
|
model.Totalprice = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice"].ToString());
|
|
}
|
|
model.JFTotalprice = Convert.ToDouble(ds.Tables[0].Rows[0]["JFTotalprice"].ToString());
|
|
if (ds.Tables[0].Rows[0]["Totalprice0"].ToString() != "")
|
|
{
|
|
model.Totalprice0 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice0"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice1"].ToString() != "")
|
|
{
|
|
model.Totalprice1 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice1"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice2"].ToString() != "")
|
|
{
|
|
model.Totalprice2 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice2"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice3"].ToString() != "")
|
|
{
|
|
model.Totalprice3 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice3"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice4"].ToString() != "")
|
|
{
|
|
model.Totalprice4 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice4"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice5"].ToString() != "")
|
|
{
|
|
model.Totalprice5 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice5"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice6"].ToString() != "")
|
|
{
|
|
model.Totalprice6 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice6"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice7"].ToString() != "")
|
|
{
|
|
model.Totalprice7 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice7"].ToString());
|
|
}
|
|
model.Totalprice8 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice8"].ToString());
|
|
model.Totalprice9 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice9"].ToString());
|
|
model.Totalprice10 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice10"].ToString());
|
|
if (ds.Tables[0].Rows[0]["Totalnum"].ToString() != "")
|
|
{
|
|
model.Totalnum = int.Parse(ds.Tables[0].Rows[0]["Totalnum"].ToString());
|
|
}
|
|
model.O_Submit = ds.Tables[0].Rows[0]["O_Submit"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_SubmitDate"].ToString() != "")
|
|
{
|
|
model.O_SubmitDate = DateTime.Parse(ds.Tables[0].Rows[0]["O_SubmitDate"].ToString());
|
|
}
|
|
model.O_Submit = ds.Tables[0].Rows[0]["O_Submit"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_SubmitDate"].ToString() != "")
|
|
{
|
|
model.O_SubmitDate = DateTime.Parse(ds.Tables[0].Rows[0]["O_SubmitDate"].ToString());
|
|
}
|
|
model.O_Payed = ds.Tables[0].Rows[0]["O_Payed"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Payed_Date"].ToString() != "")
|
|
{
|
|
model.O_Payed_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Payed_Date"].ToString());
|
|
}
|
|
model.O_Shipped = ds.Tables[0].Rows[0]["O_Shipped"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Shipped_Date"].ToString() != "")
|
|
{
|
|
model.O_Shipped_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Shipped_Date"].ToString());
|
|
}
|
|
model.O_received = ds.Tables[0].Rows[0]["O_received"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_received_Date"].ToString() != "")
|
|
{
|
|
model.O_received_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_received_Date"].ToString());
|
|
}
|
|
model.O_Return = ds.Tables[0].Rows[0]["O_Return"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Return_Date"].ToString() != "")
|
|
{
|
|
model.O_Return_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Return_Date"].ToString());
|
|
}
|
|
model.O_Returned = ds.Tables[0].Rows[0]["O_Returned"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Returned_Date"].ToString() != "")
|
|
{
|
|
model.O_Returned_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Returned_Date"].ToString());
|
|
}
|
|
model.O_recReturn = ds.Tables[0].Rows[0]["O_recReturn"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_recReturn_Date"].ToString() != "")
|
|
{
|
|
model.O_recReturn_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_recReturn_Date"].ToString());
|
|
}
|
|
model.O_yhj = ds.Tables[0].Rows[0]["O_yhj"].ToString();
|
|
model.O_ReturnReason = ds.Tables[0].Rows[0]["O_ReturnReason"].ToString();
|
|
model.utype = ds.Tables[0].Rows[0]["utype"].ToString();
|
|
|
|
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
|
|
{
|
|
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
|
|
}
|
|
else
|
|
{
|
|
model.UserID = 0;
|
|
}
|
|
model.MemberId = int.Parse(ds.Tables[0].Rows[0]["MemberId"].ToString());
|
|
model.ZTMemberId = int.Parse(ds.Tables[0].Rows[0]["ZTMemberId"].ToString());
|
|
if (ds.Tables[0].Rows[0]["IFDelete"].ToString() != "")
|
|
{
|
|
model.IFDelete = int.Parse(ds.Tables[0].Rows[0]["IFDelete"].ToString());
|
|
}
|
|
model.Isbuzhong = int.Parse(ds.Tables[0].Rows[0]["Isbuzhong"].ToString());
|
|
model.hasRead = int.Parse(ds.Tables[0].Rows[0]["hasRead"].ToString());
|
|
if (ds.Tables[0].Rows[0]["O_Seef"].ToString() != "")
|
|
{
|
|
model.O_Seef = int.Parse(ds.Tables[0].Rows[0]["O_Seef"].ToString());
|
|
}
|
|
model.transaction_id = ds.Tables[0].Rows[0]["transaction_id"].ToString();
|
|
model.out_trade_no = ds.Tables[0].Rows[0]["out_trade_no"].ToString();
|
|
model.refund_id = ds.Tables[0].Rows[0]["refund_id"].ToString();
|
|
model.refundstatus = Convert.ToInt32(ds.Tables[0].Rows[0]["refundstatus"].ToString());
|
|
model.refund_channel = ds.Tables[0].Rows[0]["refund_channel"].ToString();
|
|
model.user_received_account = ds.Tables[0].Rows[0]["user_received_account"].ToString();
|
|
model.openid = ds.Tables[0].Rows[0]["openid"].ToString();
|
|
model.success_time = ds.Tables[0].Rows[0]["success_time"].ToString();
|
|
model.utype = ds.Tables[0].Rows[0]["utype"].ToString();
|
|
model.ttype = int.Parse(ds.Tables[0].Rows[0]["ttype"].ToString());
|
|
model.ttype0 = int.Parse(ds.Tables[0].Rows[0]["ttype0"].ToString());
|
|
model.ptype = int.Parse(ds.Tables[0].Rows[0]["ptype"].ToString());
|
|
model.ptgroup = int.Parse(ds.Tables[0].Rows[0]["ptgroup"].ToString());
|
|
model.ifxnhy = int.Parse(ds.Tables[0].Rows[0]["ifxnhy"].ToString());
|
|
model.ypznum = int.Parse(ds.Tables[0].Rows[0]["ypznum"].ToString());
|
|
model.ifxhpt = int.Parse(ds.Tables[0].Rows[0]["ifxhpt"].ToString());
|
|
model.ifpd = int.Parse(ds.Tables[0].Rows[0]["ifpd"].ToString());
|
|
model.ifbhzshy = int.Parse(ds.Tables[0].Rows[0]["ifbhzshy"].ToString());
|
|
model.peitype = int.Parse(ds.Tables[0].Rows[0]["peitype"].ToString());
|
|
model.gtype = int.Parse(ds.Tables[0].Rows[0]["gtype"].ToString());
|
|
return model;
|
|
}
|
|
else
|
|
{
|
|
return null;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 得到一个对象实体
|
|
/// </summary>
|
|
public Mtxfw.Model.order_info GetModelbyorderhxm(string orderhxm)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select top 1 * from order_info a");
|
|
strSql.Append(" where orderhxm=@orderhxm");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@orderhxm", SqlDbType.VarChar,50)
|
|
};
|
|
parameters[0].Value = orderhxm;
|
|
|
|
Mtxfw.Model.order_info model = new Mtxfw.Model.order_info();
|
|
DataSet ds = Mtxfw.Utility.SqlDbHelper_U.GetDataSet(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]["pid"].ToString() != "")
|
|
{
|
|
model.pid = int.Parse(ds.Tables[0].Rows[0]["pid"].ToString());
|
|
}
|
|
model.poid = int.Parse(ds.Tables[0].Rows[0]["poid"].ToString());
|
|
model.pcount = int.Parse(ds.Tables[0].Rows[0]["pcount"].ToString());
|
|
model.ypcount = int.Parse(ds.Tables[0].Rows[0]["ypcount"].ToString());
|
|
if (ds.Tables[0].Rows[0]["addressid"].ToString() != "")
|
|
{
|
|
model.addressid = int.Parse(ds.Tables[0].Rows[0]["addressid"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["orderid"].ToString() != "")
|
|
{
|
|
model.orderid = ds.Tables[0].Rows[0]["orderid"].ToString();
|
|
}
|
|
model.orderhxm = ds.Tables[0].Rows[0]["orderhxm"].ToString();
|
|
model.selcolor = ds.Tables[0].Rows[0]["selcolor"].ToString();
|
|
model.guige = ds.Tables[0].Rows[0]["guige"].ToString();
|
|
model.Contactname = ds.Tables[0].Rows[0]["Contactname"].ToString();
|
|
model.Contacttel = ds.Tables[0].Rows[0]["Contacttel"].ToString();
|
|
model.Province = ds.Tables[0].Rows[0]["Province"].ToString();
|
|
model.City = ds.Tables[0].Rows[0]["City"].ToString();
|
|
model.County = ds.Tables[0].Rows[0]["County"].ToString();
|
|
model.IFFill = Convert.ToInt32(ds.Tables[0].Rows[0]["IFFill"].ToString());
|
|
model.Tradingarea = ds.Tables[0].Rows[0]["Tradingarea"].ToString();
|
|
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
|
|
model.Address0 = ds.Tables[0].Rows[0]["Address0"].ToString();
|
|
model.Zipcode = ds.Tables[0].Rows[0]["Zipcode"].ToString();
|
|
model.yundanhao = ds.Tables[0].Rows[0]["yundanhao"].ToString();
|
|
model.kdcompay = ds.Tables[0].Rows[0]["kdcompay"].ToString();
|
|
model.Guests = ds.Tables[0].Rows[0]["Guests"].ToString();
|
|
model.wlremarks = ds.Tables[0].Rows[0]["wlremarks"].ToString();
|
|
if (ds.Tables[0].Rows[0]["Totalprice"].ToString() != "")
|
|
{
|
|
model.Totalprice = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice"].ToString());
|
|
}
|
|
model.JFTotalprice = Convert.ToDouble(ds.Tables[0].Rows[0]["JFTotalprice"].ToString());
|
|
if (ds.Tables[0].Rows[0]["Totalprice0"].ToString() != "")
|
|
{
|
|
model.Totalprice0 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice0"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice1"].ToString() != "")
|
|
{
|
|
model.Totalprice1 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice1"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice2"].ToString() != "")
|
|
{
|
|
model.Totalprice2 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice2"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice3"].ToString() != "")
|
|
{
|
|
model.Totalprice3 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice3"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice4"].ToString() != "")
|
|
{
|
|
model.Totalprice4 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice4"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice5"].ToString() != "")
|
|
{
|
|
model.Totalprice5 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice5"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice6"].ToString() != "")
|
|
{
|
|
model.Totalprice6 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice6"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice7"].ToString() != "")
|
|
{
|
|
model.Totalprice7 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice7"].ToString());
|
|
}
|
|
model.Totalprice8 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice8"].ToString());
|
|
model.Totalprice9 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice9"].ToString());
|
|
model.Totalprice10 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice10"].ToString());
|
|
if (ds.Tables[0].Rows[0]["Totalnum"].ToString() != "")
|
|
{
|
|
model.Totalnum = int.Parse(ds.Tables[0].Rows[0]["Totalnum"].ToString());
|
|
}
|
|
model.O_Submit = ds.Tables[0].Rows[0]["O_Submit"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_SubmitDate"].ToString() != "")
|
|
{
|
|
model.O_SubmitDate = DateTime.Parse(ds.Tables[0].Rows[0]["O_SubmitDate"].ToString());
|
|
}
|
|
model.O_Submit = ds.Tables[0].Rows[0]["O_Submit"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_SubmitDate"].ToString() != "")
|
|
{
|
|
model.O_SubmitDate = DateTime.Parse(ds.Tables[0].Rows[0]["O_SubmitDate"].ToString());
|
|
}
|
|
model.O_Payed = ds.Tables[0].Rows[0]["O_Payed"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Payed_Date"].ToString() != "")
|
|
{
|
|
model.O_Payed_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Payed_Date"].ToString());
|
|
}
|
|
model.O_Shipped = ds.Tables[0].Rows[0]["O_Shipped"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Shipped_Date"].ToString() != "")
|
|
{
|
|
model.O_Shipped_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Shipped_Date"].ToString());
|
|
}
|
|
model.O_received = ds.Tables[0].Rows[0]["O_received"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_received_Date"].ToString() != "")
|
|
{
|
|
model.O_received_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_received_Date"].ToString());
|
|
}
|
|
model.O_Return = ds.Tables[0].Rows[0]["O_Return"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Return_Date"].ToString() != "")
|
|
{
|
|
model.O_Return_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Return_Date"].ToString());
|
|
}
|
|
model.O_Returned = ds.Tables[0].Rows[0]["O_Returned"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Returned_Date"].ToString() != "")
|
|
{
|
|
model.O_Returned_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Returned_Date"].ToString());
|
|
}
|
|
model.O_recReturn = ds.Tables[0].Rows[0]["O_recReturn"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_recReturn_Date"].ToString() != "")
|
|
{
|
|
model.O_recReturn_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_recReturn_Date"].ToString());
|
|
}
|
|
model.O_yhj = ds.Tables[0].Rows[0]["O_yhj"].ToString();
|
|
model.O_ReturnReason = ds.Tables[0].Rows[0]["O_ReturnReason"].ToString();
|
|
model.utype = ds.Tables[0].Rows[0]["utype"].ToString();
|
|
|
|
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
|
|
{
|
|
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
|
|
}
|
|
else
|
|
{
|
|
model.UserID = 0;
|
|
}
|
|
model.MemberId = int.Parse(ds.Tables[0].Rows[0]["MemberId"].ToString());
|
|
model.ZTMemberId = int.Parse(ds.Tables[0].Rows[0]["ZTMemberId"].ToString());
|
|
if (ds.Tables[0].Rows[0]["IFDelete"].ToString() != "")
|
|
{
|
|
model.IFDelete = int.Parse(ds.Tables[0].Rows[0]["IFDelete"].ToString());
|
|
}
|
|
model.Isbuzhong = int.Parse(ds.Tables[0].Rows[0]["Isbuzhong"].ToString());
|
|
model.hasRead = int.Parse(ds.Tables[0].Rows[0]["hasRead"].ToString());
|
|
if (ds.Tables[0].Rows[0]["O_Seef"].ToString() != "")
|
|
{
|
|
model.O_Seef = int.Parse(ds.Tables[0].Rows[0]["O_Seef"].ToString());
|
|
}
|
|
model.transaction_id = ds.Tables[0].Rows[0]["transaction_id"].ToString();
|
|
model.out_trade_no = ds.Tables[0].Rows[0]["out_trade_no"].ToString();
|
|
model.refund_id = ds.Tables[0].Rows[0]["refund_id"].ToString();
|
|
model.refundstatus = Convert.ToInt32(ds.Tables[0].Rows[0]["refundstatus"].ToString());
|
|
model.refund_channel = ds.Tables[0].Rows[0]["refund_channel"].ToString();
|
|
model.user_received_account = ds.Tables[0].Rows[0]["user_received_account"].ToString();
|
|
model.openid = ds.Tables[0].Rows[0]["openid"].ToString();
|
|
model.success_time = ds.Tables[0].Rows[0]["success_time"].ToString();
|
|
model.utype = ds.Tables[0].Rows[0]["utype"].ToString();
|
|
model.ttype = int.Parse(ds.Tables[0].Rows[0]["ttype"].ToString());
|
|
model.ttype0 = int.Parse(ds.Tables[0].Rows[0]["ttype0"].ToString());
|
|
model.ptype = int.Parse(ds.Tables[0].Rows[0]["ptype"].ToString());
|
|
model.ptgroup = int.Parse(ds.Tables[0].Rows[0]["ptgroup"].ToString());
|
|
model.ifxnhy = int.Parse(ds.Tables[0].Rows[0]["ifxnhy"].ToString());
|
|
model.ypznum = int.Parse(ds.Tables[0].Rows[0]["ypznum"].ToString());
|
|
model.ifxhpt = int.Parse(ds.Tables[0].Rows[0]["ifxhpt"].ToString());
|
|
model.ifpd = int.Parse(ds.Tables[0].Rows[0]["ifpd"].ToString());
|
|
model.ifbhzshy = int.Parse(ds.Tables[0].Rows[0]["ifbhzshy"].ToString());
|
|
model.peitype = int.Parse(ds.Tables[0].Rows[0]["peitype"].ToString());
|
|
model.gtype = int.Parse(ds.Tables[0].Rows[0]["gtype"].ToString());
|
|
return model;
|
|
}
|
|
else
|
|
{
|
|
return null;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 得到一个对象实体
|
|
/// </summary>
|
|
public Mtxfw.Model.order_info GetModelByOrder(string OrderId)
|
|
{
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select top 1 * from order_info a");
|
|
strSql.Append(" where OrderId=@OrderId");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@OrderId", SqlDbType.VarChar,50)
|
|
};
|
|
parameters[0].Value = OrderId;
|
|
|
|
Mtxfw.Model.order_info model = new Mtxfw.Model.order_info();
|
|
DataSet ds = Mtxfw.Utility.SqlDbHelper_U.GetDataSet(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]["pid"].ToString() != "")
|
|
{
|
|
model.pid = int.Parse(ds.Tables[0].Rows[0]["pid"].ToString());
|
|
}
|
|
model.poid = int.Parse(ds.Tables[0].Rows[0]["poid"].ToString());
|
|
model.pcount = int.Parse(ds.Tables[0].Rows[0]["pcount"].ToString());
|
|
model.ypcount = int.Parse(ds.Tables[0].Rows[0]["ypcount"].ToString());
|
|
if (ds.Tables[0].Rows[0]["orderid"].ToString() != "")
|
|
{
|
|
model.orderid = ds.Tables[0].Rows[0]["orderid"].ToString();
|
|
}
|
|
model.orderhxm = ds.Tables[0].Rows[0]["orderhxm"].ToString();
|
|
model.selcolor = ds.Tables[0].Rows[0]["selcolor"].ToString();
|
|
model.guige = ds.Tables[0].Rows[0]["guige"].ToString();
|
|
model.Contactname = ds.Tables[0].Rows[0]["Contactname"].ToString();
|
|
model.Contacttel = ds.Tables[0].Rows[0]["Contacttel"].ToString();
|
|
model.Province = ds.Tables[0].Rows[0]["Province"].ToString();
|
|
model.City = ds.Tables[0].Rows[0]["City"].ToString();
|
|
model.County = ds.Tables[0].Rows[0]["County"].ToString();
|
|
model.IFFill = Convert.ToInt32(ds.Tables[0].Rows[0]["IFFill"].ToString());
|
|
model.Tradingarea = ds.Tables[0].Rows[0]["Tradingarea"].ToString();
|
|
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
|
|
model.Address0 = ds.Tables[0].Rows[0]["Address0"].ToString();
|
|
model.Zipcode = ds.Tables[0].Rows[0]["Zipcode"].ToString();
|
|
model.yundanhao = ds.Tables[0].Rows[0]["yundanhao"].ToString();
|
|
model.kdcompay = ds.Tables[0].Rows[0]["kdcompay"].ToString();
|
|
model.Guests = ds.Tables[0].Rows[0]["Guests"].ToString();
|
|
model.wlremarks = ds.Tables[0].Rows[0]["wlremarks"].ToString();
|
|
if (ds.Tables[0].Rows[0]["Totalprice"].ToString() != "")
|
|
{
|
|
model.Totalprice = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice0"].ToString() != "")
|
|
{
|
|
model.Totalprice0 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice0"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice1"].ToString() != "")
|
|
{
|
|
model.Totalprice1 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice1"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice2"].ToString() != "")
|
|
{
|
|
model.Totalprice2 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice2"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice3"].ToString() != "")
|
|
{
|
|
model.Totalprice3 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice3"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice4"].ToString() != "")
|
|
{
|
|
model.Totalprice4 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice4"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice5"].ToString() != "")
|
|
{
|
|
model.Totalprice5 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice5"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice6"].ToString() != "")
|
|
{
|
|
model.Totalprice6 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice6"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["Totalprice7"].ToString() != "")
|
|
{
|
|
model.Totalprice7 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice7"].ToString());
|
|
}
|
|
model.Totalprice8 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice8"].ToString());
|
|
model.Totalprice9 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice9"].ToString());
|
|
model.Totalprice10 = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice10"].ToString());
|
|
if (ds.Tables[0].Rows[0]["Totalnum"].ToString() != "")
|
|
{
|
|
model.Totalnum = int.Parse(ds.Tables[0].Rows[0]["Totalnum"].ToString());
|
|
}
|
|
model.O_Submit = ds.Tables[0].Rows[0]["O_Submit"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_SubmitDate"].ToString() != "")
|
|
{
|
|
model.O_SubmitDate = DateTime.Parse(ds.Tables[0].Rows[0]["O_SubmitDate"].ToString());
|
|
}
|
|
model.O_Submit = ds.Tables[0].Rows[0]["O_Submit"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_SubmitDate"].ToString() != "")
|
|
{
|
|
model.O_SubmitDate = DateTime.Parse(ds.Tables[0].Rows[0]["O_SubmitDate"].ToString());
|
|
}
|
|
model.O_Payed = ds.Tables[0].Rows[0]["O_Payed"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Payed_Date"].ToString() != "")
|
|
{
|
|
model.O_Payed_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Payed_Date"].ToString());
|
|
}
|
|
model.O_Shipped = ds.Tables[0].Rows[0]["O_Shipped"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Shipped_Date"].ToString() != "")
|
|
{
|
|
model.O_Shipped_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Shipped_Date"].ToString());
|
|
}
|
|
model.O_received = ds.Tables[0].Rows[0]["O_received"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_received_Date"].ToString() != "")
|
|
{
|
|
model.O_received_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_received_Date"].ToString());
|
|
}
|
|
model.O_Return = ds.Tables[0].Rows[0]["O_Return"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Return_Date"].ToString() != "")
|
|
{
|
|
model.O_Return_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Return_Date"].ToString());
|
|
}
|
|
model.O_Returned = ds.Tables[0].Rows[0]["O_Returned"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_Returned_Date"].ToString() != "")
|
|
{
|
|
model.O_Returned_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_Returned_Date"].ToString());
|
|
}
|
|
model.O_recReturn = ds.Tables[0].Rows[0]["O_recReturn"].ToString();
|
|
if (ds.Tables[0].Rows[0]["O_recReturn_Date"].ToString() != "")
|
|
{
|
|
model.O_recReturn_Date = DateTime.Parse(ds.Tables[0].Rows[0]["O_recReturn_Date"].ToString());
|
|
}
|
|
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
|
|
{
|
|
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
|
|
}
|
|
model.MemberId = int.Parse(ds.Tables[0].Rows[0]["MemberId"].ToString());
|
|
model.ZTMemberId = int.Parse(ds.Tables[0].Rows[0]["ZTMemberId"].ToString());
|
|
model.utype = ds.Tables[0].Rows[0]["utype"].ToString();
|
|
|
|
if (ds.Tables[0].Rows[0]["IFDelete"].ToString() != "")
|
|
{
|
|
model.IFDelete = int.Parse(ds.Tables[0].Rows[0]["IFDelete"].ToString());
|
|
}
|
|
model.Isbuzhong = int.Parse(ds.Tables[0].Rows[0]["Isbuzhong"].ToString());
|
|
model.hasRead = int.Parse(ds.Tables[0].Rows[0]["hasRead"].ToString());
|
|
if (ds.Tables[0].Rows[0]["O_Seef"].ToString() != "")
|
|
{
|
|
model.O_Seef = int.Parse(ds.Tables[0].Rows[0]["O_Seef"].ToString());
|
|
}
|
|
model.O_yhj = ds.Tables[0].Rows[0]["O_yhj"].ToString();
|
|
model.O_ReturnReason = ds.Tables[0].Rows[0]["O_ReturnReason"].ToString();
|
|
model.transaction_id = ds.Tables[0].Rows[0]["transaction_id"].ToString();
|
|
model.out_trade_no = ds.Tables[0].Rows[0]["out_trade_no"].ToString();
|
|
model.refund_id = ds.Tables[0].Rows[0]["refund_id"].ToString();
|
|
model.refundstatus = Convert.ToInt32(ds.Tables[0].Rows[0]["refundstatus"].ToString());
|
|
model.refund_channel = ds.Tables[0].Rows[0]["refund_channel"].ToString();
|
|
model.user_received_account = ds.Tables[0].Rows[0]["user_received_account"].ToString();
|
|
model.success_time = ds.Tables[0].Rows[0]["success_time"].ToString();
|
|
model.openid = ds.Tables[0].Rows[0]["openid"].ToString();
|
|
model.utype = ds.Tables[0].Rows[0]["utype"].ToString();
|
|
model.ttype = int.Parse(ds.Tables[0].Rows[0]["ttype"].ToString());
|
|
model.ptype = int.Parse(ds.Tables[0].Rows[0]["ptype"].ToString());
|
|
model.ptgroup = int.Parse(ds.Tables[0].Rows[0]["ptgroup"].ToString());
|
|
model.ifxnhy = int.Parse(ds.Tables[0].Rows[0]["ifxnhy"].ToString());
|
|
model.ypznum = int.Parse(ds.Tables[0].Rows[0]["ypznum"].ToString());
|
|
model.ifxhpt = int.Parse(ds.Tables[0].Rows[0]["ifxhpt"].ToString());
|
|
model.ifpd = int.Parse(ds.Tables[0].Rows[0]["ifpd"].ToString());
|
|
model.ifbhzshy = int.Parse(ds.Tables[0].Rows[0]["ifbhzshy"].ToString());
|
|
model.peitype = int.Parse(ds.Tables[0].Rows[0]["peitype"].ToString());
|
|
model.gtype = int.Parse(ds.Tables[0].Rows[0]["gtype"].ToString());
|
|
return model;
|
|
}
|
|
else
|
|
{
|
|
return null;
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 获得数据列表
|
|
/// </summary>
|
|
public DataSet GetList(string strWhere)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select * FROM order_info a");
|
|
if (strWhere.Trim() != "")
|
|
{
|
|
strSql.Append(" where " + strWhere);
|
|
}
|
|
return Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString());
|
|
}
|
|
public int GetMaxNumber(string utype)
|
|
{
|
|
string sql = "select top 1 isnull(max(orderid),0) from order_info Where utype=@utype";
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@utype", SqlDbType.VarChar,50)
|
|
};
|
|
parameters[0].Value = utype;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteScalar(sql, parameters);
|
|
}
|
|
/// <summary>
|
|
/// 获得前几行数据
|
|
/// </summary>
|
|
public DataSet GetList(int Top, string strWhere, string filedOrder)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select ");
|
|
if (Top > 0)
|
|
{
|
|
strSql.Append(" top " + Top.ToString());
|
|
}
|
|
strSql.Append(" * FROM order_info ");
|
|
if (strWhere.Trim() != "")
|
|
{
|
|
strSql.Append(" where " + strWhere);
|
|
}
|
|
strSql.Append(" order by " + filedOrder);
|
|
return Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString());
|
|
}
|
|
public DataSet GetViewList(int Top, string strWhere)
|
|
{
|
|
StringBuilder strSql = new StringBuilder();
|
|
strSql.Append("select ");
|
|
if (Top > 0)
|
|
{
|
|
strSql.Append(" top " + Top.ToString());
|
|
}
|
|
strSql.Append(" * FROM order_info_view ");
|
|
if (strWhere.Trim() != "")
|
|
{
|
|
strSql.Append(" where " + strWhere);
|
|
}
|
|
return Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString());
|
|
}
|
|
/// <summary>
|
|
/// 假删除
|
|
/// </summary>
|
|
public int UpdateIFDelete(int IFDelete, string IFDeleteTime, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set IFDelete=@IFDelete,IFDeleteTime=@IFDeleteTime where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@IFDelete", SqlDbType.Int),
|
|
new SqlParameter("@IFDeleteTime", SqlDbType.VarChar,50),
|
|
new SqlParameter("@Id", SqlDbType.BigInt) };
|
|
para[0].Value = IFDelete;
|
|
para[1].Value = IFDeleteTime;
|
|
para[2].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
public int UpdateIFDelete(int IFDelete, string IFDeleteTime, string where)
|
|
{
|
|
String sql = "update [order_info] set IFDelete=@IFDelete,IFDeleteTime=@IFDeleteTime where " + where;
|
|
SqlParameter[] para = { new SqlParameter("@IFDelete", SqlDbType.Int),
|
|
new SqlParameter("@IFDeleteTime", SqlDbType.VarChar,50) };
|
|
para[0].Value = IFDelete;
|
|
para[1].Value = IFDeleteTime;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 假删除
|
|
/// </summary>
|
|
public int UpdateIFDelete0(int IFDelete, string IFDeleteTime, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set IFDelete=@IFDelete,IFDeleteTime=@IFDeleteTime where Id=@Id or poid=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@IFDelete", SqlDbType.Int),
|
|
new SqlParameter("@IFDeleteTime", SqlDbType.VarChar,50),
|
|
new SqlParameter("@Id", SqlDbType.Int) };
|
|
para[0].Value = IFDelete;
|
|
para[1].Value = IFDeleteTime;
|
|
para[2].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 假删除
|
|
/// </summary>
|
|
public int UpdateIFDelete1(int IFDelete, string IFDeleteTime, Int32 bqqs)
|
|
{
|
|
String sql = "update [order_info] set IFDelete=@IFDelete,IFDeleteTime=@IFDeleteTime where ttype=2 and ptype=0 and IFDelete=0 and poid=@bqqs";
|
|
SqlParameter[] para = { new SqlParameter("@IFDelete", SqlDbType.Int),
|
|
new SqlParameter("@IFDeleteTime", SqlDbType.VarChar,50),
|
|
new SqlParameter("@bqqs", SqlDbType.Int) };
|
|
para[0].Value = IFDelete;
|
|
para[1].Value = IFDeleteTime;
|
|
para[2].Value = bqqs;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
/// <summary>
|
|
/// 结算
|
|
/// </summary>
|
|
public int UpdateSeef(int O_Seef, string O_Seef_Date, Int32 Id)
|
|
{
|
|
String sql = "update [order_info] set O_Seef=@O_Seef,O_Seef_Date=@O_Seef_Date where Id=@Id";
|
|
SqlParameter[] para = { new SqlParameter("@O_Seef", SqlDbType.Int),
|
|
new SqlParameter("@O_Seef_Date", SqlDbType.VarChar,50),
|
|
new SqlParameter("@Id", SqlDbType.BigInt) };
|
|
para[0].Value = O_Seef;
|
|
para[1].Value = O_Seef_Date;
|
|
para[2].Value = Id;
|
|
return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(sql, para);
|
|
}
|
|
}
|
|
}
|
|
|