/// <summary>
/// 开始盘点
/// </summary>
/// <param name="startAgrs">开始盘点参数</param>
/// <returns></returns>
public bool StartStockTaking(StockTakingAgrs endAgrs)
{
string UpdateCommand = "UPDATE [StocktakingMaster] SET [StartTime]=@StartTime,[ModifyTime]=@ModifyTime,[Status]=@Status WHERE [ID]=@ID";
IList <DbParameter> parms = new List <DbParameter>();
parms.Add(new SqlParameter("@ID", endAgrs.ID));
parms.Add(new SqlParameter("@StartTime", DateTime.Now));
parms.Add(new SqlParameter("@ModifyTime", DateTime.Now));
parms.Add(new SqlParameter("@Status", 1));
try
{
var result = db.ExecuteNonQuery(CommandType.Text, UpdateCommand, parms.ToArray());
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception exc)
{
throw exc;
return(false);
}
}
/// <summary>
/// 结束盘点
/// </summary>
/// <param name="endAgrs">开始盘点参数</param>
/// <returns></returns>
public bool EndStockTaking(StockTakingAgrs endAgrs)
{
string UpdateCommand = "UPDATE [StocktakingMaster] SET [StartTime]=@EndTime,[ModifyTime]=@ModifyTime,[Status]=@Status,[Count]=(SELECT SUM(DifferenceQty) difCount FROM Stocktaking WHERE MasterID=@ID),[Money]=(SELECT SUM(DiffAmount) DiffMoney FROM Stocktaking WHERE MasterID=@ID) WHERE [ID]=@ID";
IList <DbParameter> parms = new List <DbParameter>();
parms.Add(new SqlParameter("@ID", endAgrs.ID));
parms.Add(new SqlParameter("@EndTime", DateTime.Now));
parms.Add(new SqlParameter("@ModifyTime", DateTime.Now));
parms.Add(new SqlParameter("@Status", 2));
try
{
var result = db.ExecuteNonQuery(CommandType.Text, UpdateCommand, parms.ToArray());
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception exc)
{
throw exc;
return(false);
}
}
/// <summary>
/// 初始化盘点记录
/// </summary>
/// <param name="startAgrs">盘点参数</param>
/// <returns>创建成功返回盘点记录ID,否则返回NULL</returns>
public Guid?InsertStockTaking(StockTakingAgrs startAgrs)
{
var number = PosBLL.instance.GetBatchNumber("ST");
Guid masterID = Guid.NewGuid();
string InsertCommand = "INSERT INTO [StocktakingMaster]([ID],[Number],[StartTime],[EndTime],[ModifyTime],[UserName],[UserID],[StoreID],[StoreName]) VALUES(@ID,@Number,@StartTime,@EndTime,@ModifyTime,@UserName,@UserID,@StoreID,@StoreName)";
IList <DbParameter> parms = new List <DbParameter>();
parms.Add(new SqlParameter("@ID", masterID));
parms.Add(new SqlParameter("@Number", number));
parms.Add(new SqlParameter("@StartTime", DateTime.Now));
parms.Add(new SqlParameter("@EndTime", DateTime.Now));
parms.Add(new SqlParameter("@ModifyTime", DateTime.Now));
parms.Add(new SqlParameter("@UserName", startAgrs.UserName));
parms.Add(new SqlParameter("@UserID", startAgrs.UserID));
parms.Add(new SqlParameter("@StoreID", startAgrs.StoreID));
parms.Add(new SqlParameter("@StoreName", startAgrs.StoreName));
try
{
var result = db.ExecuteNonQuery(CommandType.Text, InsertCommand, parms.ToArray());
if (result > 0)
{
return(masterID);
}
else
{
return(null);
}
}
catch (Exception exc)
{
throw exc;
return(null);
}
}
/// <summary>
/// 初始化盘点数据
/// </summary>
/// <returns></returns>
public Guid?InitStockTaking(StockTakingAgrs initAgrs)
{
var masterID = this.GetStockTakingMasterByStatus();
if (!masterID.HasValue)
{
masterID = this.InsertStockTaking(initAgrs);
if (!masterID.HasValue)
{
this.InitStockTaking(initAgrs);
}
}
var result = this.InsertStockTaking(masterID.Value, initAgrs.StoreID);
if (result)
{
return(masterID);
}
else
{
return(null);
}
}
