/// <summary>
/// 删除订单
/// </summary>
/// <param name="OrderInfo"></param>
/// <returns></returns>
public bool OrderDel(Hi.Model.DIS_Order OrderInfo)
{
SqlConnection con = new SqlConnection(SqlHelper.LocalSqlServer);
con.Open();
SqlTransaction sqlTrans = con.BeginTransaction();
//可以做循环
try
{
int O = DelOrder(con, OrderInfo, sqlTrans);
int Od = DelOrderDetail(con, OrderInfo, sqlTrans);
if (O > 0 && Od > 0)
{
sqlTrans.Commit();
return(true);
}
else
{
sqlTrans.Rollback();
}
}
catch (Exception)
{
sqlTrans.Rollback();
return(false);
}
finally
{
con.Close();
}
return(false);
}
/// <summary>
/// 修改发货单
/// </summary>
/// <param name="outmodel">发货单</param>
/// <param name="omodel">订单</param>
/// <param name="ll">订单明细</param>
/// <param name="llo">发货单明细</param>
/// <returns></returns>
public int GetOutUpOrder(Hi.Model.DIS_OrderOut outmodel, Hi.Model.DIS_Order omodel, List <Hi.Model.DIS_OrderDetail> ll, List <Hi.Model.DIS_OrderOutDetail> llo)
{
SqlTransaction sqlTrans = DBUtility.SqlHelper.CreateStoreTranSaction();
int outid = 0;
try
{
//修改发货单主表状态
if (!new Hi.BLL.DIS_OrderOut().Update(outmodel, sqlTrans))
{
outid = 0;
return(outid);
}
//修改订单主表状态
if (new Hi.BLL.DIS_Order().UpdateOrder(sqlTrans.Connection, omodel, sqlTrans) < 0)
{
outid = 0;
return(outid);
}
//修改订单明细状态
foreach (Hi.Model.DIS_OrderDetail item in ll)
{
if (new Hi.BLL.DIS_OrderDetail().UpdateOrderDetail(sqlTrans.Connection, item, sqlTrans) < 0)
{
outid = 0;
return(outid);
}
}
//修改发货单明细
foreach (Hi.Model.DIS_OrderOutDetail item in llo)
{
if (new Hi.BLL.DIS_OrderOutDetail().Update(item, sqlTrans) < 0)
{
outid = 0;
return(outid);
}
}
sqlTrans.Commit();
outid = 1;
}
catch (Exception)
{
if (sqlTrans.Connection != null)
{
sqlTrans.Rollback();
}
throw;
}
return(outid);
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Hi.Model.DIS_Order GetModel(DataRow r)
{
Hi.Model.DIS_Order model = new Hi.Model.DIS_Order();
model.ID = SqlHelper.GetInt(r["ID"]);
model.CompID = SqlHelper.GetInt(r["CompID"]);
model.DisID = SqlHelper.GetInt(r["DisID"]);
model.DisUserID = SqlHelper.GetInt(r["DisUserID"]);
model.AddType = SqlHelper.GetInt(r["AddType"]);
model.Otype = SqlHelper.GetInt(r["Otype"]);
model.IsAudit = SqlHelper.GetInt(r["IsAudit"]);
model.AddrID = SqlHelper.GetInt(r["AddrID"]);
model.ReceiptNo = SqlHelper.GetString(r["ReceiptNo"]);
model.GUID = SqlHelper.GetString(r["GUID"]);
model.ArriveDate = SqlHelper.GetDateTime(r["ArriveDate"]);
model.TotalAmount = SqlHelper.GetDecimal(r["TotalAmount"]);
model.AuditAmount = SqlHelper.GetDecimal(r["AuditAmount"]);
model.OtherAmount = SqlHelper.GetDecimal(r["OtherAmount"]);
model.PayedAmount = SqlHelper.GetDecimal(r["PayedAmount"]);
model.Principal = SqlHelper.GetString(r["Principal"]);
model.Phone = SqlHelper.GetString(r["Phone"]);
model.Address = SqlHelper.GetString(r["Address"]);
model.Remark = SqlHelper.GetString(r["Remark"]);
model.OState = SqlHelper.GetInt(r["OState"]);
model.PayState = SqlHelper.GetInt(r["PayState"]);
model.ReturnState = SqlHelper.GetInt(r["ReturnState"]);
model.AuditUserID = SqlHelper.GetInt(r["AuditUserID"]);
model.AuditDate = SqlHelper.GetDateTime(r["AuditDate"]);
model.AuditRemark = SqlHelper.GetString(r["AuditRemark"]);
model.CreateUserID = SqlHelper.GetInt(r["CreateUserID"]);
model.CreateDate = SqlHelper.GetDateTime(r["CreateDate"]);
model.ReturnMoneyDate = SqlHelper.GetDateTime(r["ReturnMoneyDate"]);
model.ReturnMoneyUserId = SqlHelper.GetInt(r["ReturnMoneyUserId"]);
model.ReturnMoneyUser = SqlHelper.GetString(r["ReturnMoneyUser"]);
model.ts = SqlHelper.GetDateTime(r["ts"]);
model.dr = SqlHelper.GetInt(r["dr"]);
model.modifyuser = SqlHelper.GetInt(r["modifyuser"]);
model.Atta = SqlHelper.GetString(r["Atta"]);
model.IsOutState = SqlHelper.GetInt(r["IsOutState"]);
model.IsPayColl = SqlHelper.GetString(r["IsPayColl"]);
model.CostSub = SqlHelper.GetString(r["CostSub"]);
model.bateAmount = SqlHelper.GetDecimal(r["bateAmount"]);
model.IsSettl = SqlHelper.GetString(r["IsSettl"]);
model.GiveMode = SqlHelper.GetString(r["GiveMode"]);
model.PostFee = SqlHelper.GetDecimal(r["PostFee"]);
model.vdef1 = SqlHelper.GetString(r["vdef1"]);
model.vdef2 = SqlHelper.GetString(r["vdef2"]);
model.vdef3 = SqlHelper.GetString(r["vdef3"]);
return(model);
}
/// <summary>
/// 删除订单表
/// </summary>
/// <returns></returns>
public int DelOrder(SqlConnection sqlconn, Hi.Model.DIS_Order OrderInfo, SqlTransaction sqltans)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [DIS_Order] set ");
strSql.Append("[dr]=@dr");
strSql.Append(" where [ID]=@ID;");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.BigInt),
new SqlParameter("@dr", SqlDbType.Int),
};
parameters[0].Value = OrderInfo.ID;
parameters[1].Value = OrderInfo.dr;
SqlCommand cmd = new SqlCommand(strSql.ToString(), sqlconn, sqltans);
cmd.CommandType = CommandType.Text;
if (parameters != null)
{
foreach (SqlParameter parameter in parameters)
{
if (parameter.SqlDbType == SqlDbType.DateTime)
{
if (parameter.Value == DBNull.Value)
{
parameter.Value = DBNull.Value;
}
}
cmd.Parameters.Add(parameter);
}
}
int rowsAffected = SqlHelper.GetInt(cmd.ExecuteNonQuery().ToString());
if (rowsAffected > 0)
{
return(rowsAffected);
}
else
{
return(0);
}
}
/// <summary>
/// 修改订单退款状态，modify by ggh
/// 创建时间：2015-06-09
/// </summary>
/// <param name="sqlconn"></param>
/// <param name="model"></param>
/// <param name="sqltans"></param>
/// <param name="returnID">退货单ID，根据退货单Id判断方法的重载</param>
/// <param name="returnstart">退货单状态</param>
/// <returns></returns>
public int UpdateOrderByggh(SqlConnection sqlconn, Hi.Model.DIS_Order model, SqlTransaction sqltans, int returnID, int returnstart)
{
return(dal.UpdateOrderByggh(sqlconn, model, sqltans, returnID, returnstart));
}
/// <summary>
/// 更新一条数据,带事务
/// </summary>
public bool Update(Hi.Model.DIS_Order model, SqlTransaction TranSaction = null)
{
return(dal.Update(model, TranSaction));
}
/// <summary>
/// 订单添加 （事务）
/// </summary>
/// <returns></returns>
public int AddOrder(SqlConnection sqlconn, Hi.Model.DIS_Order model, SqlTransaction sqltans)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [DIS_Order](");
strSql.Append("[CompID],[DisID],[DisUserID],[AddType],[Otype],[IsAudit],[AddrID],[ReceiptNo],[GUID],[ArriveDate],[TotalAmount],[AuditAmount],[OtherAmount],[PayedAmount],[Principal],[Phone],[Address],[Remark],[OState],[PayState],[ReturnState],[AuditUserID],[AuditDate],[AuditRemark],[CreateUserID],[CreateDate],[ReturnMoneyDate],[ReturnMoneyUserId],[ReturnMoneyUser],[ts],[modifyuser],[Atta],[IsOutState],[IsPayColl],[CostSub],[bateAmount],[IsSettl],[GiveMode],[PostFee],[vdef1],[vdef2],[vdef3])");
strSql.Append(" values (");
strSql.Append("@CompID,@DisID,@DisUserID,@AddType,@Otype,@IsAudit,@AddrID,@ReceiptNo,@GUID,@ArriveDate,@TotalAmount,@AuditAmount,@OtherAmount,@PayedAmount,@Principal,@Phone,@Address,@Remark,@OState,@PayState,@ReturnState,@AuditUserID,@AuditDate,@AuditRemark,@CreateUserID,@CreateDate,@ReturnMoneyDate,@ReturnMoneyUserId,@ReturnMoneyUser,@ts,@modifyuser,@Atta,@IsOutState,@IsPayColl,@CostSub,@bateAmount,@IsSettl,@GiveMode,@PostFee,@vdef1,@vdef2,@vdef3)");
strSql.Append(";select @@Identity");
SqlParameter[] parameters =
{
new SqlParameter("@CompID", SqlDbType.Int),
new SqlParameter("@DisID", SqlDbType.Int),
new SqlParameter("@DisUserID", SqlDbType.Int),
new SqlParameter("@AddType", SqlDbType.Int),
new SqlParameter("@Otype", SqlDbType.Int),
new SqlParameter("@IsAudit", SqlDbType.Int),
new SqlParameter("@AddrID", SqlDbType.Int),
new SqlParameter("@ReceiptNo", SqlDbType.VarChar, 50),
new SqlParameter("@GUID", SqlDbType.VarChar, 50),
new SqlParameter("@ArriveDate", SqlDbType.DateTime),
new SqlParameter("@TotalAmount", SqlDbType.Decimal),
new SqlParameter("@AuditAmount", SqlDbType.Decimal),
new SqlParameter("@OtherAmount", SqlDbType.Decimal),
new SqlParameter("@PayedAmount", SqlDbType.Decimal),
new SqlParameter("@Principal", SqlDbType.VarChar, 50),
new SqlParameter("@Phone", SqlDbType.VarChar, 50),
new SqlParameter("@Address", SqlDbType.VarChar, 300),
new SqlParameter("@Remark", SqlDbType.VarChar, 1024),
new SqlParameter("@OState", SqlDbType.Int),
new SqlParameter("@PayState", SqlDbType.Int),
new SqlParameter("@ReturnState", SqlDbType.Int),
new SqlParameter("@AuditUserID", SqlDbType.Int),
new SqlParameter("@AuditDate", SqlDbType.DateTime),
new SqlParameter("@AuditRemark", SqlDbType.VarChar, 800),
new SqlParameter("@CreateUserID", SqlDbType.Int),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ReturnMoneyDate", SqlDbType.DateTime),
new SqlParameter("@ReturnMoneyUserId", SqlDbType.Int),
new SqlParameter("@ReturnMoneyUser", SqlDbType.VarChar, 50),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@modifyuser", SqlDbType.Int),
new SqlParameter("@Atta", SqlDbType.VarChar, 1024),
new SqlParameter("@IsOutState", SqlDbType.Int),
new SqlParameter("@IsPayColl", SqlDbType.VarChar, 128),
new SqlParameter("@CostSub", SqlDbType.VarChar, 128),
new SqlParameter("@bateAmount", SqlDbType.Decimal),
new SqlParameter("@IsSettl", SqlDbType.VarChar, 134),
new SqlParameter("@GiveMode", SqlDbType.VarChar, 50),
new SqlParameter("@PostFee", SqlDbType.Decimal),
new SqlParameter("@vdef1", SqlDbType.VarChar, 128),
new SqlParameter("@vdef2", SqlDbType.VarChar, 128),
new SqlParameter("@vdef3", SqlDbType.VarChar, 128)
};
parameters[0].Value = model.CompID;
parameters[1].Value = model.DisID;
parameters[2].Value = model.DisUserID;
parameters[3].Value = model.AddType;
parameters[4].Value = model.Otype;
parameters[5].Value = model.IsAudit;
parameters[6].Value = model.AddrID;
parameters[7].Value = model.ReceiptNo;
if (model.GUID != null)
{
parameters[8].Value = model.GUID;
}
else
{
parameters[8].Value = DBNull.Value;
}
if (model.ArriveDate != DateTime.MinValue)
{
parameters[9].Value = model.ArriveDate;
}
else
{
parameters[9].Value = DBNull.Value;
}
parameters[10].Value = model.TotalAmount;
parameters[11].Value = model.AuditAmount;
parameters[12].Value = model.OtherAmount;
parameters[13].Value = model.PayedAmount;
if (model.Principal != null)
{
parameters[14].Value = model.Principal;
}
else
{
parameters[14].Value = DBNull.Value;
}
if (model.Phone != null)
{
parameters[15].Value = model.Phone;
}
else
{
parameters[15].Value = DBNull.Value;
}
if (model.Address != null)
{
parameters[16].Value = model.Address;
}
else
{
parameters[16].Value = DBNull.Value;
}
if (model.Remark != null)
{
parameters[17].Value = model.Remark;
}
else
{
parameters[17].Value = DBNull.Value;
}
parameters[18].Value = model.OState;
parameters[19].Value = model.PayState;
parameters[20].Value = model.ReturnState;
parameters[21].Value = model.AuditUserID;
if (model.AuditDate != DateTime.MinValue)
{
parameters[22].Value = model.AuditDate;
}
else
{
parameters[22].Value = DBNull.Value;
}
if (model.AuditRemark != null)
{
parameters[23].Value = model.AuditRemark;
}
else
{
parameters[23].Value = DBNull.Value;
}
parameters[24].Value = model.CreateUserID;
if (model.CreateDate != DateTime.MinValue)
{
parameters[25].Value = model.CreateDate;
}
else
{
parameters[25].Value = DBNull.Value;
}
if (model.ReturnMoneyDate != DateTime.MinValue)
{
parameters[26].Value = model.ReturnMoneyDate;
}
else
{
parameters[26].Value = DBNull.Value;
}
parameters[27].Value = model.ReturnMoneyUserId;
if (model.ReturnMoneyUser != null)
{
parameters[28].Value = model.ReturnMoneyUser;
}
else
{
parameters[28].Value = DBNull.Value;
}
parameters[29].Value = model.ts;
parameters[30].Value = model.modifyuser;
if (model.Atta != null)
{
parameters[31].Value = model.Atta;
}
else
{
parameters[31].Value = DBNull.Value;
}
parameters[32].Value = model.IsOutState;
if (model.IsPayColl != null)
{
parameters[33].Value = model.IsPayColl;
}
else
{
parameters[33].Value = DBNull.Value;
}
if (model.CostSub != null)
{
parameters[34].Value = model.CostSub;
}
else
{
parameters[34].Value = DBNull.Value;
}
parameters[35].Value = model.bateAmount;
if (model.IsSettl != null)
{
parameters[36].Value = model.IsSettl;
}
else
{
parameters[36].Value = DBNull.Value;
}
if (model.GiveMode != null)
{
parameters[37].Value = model.GiveMode;
}
else
{
parameters[37].Value = DBNull.Value;
}
parameters[38].Value = model.PostFee;
if (model.vdef1 != null)
{
parameters[39].Value = model.vdef1;
}
else
{
parameters[39].Value = DBNull.Value;
}
if (model.vdef2 != null)
{
parameters[40].Value = model.vdef2;
}
else
{
parameters[40].Value = DBNull.Value;
}
if (model.vdef3 != null)
{
parameters[41].Value = model.vdef3;
}
else
{
parameters[41].Value = DBNull.Value;
}
SqlCommand cmd = new SqlCommand(strSql.ToString(), sqlconn, sqltans);
cmd.CommandType = CommandType.Text;
if (parameters != null)
{
foreach (SqlParameter parameter in parameters)
{
if (parameter.SqlDbType == SqlDbType.DateTime)
{
if (parameter.Value == DBNull.Value)
{
parameter.Value = DBNull.Value;
}
}
cmd.Parameters.Add(parameter);
}
}
int rowsAffected = SqlHelper.GetInt(cmd.ExecuteScalar().ToString());
if (rowsAffected > 0)
{
return(rowsAffected);
}
else
{
return(0);
}
}
/// <summary>
/// 修改订单（事务）
/// </summary>
/// <param name="sqlconn"></param>
/// <param name="model"></param>
/// <param name="sqltans"></param>
/// <returns></returns>
public int UpdateOrder(SqlConnection sqlconn, Hi.Model.DIS_Order model, SqlTransaction sqltans)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [DIS_Order] set ");
strSql.Append("[CompID]=@CompID,");
strSql.Append("[DisID]=@DisID,");
strSql.Append("[DisUserID]=@DisUserID,");
strSql.Append("[AddType]=@AddType,");
strSql.Append("[Otype]=@Otype,");
strSql.Append("[IsAudit]=@IsAudit,");
strSql.Append("[AddrID]=@AddrID,");
strSql.Append("[ReceiptNo]=@ReceiptNo,");
strSql.Append("[GUID]=@GUID,");
strSql.Append("[ArriveDate]=@ArriveDate,");
strSql.Append("[TotalAmount]=@TotalAmount,");
strSql.Append("[AuditAmount]=@AuditAmount,");
strSql.Append("[OtherAmount]=@OtherAmount,");
strSql.Append("[PayedAmount]=@PayedAmount,");
strSql.Append("[Principal]=@Principal,");
strSql.Append("[Phone]=@Phone,");
strSql.Append("[Address]=@Address,");
strSql.Append("[Remark]=@Remark,");
strSql.Append("[OState]=@OState,");
strSql.Append("[PayState]=@PayState,");
strSql.Append("[ReturnState]=@ReturnState,");
strSql.Append("[AuditUserID]=@AuditUserID,");
strSql.Append("[AuditDate]=@AuditDate,");
strSql.Append("[AuditRemark]=@AuditRemark,");
strSql.Append("[CreateUserID]=@CreateUserID,");
strSql.Append("[CreateDate]=@CreateDate,");
strSql.Append("[ReturnMoneyDate]=@ReturnMoneyDate,");
strSql.Append("[ReturnMoneyUserId]=@ReturnMoneyUserId,");
strSql.Append("[ReturnMoneyUser]=@ReturnMoneyUser,");
strSql.Append("[ts]=@ts,");
strSql.Append("[dr]=@dr,");
strSql.Append("[modifyuser]=@modifyuser,");
strSql.Append("[Atta]=@Atta,");
strSql.Append("[IsOutState]=@IsOutState,");
strSql.Append("[IsPayColl]=@IsPayColl,");
strSql.Append("[CostSub]=@CostSub,");
strSql.Append("[bateAmount]=@bateAmount,");
strSql.Append("[IsSettl]=@IsSettl,");
strSql.Append("[GiveMode]=@GiveMode,");
strSql.Append("[PostFee]=@PostFee,");
strSql.Append("[vdef1]=@vdef1,");
strSql.Append("[vdef2]=@vdef2,");
strSql.Append("[vdef3]=@vdef3");
strSql.Append(" where [ID]=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.BigInt),
new SqlParameter("@CompID", SqlDbType.Int),
new SqlParameter("@DisID", SqlDbType.Int),
new SqlParameter("@DisUserID", SqlDbType.Int),
new SqlParameter("@AddType", SqlDbType.Int),
new SqlParameter("@Otype", SqlDbType.Int),
new SqlParameter("@IsAudit", SqlDbType.Int),
new SqlParameter("@AddrID", SqlDbType.Int),
new SqlParameter("@ReceiptNo", SqlDbType.VarChar, 50),
new SqlParameter("@GUID", SqlDbType.VarChar, 50),
new SqlParameter("@ArriveDate", SqlDbType.DateTime),
new SqlParameter("@TotalAmount", SqlDbType.Decimal),
new SqlParameter("@AuditAmount", SqlDbType.Decimal),
new SqlParameter("@OtherAmount", SqlDbType.Decimal),
new SqlParameter("@PayedAmount", SqlDbType.Decimal),
new SqlParameter("@Principal", SqlDbType.VarChar, 50),
new SqlParameter("@Phone", SqlDbType.VarChar, 50),
new SqlParameter("@Address", SqlDbType.VarChar, 300),
new SqlParameter("@Remark", SqlDbType.VarChar, 1024),
new SqlParameter("@OState", SqlDbType.Int),
new SqlParameter("@PayState", SqlDbType.Int),
new SqlParameter("@ReturnState", SqlDbType.Int),
new SqlParameter("@AuditUserID", SqlDbType.Int),
new SqlParameter("@AuditDate", SqlDbType.DateTime),
new SqlParameter("@AuditRemark", SqlDbType.VarChar, 800),
new SqlParameter("@CreateUserID", SqlDbType.Int),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ReturnMoneyDate", SqlDbType.DateTime),
new SqlParameter("@ReturnMoneyUserId", SqlDbType.Int),
new SqlParameter("@ReturnMoneyUser", SqlDbType.VarChar, 50),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@dr", SqlDbType.SmallInt),
new SqlParameter("@modifyuser", SqlDbType.Int),
new SqlParameter("@Atta", SqlDbType.VarChar, 1024),
new SqlParameter("@IsOutState", SqlDbType.Int),
new SqlParameter("@IsPayColl", SqlDbType.VarChar, 128),
new SqlParameter("@CostSub", SqlDbType.VarChar, 128),
new SqlParameter("@bateAmount", SqlDbType.Decimal),
new SqlParameter("@IsSettl", SqlDbType.VarChar, 134),
new SqlParameter("@GiveMode", SqlDbType.VarChar, 50),
new SqlParameter("@PostFee", SqlDbType.Decimal),
new SqlParameter("@vdef1", SqlDbType.VarChar, 128),
new SqlParameter("@vdef2", SqlDbType.VarChar, 128),
new SqlParameter("@vdef3", SqlDbType.VarChar, 128)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.CompID;
parameters[2].Value = model.DisID;
parameters[3].Value = model.DisUserID;
parameters[4].Value = model.AddType;
parameters[5].Value = model.Otype;
parameters[6].Value = model.IsAudit;
parameters[7].Value = model.AddrID;
parameters[8].Value = model.ReceiptNo;
if (model.GUID != null)
{
parameters[9].Value = model.GUID;
}
else
{
parameters[9].Value = DBNull.Value;
}
if (model.ArriveDate != DateTime.MinValue)
{
parameters[10].Value = model.ArriveDate;
}
else
{
parameters[10].Value = DBNull.Value;
}
parameters[11].Value = model.TotalAmount;
parameters[12].Value = model.AuditAmount;
parameters[13].Value = model.OtherAmount;
parameters[14].Value = model.PayedAmount;
if (model.Principal != null)
{
parameters[15].Value = model.Principal;
}
else
{
parameters[15].Value = DBNull.Value;
}
if (model.Phone != null)
{
parameters[16].Value = model.Phone;
}
else
{
parameters[16].Value = DBNull.Value;
}
if (model.Address != null)
{
parameters[17].Value = model.Address;
}
else
{
parameters[17].Value = DBNull.Value;
}
if (model.Remark != null)
{
parameters[18].Value = model.Remark;
}
else
{
parameters[18].Value = DBNull.Value;
}
parameters[19].Value = model.OState;
parameters[20].Value = model.PayState;
parameters[21].Value = model.ReturnState;
parameters[22].Value = model.AuditUserID;
if (model.AuditDate != DateTime.MinValue)
{
parameters[23].Value = model.AuditDate;
}
else
{
parameters[23].Value = DBNull.Value;
}
if (model.AuditRemark != null)
{
parameters[24].Value = model.AuditRemark;
}
else
{
parameters[24].Value = DBNull.Value;
}
parameters[25].Value = model.CreateUserID;
if (model.CreateDate != DateTime.MinValue)
{
parameters[26].Value = model.CreateDate;
}
else
{
parameters[26].Value = DBNull.Value;
}
if (model.ReturnMoneyDate != DateTime.MinValue)
{
parameters[27].Value = model.ReturnMoneyDate;
}
else
{
parameters[27].Value = DBNull.Value;
}
parameters[28].Value = model.ReturnMoneyUserId;
if (model.ReturnMoneyUser != null)
{
parameters[29].Value = model.ReturnMoneyUser;
}
else
{
parameters[29].Value = DBNull.Value;
}
parameters[30].Value = model.ts;
parameters[31].Value = model.dr;
parameters[32].Value = model.modifyuser;
if (model.Atta != null)
{
parameters[33].Value = model.Atta;
}
else
{
parameters[33].Value = DBNull.Value;
}
parameters[34].Value = model.IsOutState;
if (model.IsPayColl != null)
{
parameters[35].Value = model.IsPayColl;
}
else
{
parameters[35].Value = DBNull.Value;
}
if (model.CostSub != null)
{
parameters[36].Value = model.CostSub;
}
else
{
parameters[36].Value = DBNull.Value;
}
parameters[37].Value = model.bateAmount;
if (model.IsSettl != null)
{
parameters[38].Value = model.IsSettl;
}
else
{
parameters[38].Value = DBNull.Value;
}
if (model.GiveMode != null)
{
parameters[39].Value = model.GiveMode;
}
else
{
parameters[39].Value = DBNull.Value;
}
parameters[40].Value = model.PostFee;
if (model.vdef1 != null)
{
parameters[41].Value = model.vdef1;
}
else
{
parameters[41].Value = DBNull.Value;
}
if (model.vdef2 != null)
{
parameters[42].Value = model.vdef2;
}
else
{
parameters[42].Value = DBNull.Value;
}
if (model.vdef3 != null)
{
parameters[43].Value = model.vdef3;
}
else
{
parameters[43].Value = DBNull.Value;
}
SqlCommand cmd = new SqlCommand(strSql.ToString(), sqlconn, sqltans);
cmd.CommandType = CommandType.Text;
if (parameters != null)
{
foreach (SqlParameter parameter in parameters)
{
if (parameter.SqlDbType == SqlDbType.DateTime)
{
if (parameter.Value == DBNull.Value)
{
parameter.Value = DBNull.Value;
}
}
cmd.Parameters.Add(parameter);
}
}
int rowsAffected = SqlHelper.GetInt(cmd.ExecuteNonQuery().ToString());
if (rowsAffected > 0)
{
return(rowsAffected);
}
else
{
return(0);
}
}
/// <summary>
/// 删除订单
/// </summary>
/// <param name="OrderInfo"></param>
/// <returns></returns>
public bool OrderDel(Hi.Model.DIS_Order OrderInfo)
{
return(dal.OrderDel(OrderInfo));
}
/// <summary>
/// 修改订单退款状态，modify by ggh
/// 创建时间：2015-06-09
/// </summary>
/// <param name="sqlconn"></param>
/// <param name="model"></param>
/// <param name="sqltans"></param>
/// <param name="returnID">退货单ID，根据退货单Id判断方法的重载</param>
/// <param name="returnstart">退货单状态</param>
/// <returns></returns>
public int UpdateOrderByggh(SqlConnection sqlconn, Hi.Model.DIS_Order model, SqlTransaction sqltans, int returnID, int returnstart)
{
int rowsAffected = 0;
if (returnID == 0)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [DIS_Order] set [PayState]=@PayState ,ReturnState=@ReturnState,ts=@ts,modifyuser=@modifyuser where [ID]=@ID");
SqlParameter[] parameters = { new SqlParameter("@PayState", SqlDbType.Int),
new SqlParameter("@ReturnState", SqlDbType.Int),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@modifyuser", SqlDbType.Int),
new SqlParameter("@ID", SqlDbType.Int) };
parameters[0].Value = model.PayState;
parameters[1].Value = model.ReturnState;
parameters[2].Value = model.ts;
parameters[3].Value = model.modifyuser;
parameters[4].Value = model.ID;
SqlCommand cmd = new SqlCommand(strSql.ToString(), sqlconn, sqltans);
cmd.CommandType = CommandType.Text;
if (parameters != null)
{
foreach (SqlParameter parameter in parameters)
{
if (parameter.SqlDbType == SqlDbType.DateTime)
{
if (parameter.Value == DBNull.Value)
{
parameter.Value = DBNull.Value;
}
}
cmd.Parameters.Add(parameter);
}
}
rowsAffected = SqlHelper.GetInt(cmd.ExecuteNonQuery().ToString());
}
else
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [DIS_OrderReturn] set [ReturnState]=@ReturnState where [ID]=@ID");
SqlParameter[] parameters = { new SqlParameter("@ReturnState", SqlDbType.Int),
new SqlParameter("@ID", SqlDbType.Int) };
parameters[0].Value = returnstart;
parameters[1].Value = returnID;
SqlCommand cmd = new SqlCommand(strSql.ToString(), sqlconn, sqltans);
cmd.CommandType = CommandType.Text;
if (parameters != null)
{
foreach (SqlParameter parameter in parameters)
{
if (parameter.SqlDbType == SqlDbType.DateTime)
{
if (parameter.Value == DBNull.Value)
{
parameter.Value = DBNull.Value;
}
}
cmd.Parameters.Add(parameter);
}
}
rowsAffected = SqlHelper.GetInt(cmd.ExecuteNonQuery().ToString());
}
if (rowsAffected > 0)
{
return(rowsAffected);
}
else
{
return(0);
}
}
/// <summary>
/// 删除订单明细
/// </summary>
/// <param name="sqlconn"></param>
/// <param name="OrderInfo"></param>
/// <param name="sqltans"></param>
/// <returns></returns>
public int DelOrderDetail(SqlConnection sqlconn, Hi.Model.DIS_Order OrderInfo, SqlTransaction sqltans)
{
string sql = "select * from DIS_OrderDetail where ISNULL(dr,0)=0 and OrderId=@OrderId";
SqlParameter[] cmdParms =
{
new SqlParameter("@OrderID", SqlDbType.Int),
};
cmdParms[0].Value = OrderInfo.ID;
DataTable dt = SqlHelper.Query(SqlHelper.LocalSqlServer, sql, cmdParms).Tables[0];
if (dt != null)
{
if (dt.Rows.Count <= 0)
{
//不存在订单明细
return(1);
}
}
StringBuilder strSql = new StringBuilder();
strSql.Append("update [DIS_OrderDetail] set ");
strSql.Append("[dr]=@Ddr");
strSql.Append(" where [OrderID]=@OrderID;");
SqlParameter[] parameters =
{
new SqlParameter("@Ddr", SqlDbType.BigInt),
new SqlParameter("@OrderID", SqlDbType.Int),
};
parameters[0].Value = OrderInfo.dr;
parameters[1].Value = OrderInfo.ID;
SqlCommand cmd = new SqlCommand(strSql.ToString(), sqlconn, sqltans);
cmd.CommandType = CommandType.Text;
if (parameters != null)
{
foreach (SqlParameter parameter in parameters)
{
if (parameter.SqlDbType == SqlDbType.DateTime)
{
if (parameter.Value == DBNull.Value)
{
parameter.Value = DBNull.Value;
}
}
cmd.Parameters.Add(parameter);
}
}
int rowsAffected = SqlHelper.GetInt(cmd.ExecuteNonQuery().ToString());
if (rowsAffected > 0)
{
return(rowsAffected);
}
else
{
return(0);
}
}
/// <summary>
/// 订单发货
/// </summary>
/// <param name="omodel">订单主表</param>
/// <param name="ll">订单明细</param>
/// <param name="outmodel">订单发货表</param>
/// <param name="llo">订单发货明细表</param>
/// <param name="log">订单物流表</param>
/// <param name="stockOModel">发货出库主表</param>
/// <param name="llinOut">发货出库从表</param>
/// <returns></returns>
public int GetOutOrder(Hi.Model.DIS_Order omodel, List <Hi.Model.DIS_OrderDetail> ll, Hi.Model.DIS_OrderOut outmodel, List <Hi.Model.DIS_OrderOutDetail> llo, Hi.Model.DIS_Logistics log, Hi.Model.DIS_StockOrder stockOModel, List <Hi.Model.DIS_StockInOut> llinOut)
{
SqlTransaction sqlTrans = DBUtility.SqlHelper.CreateStoreTranSaction();
int outid = 0;
try
{
//新增发货单
outid = Add(outmodel, sqlTrans);
if (outid > 0)
{
//新增发货单明细
foreach (Hi.Model.DIS_OrderOutDetail item in llo)
{
if (item.OutNum <= 0)
{
continue;
}
item.OrderOutID = outid;
if (new Hi.BLL.DIS_OrderOutDetail().Add(item, sqlTrans) < 0)
{
outid = 0;
return(outid);
}
//发货减扣库存
if (!new Hi.BLL.DIS_GoodsStock().UpdateStock(item.GoodsinfoID.ToString(), item.Batchno, item.OutNum, sqlTrans))
{
outid = 0;
return(outid);
}
}
//发货新增出库单
stockOModel.OrderID = outid;
int stockOrderID = new Hi.BLL.DIS_StockOrder().Add(stockOModel, sqlTrans);
if (stockOrderID > 0)
{
foreach (Hi.Model.DIS_StockInOut item in llinOut)
{
item.StockOrderID = stockOrderID;
if (new Hi.BLL.DIS_StockInOut().Add(item, sqlTrans) < 0)
{
outid = 0;
return(outid);
}
}
}
else
{
outid = 0;
return(outid);
}
//修改订单主表状态
if (new Hi.BLL.DIS_Order().UpdateOrder(sqlTrans.Connection, omodel, sqlTrans) < 0)
{
outid = 0;
return(outid);
}
//修改订单明细状态
foreach (Hi.Model.DIS_OrderDetail item in ll)
{
if (new Hi.BLL.DIS_OrderDetail().UpdateOrderDetail(sqlTrans.Connection, item, sqlTrans) < 0)
{
outid = 0;
return(outid);
}
}
//新增物流
log.OrderOutID = outid;
if (new Hi.BLL.DIS_Logistics().Add(log, sqlTrans) < 0)
{
outid = 0;
return(outid);
}
sqlTrans.Commit();
}
}
catch (Exception)
{
if (sqlTrans.Connection != null)
{
sqlTrans.Rollback();
}
throw;
}
return(outid);
}
/// <summary>
/// 作废发货单
/// </summary>
/// <param name="omodel">订单</param>
/// <param name="outmodel">发货单</param>
/// <param name="ol">订单明细</param>
/// <param name="loud">本次发货明细</param>
/// <returns></returns>
public int GetCancelOut(Hi.Model.DIS_Order omodel, Hi.Model.DIS_OrderOut outmodel, List <Hi.Model.DIS_OrderDetail> ol, List <Hi.Model.DIS_OrderOutDetail> loud, string stockOids, string stockInids)
{
SqlTransaction sqlTrans = DBUtility.SqlHelper.CreateStoreTranSaction();
int outid = 0;
try
{
//修改订单主表状态
if (!new Hi.BLL.DIS_Order().Update(omodel, sqlTrans))
{
outid = 0;
return(outid);
}
//修改订单明细状态
foreach (Hi.Model.DIS_OrderDetail item in ol)
{
if (new Hi.BLL.DIS_OrderDetail().UpdateOrderDetail(sqlTrans.Connection, item, sqlTrans) < 0)
{
outid = 0;
return(outid);
}
}
foreach (var item in loud)
{
//发货减扣库存
if (!new Hi.BLL.DIS_GoodsStock().UpdateStockAdd(item.GoodsinfoID.ToString(), item.Batchno, item.OutNum, sqlTrans))
{
outid = 0;
return(outid);
}
}
if (!string.IsNullOrWhiteSpace(stockOids))
{
string sql = "update DIS_StockOrder set dr=1 where ID in (" + stockOids + ")";
if (NonQuery(sql, sqlTrans.Connection, sqlTrans) <= 0)
{
outid = 0;
return(outid);
}
}
if (!string.IsNullOrWhiteSpace(stockInids))
{
string sql = "update DIS_StockInOut set dr=1 where ID in (" + stockInids + ")";
if (NonQuery(sql, sqlTrans.Connection, sqlTrans) <= 0)
{
outid = 0;
return(outid);
}
}
//修改发货单主表状态
if (!Update(outmodel, sqlTrans))
{
outid = 0;
return(outid);
}
sqlTrans.Commit();
outid = 1;
}
catch (Exception)
{
if (sqlTrans.Connection != null)
{
sqlTrans.Rollback();
}
throw;
}
return(outid);
}
