/// <summary>
/// 后台用户库存入库
/// </summary>
/// <param name="entity"></param>
/// <param name="orderType"></param>
/// <param name="product"></param>
/// <param name="loginId"></param>
/// <returns></returns>
public static int CreateDeliverAdmin(DeliverEntity entity, string orderType, string product, string loginId)
{
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@loginId", loginId),
new SqlParameter("@OrderNo", entity.DeliverNo),
new SqlParameter("@Account", entity.Account),
new SqlParameter("@UserID", entity.UserID),
new SqlParameter("@Price", entity.LockPrice),
new SqlParameter("@OrderType", orderType),
new SqlParameter("@Product", product),
new SqlParameter("@Quantity", entity.Total),
new SqlParameter("@Direction", entity.Direction),
new SqlParameter("@OperUserID", entity.OperationUserID)
};
int result;
return DbHelper.RunProcedure("P_CreateDeliverAdmin", paras, out result);
}
/// <summary>
/// 创建交割单
/// </summary>
/// <param name="entity"></param>
/// <param name="tran"></param>
/// <returns></returns>
public static int CreateDeliver(DeliverEntity entity, YicelTransaction tran)
{
entity.DeliverDate = DateTime.Now.ToString();
entity.CreateDate = entity.DeliverDate;
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@DeliverId",entity.DeliverId),
new SqlParameter("@DeliverNo",entity.DeliverNo),
new SqlParameter("@Goods",entity.Goods),
new SqlParameter("@Direction",entity.Direction),
new SqlParameter("@Total",entity.Total),
new SqlParameter("@DeliverDate",entity.DeliverDate),
new SqlParameter("@LockPrice",entity.LockPrice),
new SqlParameter("@State",entity.State),
new SqlParameter("@AvailableTotal",entity.AvailableTotal),
new SqlParameter("@CreateDate",entity.CreateDate),
new SqlParameter("@FromFlag",entity.FromFlag),
new SqlParameter("@OperationUserID",entity.OperationUserID),
new SqlParameter("@UserID",entity.UserID),
new SqlParameter("@Account",entity.Account)
};
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("insert into Deliver_BZJ({0})", Fields.Deliver_FIELD_LIST);
strSql.AppendFormat(" values ({0})", "@" + Fields.Deliver_FIELD_LIST.Replace(",", ",@"));
object obj = DbHelper.ExecuteNonQuery(strSql.ToString(), parms, tran.Transaction);
return obj == null || obj == DBNull.Value ? 0 : Convert.ToInt32(obj);
}
/// <summary>
/// 交割单记录
/// </summary>
/// <param name="entity"></param>
/// <param name="orderEntity"></param>
/// <param name="operationId"></param>
/// <param name="tran"></param>
/// <returns></returns>
public static int UpdateDeliver(DeliverEntity entity, OrderEntity orderEntity, string operationId, YicelTransaction tran)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@DeliverId",entity.DeliverId),
new SqlParameter("@DeliverNo",entity.DeliverNo),
new SqlParameter("@Account",entity.Account),
new SqlParameter("@Direction",entity.Direction),
new SqlParameter("@Total",entity.Total),
new SqlParameter("@Goods",entity.Goods),
new SqlParameter("@DeliverDate",entity.DeliverDate),
new SqlParameter("@LockPrice",entity.LockPrice),
new SqlParameter("@AvailableTotal",entity.AvailableTotal),
new SqlParameter("@FromFlag",entity.FromFlag),
new SqlParameter("@State",entity.State),
new SqlParameter("@CreateDate",entity.CreateDate)
};
StringBuilder strSql = new StringBuilder();
strSql.Append("update Deliver_BZJ set ");
strSql.Append("DeliverNo=@DeliverNo,");
strSql.Append("Account=@Account,");
strSql.Append("Goods=@Goods,");
strSql.Append("Direction=@Direction,");
strSql.Append("Total=@Total,");
strSql.Append("DeliverDate=@DeliverDate,");
strSql.Append("LockPrice=@LockPrice,");
strSql.Append("AvailableTotal=@AvailableTotal,");
strSql.Append("FromFlag=@FromFlag,");
strSql.Append("State=@State,");
strSql.Append("CreateDate=@CreateDate");
strSql.AppendFormat(" where DeliverId='{0}'", entity.DeliverId);
return DbHelper.ExecuteNonQuery(strSql.ToString(), parms, tran.Transaction);
#region 记录出库记录
//DeliverAdjustmentEntity deliver = new DeliverAdjustmentEntity();
//deliver.DeliverAdjustmentID = Guid.NewGuid().ToString("n");
//deliver.DeliverAdjustmentNO = "JS" + DateTime.Now.ToString("yyMMddhhmmssffff");
//deliver.Goods = entity.Goods;
//deliver.Direction = orderEntity.OrderType;
//if (entity.Goods == 1)
//{
// deliver.Total =- Math.Abs( orderEntity.Au);
//}
//if (entity.Goods == 2)
//{
// deliver.Total = - Math.Abs(orderEntity.Ag);
//}
//if (entity.Goods == 3)
//{
// deliver.Total = - Math.Abs(orderEntity.Pt);
//}
//if (entity.Goods == 4)
//{
// deliver.Total = - Math.Abs(orderEntity.Pd);
//}
//deliver.Account = entity.Account;
//deliver.LockPrice = 0;
//deliver.State = 0;
//deliver.AvailableTotal = 0;
//deliver.FromFlag = 1;
//deliver.OperationUserID = OperationId;
//deliver.UserID = orderEntity.UserId;
#endregion
// return CreateDeliverAdjustment(deliver, tran);
}
/// <summary>
/// 保证金实体
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private static DeliverEntity CreateDeliverEntity(DbDataReader reader)
{
DeliverEntity entity = new DeliverEntity();
entity.DeliverId = reader["DeliverId"].ToString();
entity.DeliverNo = reader["DeliverNo"].ToString();
entity.Account = reader["Account"].ToString();
entity.Goods = Convert.ToInt32(reader["Goods"]);
entity.Direction = Convert.ToInt32(reader["Direction"]);
entity.Total = Convert.ToDecimal(reader["Total"]);
entity.DeliverDate = reader["DeliverDate"].ToString();
entity.LockPrice = Convert.ToDecimal(reader["LockPrice"]);
entity.AvailableTotal = Convert.ToDecimal(reader["AvailableTotal"]);
entity.FromFlag = Convert.ToInt32(reader["FromFlag"]);
entity.State = Convert.ToInt32(reader["State"]);
entity.CreateDate = reader["CreateDate"].ToString();
return entity;
}
/// <summary>
/// 交割单报表查询
/// </summary>
/// <param name="loginId"></param>
/// <param name="entity"></param>
/// <param name="userName"></param>
/// <param name="agentId"></param>
/// <param name="pageindex"></param>
/// <param name="pagesize"></param>
/// <param name="page"></param>
/// <returns></returns>
public static DataTable GetDeliverOrderList(string loginId, DeliverEntity entity, string userName, string agentId, int pageindex, int pagesize, ref int page)
{
SqlParameter[] paras = null;
StringBuilder sb = new StringBuilder();
StringBuilder sbSearch = new StringBuilder();
if (!string.IsNullOrEmpty(entity.DeliverNo))
{
sbSearch.AppendFormat(@" and DeliverNo='{0}'", entity.DeliverNo);
}
if (!string.IsNullOrEmpty(entity.Account))
{
sbSearch.AppendFormat(@" and Account='{0}'", entity.Account);
}
if (!string.IsNullOrEmpty(userName))
{
sbSearch.AppendFormat(@" and userName like '{0}%'", userName);
}
if (!string.IsNullOrEmpty(entity.CreateDate))
{
sbSearch.AppendFormat(@" and CreateDate BETWEEN '{0}' AND '{1}'", entity.CreateDate, entity.EndDate);
}
if (!string.IsNullOrEmpty(agentId))
{
sbSearch.AppendFormat(@" and agentid in ({0}) ", ComFunction.GetOrgIds(agentId));
}
paras = new SqlParameter[]
{
new SqlParameter("@selectlist", " Account,userName,DeliverId,DeliverDate,DeliverNo,Goods,Direction,Total,LockPrice,State,AvailableTotal,FromFlag,CreateDate"),
new SqlParameter("@SubSelectList", " Account,userName,DeliverId,DeliverDate,DeliverNo,Goods,Direction,Total,LockPrice,State,AvailableTotal,FromFlag,CreateDate"),
new SqlParameter("@TableSource", "V_OrderDelivery"),
new SqlParameter("@TableOrder", "a"),
new SqlParameter("@SearchCondition", string.Format(@" 1=1 {0}",sbSearch.ToString())),
new SqlParameter("@OrderExpression", " order by CreateDate desc"),
new SqlParameter("@PageIndex", pageindex),
new SqlParameter("@PageSize", pagesize),
new SqlParameter("@PageCount", page)
};
paras[8].Direction = ParameterDirection.Output;
DataTable dt = DbHelper.RunProcedure("GetRecordFromPage", paras, "Deliver_BZJ").Tables[0];
page = Convert.ToInt32(paras[8].Value);
return dt;
}
