/**
* 17.员工增加订单记录
* 参数：staffId, 这次订单的详细信息数组
* 返回值：本次订单（需要修改stock） //个人感觉这个不需要修改库存，在添加细节的时候再修改库存------->请注意
*/
public order addOrderInfo(string staffId)
{
string newId = createNewId("order");
string newId2 = "outBase_";
for (int i = 6; i < newId.Length; i++)
{
newId2 = newId2 + newId[i];
}
string shopId = getShopIdByStaffId(staffId);
using (YMDBEntities db = new YMDBEntities())
{
try
{
staff targetStaff = findStaffByStaffId(staffId);
order targetOrder = new order
{
orderId = newId,
shopId = targetStaff.shopId,
totalPrice = 0,
orderTime = DateTime.Now,
};
db.order.Add(targetOrder);
outBase newOutBase = new outBase
{
outId = newId2,
shopId = shopId,
staffId = staffId,
outTime = DateTime.Now,
outType = "sell",
};
db.outBase.Add(newOutBase);
db.SaveChanges();
return targetOrder;
}
catch (NullReferenceException ex)
{
System.Diagnostics.Debug.WriteLine("输入staffId的时候有问题，回去查!!!!!");
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
return null;
}
}
}
/**
* 25.员工新建出库登记表
* 参数：员工Id,出库类型
* 返回：员工新建一个出库登记表(通过测试)
*/
public outBase addNewOut(string outStaffId,string currentOutType)
{
if (!currentOutType.Equals("调货") && !currentOutType.Equals("补货"))
{
System.Diagnostics.Debug.WriteLine("新建出库登记表出错啦.");
return null;
}
string currentShopId = getShopIdByStaffId(outStaffId);
using (YMDBEntities db = new YMDBEntities())
{
try
{
string newId = createNewId("outBase");
outBase newOutBase = new outBase
{
outId = newId,
shopId = currentShopId,
staffId = outStaffId,
outType = currentOutType,
outTime = DateTime.Now,
};
db.outBase.Add(newOutBase);
db.SaveChanges();
return newOutBase;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("出库登记表添加失败.");
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
return null;
}
}
}
/**
* 62.增加商店出库记录(测试通过)
* 参数：员工Id
* 返回值：出库记录
*/
public outBase addNewOutBaseRecord(string staffId)
{
string shopId = getShopIdByStaffId(staffId);
string newId = createNewId("outBase");
using (YMDBEntities db = new YMDBEntities())
{
try
{
outBase newOutBase = new outBase
{
outId = newId,
shopId = shopId,
staffId = staffId,
outTime = DateTime.Now,
outType = "export",
};
db.outBase.Add(newOutBase);
db.SaveChanges();
return newOutBase;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("没找到shopId导致完整性约束不满足，拒绝插入数据库，请检查staffId.");
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
return null;
}
}
}
