/// <summary>
/// 通过单体计算后更新单头信息
/// </summary>
/// <param name="sell"></param>
/// <returns></returns>
public int Update(SellOffHead sell)
{
string sql = "update T_SellOffHead set kinds=@kinds,count=@count,totalPrice=@totalPrice,realPrice=@realPrice,state=@state where sellOffHeadID=@sellOffHeadId";
string[] param = { "@kinds", "@count", "@totalPrice", "@realPrice", "@sellOffHeadId", "@state" };
object[] values = { sell.Kinds, sell.Count, sell.TotalPrice, sell.RealPrice, sell.SellOffHeadId, sell.State };
int row = db.ExecuteNoneQuery(sql, param, values);
return(row);
}
/// <summary>
/// 添加销退单头
/// </summary>
/// <param name="sellOffHead"></param>
/// <returns></returns>
public int Insert(SellOffHead sellOffHead)
{
string cmdText = "insert into T_SellOffHead(sellOffHeadID, saleTaskId, userID, makingTime) VALUES(@sellOffHeadID,@saleTaskId,@userID,@makingTime)";
string[] param = { "@sellOffHeadID", "@saleTaskId", "@userID", "@makingTime" };
object[] values = { sellOffHead.SellOffHeadId, sellOffHead.SaleTaskId.SaleTaskId, sellOffHead.User.UserId, sellOffHead.MakingTime };
int row = db.ExecuteNoneQuery(cmdText, param, values);
return(row);
}
/// <summary>
/// 添加销退单头
/// </summary>
/// <param name="sellHead">销退单头实体</param>
/// <returns></returns>
public Result Insert(SellOffHead sellHead)
{
int row = dao.Insert(sellHead);
if (row > 0)
{
return(Result.添加成功);
}
else
{
return(Result.添加失败);
}
}
/// <summary>
/// 通过单体计算后更新单头信息
/// </summary>
/// <param name="sell"></param>
/// <returns></returns>
public Result Update(SellOffHead sell)
{
int row = dao.Update(sell);
if (row > 0)
{
return(Result.更新成功);
}
else
{
return(Result.更新失败);
}
}
/// <summary>
/// 通过销退单头Id获取销售任务Id
/// </summary>
/// <param name="sellOffHeadId"></param>
/// <returns></returns>
public DataSet getSaleTask(string sellOffHeadId)
{
SellOffHead sh = new SellOffHead();
DataSet ds = dao.getSaleTask(sellOffHeadId);
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// 通过统计单体信息后更新单头
/// </summary>
public String updateSellHead()
{
string op = Request["op"];
string sellId = Session["sellId"].ToString();
DataSet countds = smBll.getAllNum(sellId);
int allCount = int.Parse(countds.Tables[0].Rows[0]["sum(count)"].ToString());
double AllPrice = double.Parse(countds.Tables[0].Rows[0]["sum(totalPrice)"].ToString());
double realPrice = double.Parse(countds.Tables[0].Rows[0]["sum(realPrice)"].ToString());
int kinds = getKinds();
SellOffHead sell = new SellOffHead();
sell.Kinds = kinds;
sell.SellOffHeadId = sellId;
sell.Count = allCount;
sell.TotalPrice = AllPrice;
sell.RealPrice = realPrice;
if (op == "sure")
{
sell.State = 1;
}
else
{
sell.State = 0;
}
Result result = shBll.Update(sell);
if (result == Result.更新成功)
{
return("更新成功");
//Response.Write("更新成功");
//Response.End();
}
else
{
return("更新单头信息失败");
//Response.Write("更新单头信息失败");
//Response.End();
}
}
/// <summary>
/// 添加销退单头
/// </summary>
public void Insert()
{
string saleTaskId = Session["saleId"].ToString();
SaleTaskBll saleBll = new SaleTaskBll();
SaleTask sale = saleBll.selectById(saleTaskId);
User user = new User();
user.UserId = sale.UserId; //用户Id
string headId;
string sellId; //单头Id
sellOffHeadBll sellBll = new sellOffHeadBll();
DateTime nowTime = DateTime.Now;
string nowDt = nowTime.ToString("yyyy-MM-dd");
long count = 0;
//判断数据库中是否已经有记录
DataSet backds = soBll.getAllTime();
if (backds != null && backds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < backds.Tables[0].Rows.Count; i++)
{
string time = backds.Tables[0].Rows[i]["makingTime"].ToString();
DateTime dt = Convert.ToDateTime(time);
string sqlTime = dt.ToString("yyyy-MM-dd");
if (sqlTime == nowDt)
{
//count += 1;
string id = backds.Tables[0].Rows[i]["sellOffHeadID"].ToString();
string st1 = id.Substring(2);
count = long.Parse(st1);
headId = (count + 1).ToString();
//生成流水号
if (count > 0)
{
sellId = "XT" + headId;
}
else
{
count = 1;
sellId = "XT" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
}
SaleTask st = new SaleTask()
{
SaleTaskId = saleTaskId
};
SellOffHead sell = new SellOffHead()
{
SellOffHeadId = sellId,
SaleTaskId = st,
MakingTime = nowTime,
User = user
};
Result row = sellBll.Insert(sell);
if (row == Result.添加成功)
{
Response.Write("添加成功");
Response.End();
}
else
{
Response.Write("添加失败");
Response.End();
}
break;
}
else
{
count = 1;
sellId = "XT" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
SaleTask st = new SaleTask()
{
SaleTaskId = saleTaskId
};
SellOffHead sell = new SellOffHead()
{
SellOffHeadId = sellId,
SaleTaskId = st,
MakingTime = nowTime,
User = user
};
Result row = sellBll.Insert(sell);
if (row == Result.添加成功)
{
Response.Write("添加成功");
Response.End();
}
else
{
Response.Write("添加失败");
Response.End();
}
}
}
}
else
{
count = 1;
sellId = "XT" + DateTime.Now.ToString("yyyyMMdd") + count.ToString().PadLeft(6, '0');
SaleTask st = new SaleTask()
{
SaleTaskId = saleTaskId
};
SellOffHead sell = new SellOffHead()
{
SellOffHeadId = sellId,
SaleTaskId = st,
MakingTime = nowTime,
User = user
};
Result row = sellBll.Insert(sell);
if (row == Result.添加成功)
{
Response.Write("添加成功");
Response.End();
}
else
{
Response.Write("添加失败");
Response.End();
}
}
}
