private void BindCostType()
{
List <EquipmentTypeInfo> myList = new List <EquipmentTypeInfo>();
IList <ICriterion> qryList = new List <ICriterion>();
qryList.Add(Expression.Eq("IsUsed", "1"));
Order[] orderList = new Order[1];
Order orderli = new Order("ID", true);
orderList[0] = orderli;
IList <EquipmentTypeInfo> list = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetAllByKeys(qryList, orderList);
myList.AddRange(list);
myList.Insert(0, new EquipmentTypeInfo {
ID = 0, TypeName = "选择分类"
});
ddlCostType.DataSource = myList;
ddlCostType.DataBind();
ddlCostType.SelectedIndex = 0;
if (Session["EquipmentInfoType"] != null && !Session["EquipmentInfoType"].ToString().Equals("-1"))
{
ddlCostType.SelectedValue = Session["EquipmentInfoType"].ToString();
EquipmentTypeInfo ETypeInfo = new EquipmentTypeInfo();
ETypeInfo = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(int.Parse(ddlCostType.SelectedValue));
if (ETypeInfo != null)
{
txtRemark.Text = ETypeInfo.Remark;
}
}
}
protected void ddlCostType_SelectedIndexChanged(object sender, EventArgs e)
{
EquipmentTypeInfo ETypeInfo = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(int.Parse(ddlCostType.SelectedValue));
if (ETypeInfo != null)
{
txtRemark.Text = ETypeInfo.Remark;
}
}
public async void EquipmentTypePropertiesAccepted(EquipmentTypeInfo equipmentType)
{
if (equipmentType == null)
{
throw new ArgumentNullException(nameof(equipmentType));
}
_view.SelectedEquipmentType = await SaveEquipmentTypeAsync(equipmentType);
}
private void BindDishesInfo()
{
if (TypeID == 1)
{
EquipmentTypeInfo DishesInfo = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(DishesID);
Grid1.Title = string.Format("主材名称：{0}（点击配套数量直接修改数量）", DishesInfo != null ? DishesInfo.TypeName : "");
}
else
{
EquipmentInfo DishesInfo = Core.Container.Instance.Resolve <IServiceEquipmentInfo>().GetEntity(DishesID);
Grid1.Title = string.Format("主材名称：{0}（点击配套数量直接修改数量）", DishesInfo != null ? string.Format("{0}[{1}]", DishesInfo.EquipmentName, "") : "");
}
}
//获取分类名称
public string GetType(string typeID)
{
EquipmentTypeInfo objType = new EquipmentTypeInfo();
string[] ids = typeID.Split(',');
if (int.Parse(ids[0]) > 0)
{
objType = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(int.Parse(ids[0]));
}
else
{
objType = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(int.Parse(ids[1]));
}
return(objType != null ? objType.TypeName : "");
}
public EquipmentTypeDialog(EquipmentTypeInfo equipmentType)
{
if (equipmentType == null)
{
throw new ArgumentNullException(nameof(equipmentType));
}
InitializeComponent();
_id = equipmentType.Id;
bindingSource.DataSource = equipmentType;
nameTextBox.RequireValue(errorProvider);
nameTextBox.TextChanged += (sender, args) => EnableOperations();
EnableOperations();
}
private void SetSelectedUsersEnableStatus(bool enabled)
{
string isUsed = enabled ? "1" : "0";
// 从每个选中的行中获取ID（在Grid1中定义的DataKeyNames）
List <int> ids = GetSelectedDataKeyIDs(Grid1);
// 执行数据库操作
foreach (int ID in ids)
{
EquipmentTypeInfo entity = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(ID);
entity.IsUsed = isUsed;
Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().Update(entity);
}
// 重新绑定表格
BindGrid();
}
public string GetGoodsType(string type)
{
string i = "";
EquipmentTypeInfo equipmentTypeInfo = new EquipmentTypeInfo();
if (!string.IsNullOrEmpty(type))
{
string[] goodsIDs = type.Split(',');
foreach (string id in goodsIDs)
{
equipmentTypeInfo = new EquipmentTypeInfo();
equipmentTypeInfo = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(int.Parse(id));
i += string.Format("{0},", equipmentTypeInfo.TypeName);
}
}
return(i);
}
/// <summary>
/// SelectInfo
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public EquipmentTypeInfo SelectInfo(long id)
{
CodeItemInfo codeItemInfo = dal.GetInfo(id);
if (codeItemInfo == null)
{
throw new Exception("MC:0x00000084");///数据错误
}
EquipmentTypeInfo equipmentTypeInfo = new EquipmentTypeInfo();
equipmentTypeInfo.Id = codeItemInfo.Id;
equipmentTypeInfo.ItemName = codeItemInfo.ItemName;
equipmentTypeInfo.Comments = codeItemInfo.Comments;
equipmentTypeInfo.ValidFlag = codeItemInfo.ValidFlag.GetValueOrDefault();
equipmentTypeInfo.CreateUser = codeItemInfo.CreateUser;
equipmentTypeInfo.CreateDate = codeItemInfo.CreateDate.GetValueOrDefault();
return(equipmentTypeInfo);
}
/// <summary>
/// InsertInfo
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool InsertInfo(EquipmentTypeInfo info)
{
int cnt = dal.GetCounts("[ITEM_NAME] = N'" + info.ItemName + "' and [CODE_FID] = N'" + codeFid + "'");
if (cnt > 0)
{
throw new Exception("MC:0x00000115");///设备类型不能重复
}
CodeItemInfo codeItemInfo = new CodeItemInfo();
codeItemInfo.Fid = Guid.NewGuid();
codeItemInfo.ItemName = info.ItemName;
codeItemInfo.Comments = info.Comments;
codeItemInfo.CodeFid = Guid.Parse(codeFid);
codeItemInfo.ValidFlag = true;
codeItemInfo.CreateUser = info.CreateUser;
codeItemInfo.CreateDate = info.CreateDate;
return(dal.Add(codeItemInfo) > 0 ? true : false);
}
public void Bind()
{
if (InfoID > 0)
{
EquipmentTypeInfo objInfo = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(InfoID);
if (objInfo == null)
{
// 参数错误，首先弹出Alert对话框然后关闭弹出窗口
Alert.Show("参数错误！", String.Empty, ActiveWindow.GetHideReference());
return;
}
tbxName.Text = objInfo.TypeName;
tbxRemark.Text = objInfo.Remark;
ddlIsUsed.SelectedValue = objInfo.IsUsed.ToString();
rbtClass.SelectedValue = objInfo.TypeClass.ToString();
}
}
private async Task <EquipmentTypeInfo> SaveEquipmentTypeAsync(EquipmentTypeInfo equipmentType)
{
if (_view.EquipmentTypes.All(x => x.Id != equipmentType.Id))
{
equipmentType = await _equipmentTypeService.AddAsync(equipmentType);
_view.EquipmentTypes.Add(equipmentType);
}
else
{
await _equipmentTypeService.UpdateAsync(equipmentType);
equipmentType = await _equipmentTypeService.GetAsync(equipmentType.Id);
_view.EquipmentTypes.AddOrReplace(x => x.Id == equipmentType.Id, equipmentType);
}
return(equipmentType);
}
/// <summary>
/// GetListByPage
/// </summary>
/// <param name="textWhere"></param>
/// <param name="textOrder"></param>
/// <param name="pageIndex"></param>
/// <param name="pageRow"></param>
/// <param name="dataCount"></param>
/// <returns></returns>
public List <EquipmentTypeInfo> GetListByPage(string textWhere, string textOrder, int pageIndex, int pageRow, out int dataCount)
{
textWhere += " and [CODE_FID] = N'" + codeFid + "'";
dataCount = dal.GetCounts(textWhere);
List <CodeItemInfo> codeItemInfos = dal.GetListByPage(textWhere, textOrder, pageIndex, pageRow);
List <EquipmentTypeInfo> equipmentTypeInfos = new List <EquipmentTypeInfo>();
foreach (var codeItemInfo in codeItemInfos)
{
EquipmentTypeInfo equipmentTypeInfo = new EquipmentTypeInfo();
equipmentTypeInfo.Id = codeItemInfo.Id;
equipmentTypeInfo.ItemName = codeItemInfo.ItemName;
equipmentTypeInfo.Comments = codeItemInfo.Comments;
equipmentTypeInfo.ValidFlag = codeItemInfo.ValidFlag.GetValueOrDefault();
equipmentTypeInfo.CreateUser = codeItemInfo.CreateUser;
equipmentTypeInfo.CreateDate = codeItemInfo.CreateDate.GetValueOrDefault();
equipmentTypeInfos.Add(equipmentTypeInfo);
}
return(equipmentTypeInfos);
}
/// <summary>
/// 绑定价格套系商品信息
/// </summary>
private void BindGrid()
{
//获取物品规格信息
IList <ICriterion> qryList = new List <ICriterion>();
qryList.Add(Expression.Eq("SetID", int.Parse(ddlWH.SelectedValue)));
if (ddlCostType.SelectedValue != "0")
{
qryList.Add(Expression.Eq("GoodsTypeID", int.Parse(ddlCostType.SelectedValue)));
}
Order[] orderList = new Order[1];
Order orderli = new Order("ID", true);
orderList[0] = orderli;
//从默认的销售库房中获取当前库存大于0的物品信息
IList <PriceSetGoodsInfo> list = Core.Container.Instance.Resolve <IServicePriceSetGoodsInfo>().GetAllByKeys(qryList, orderList);
foreach (PriceSetGoodsInfo detail in list)
{
if (detail.IsGoodType > 1)
{
detail.GoodsInfo = Core.Container.Instance.Resolve <IServiceEquipmentInfo>().GetEntity(detail.EquipmentID);
//detail.EquipmentCode = detail.GoodsInfo.EquipmentCode;
detail.EquipmentName = detail.GoodsInfo.EquipmentName;
//detail.Standard = detail.GoodsInfo.Standard;
detail.EquipmentUnit = detail.GoodsInfo.EquipmentUnit;
}
else
{
EquipmentTypeInfo typeObj = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(detail.EquipmentID);
detail.EquipmentCode = "";
detail.EquipmentName = typeObj.TypeName;
detail.Standard = 1;
}
}
Grid1.DataSource = list;
Grid1.DataBind();
}
/// <summary>
/// 创建买赔物品明细
/// </summary>
/// <param name="orderNO">合同买赔单号</param>
private void CreatePayGoodsInfo(string orderNO)
{
ContractPayOrderDetail payOrderDetail = new ContractPayOrderDetail();
//获取合同信息
ContractInfo contractInfo = Core.Container.Instance.Resolve <IServiceContractInfo>().GetEntity(int.Parse(ddlContract.SelectedValue));
//获取合同价格套系信息
// PriceSetInfo priceSetInfo = Core.Container.Instance.Resolve<IServicePriceSetInfo>().GetEntity(contractInfo.PriceSetID);
//获取合同发货主材类别信息
string sql = string.Format(@"select * from EquipmentTypeInfo where id in (select distinct(GoodTypeID) as GoodTypeID from ContractOrderDetail where OrderNO in (select OrderNO from ContractOrderInfo where ContractID ={0} and OrderType=1))", contractInfo.ID);
DataSet ds = DbHelperSQL.Query(sql);
if (ds.Tables[0] != null)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
payOrderDetail = new ContractPayOrderDetail();
payOrderDetail.OrderNO = OrderNO;
payOrderDetail.OrderDate = DateTime.Now;
payOrderDetail.GoodTypeID = int.Parse(row["ID"].ToString());
payOrderDetail.GoodsNumber = 0;
payOrderDetail.GoodsUnit = row["TypeUnit"].ToString();
payOrderDetail.GoodsUnitPrice = decimal.Parse(row["PayForPrice"].ToString());
/*-------------------获取合同价格-------------------*/
EquipmentTypeInfo equipmentTypeInfo = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(payOrderDetail.GoodTypeID);
IList <ICriterion> qryList = new List <ICriterion>();
//qryList.Add(Expression.Eq("SetID", priceSetInfo.ID));
qryList.Add(Expression.Eq("EquipmentID", payOrderDetail.GoodTypeID));
PriceSetGoodsInfo priceSetGoodsInfo = Core.Container.Instance.Resolve <IServicePriceSetGoodsInfo>().GetEntityByFields(qryList);
if (priceSetGoodsInfo != null)
{
payOrderDetail.GoodsUnitPrice = priceSetGoodsInfo.UnitPrice;
}
payOrderDetail.PayAmount = payOrderDetail.GoodsNumber * payOrderDetail.GoodsUnitPrice;
//保存赔偿材料信息
Core.Container.Instance.Resolve <IServiceContractPayOrderDetail>().Create(payOrderDetail);
}
}
}
private void SaveItem()
{
EquipmentTypeInfo objInfo = new EquipmentTypeInfo();
if (InfoID > 0)
{
objInfo = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(InfoID);
}
objInfo.TypeName = tbxName.Text.Trim();
objInfo.IsUsed = ddlIsUsed.SelectedValue;
//起租天数
objInfo.Remark = tbxRemark.Text;
objInfo.TypeClass = rbtClass.SelectedValue;
if (InfoID > 0)
{
Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().Update(objInfo);
}
else
{
Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().Create(objInfo);
}
}
private void SaveItem()
{
// 从每个选中的行中获取ID（在Grid1中定义的DataKeyNames）
List <int> ids = GetSelectedDataKeyIDs(Grid1);
WHGoodsDetail whGoodsEntity = new WHGoodsDetail();
EquipmentInfo goodsEntity = new EquipmentInfo();
EquipmentTypeInfo goodsTypeEntity = new EquipmentTypeInfo();
ReceiveOrderDetail dbEntity = new ReceiveOrderDetail();
// 执行数据库操作
foreach (int ID in ids)
{
//获取物品信息
whGoodsEntity = Core.Container.Instance.Resolve <IServiceWHGoodsDetail>().GetEntity(ID);
if (goodsEntity != null)
{
whGoodsEntity.GoodsInfo = Core.Container.Instance.Resolve <IServiceEquipmentInfo>().GetEntity(whGoodsEntity.GoodsID);
//获取商品类别信息
goodsTypeEntity = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(whGoodsEntity.GoodsTypeID);
//判断是否已经添加改商品物品
if (!IsExists(ID))
{
dbEntity = new ReceiveOrderDetail();
dbEntity.OrderNO = OrderNO;
dbEntity.OrderDate = DateTime.Now;
dbEntity.GoodsID = whGoodsEntity.GoodsID;
dbEntity.GoodsNumber = 1;
dbEntity.GoodsUnit = whGoodsEntity.InventoryUnit;
dbEntity.GoodsUnitPrice = whGoodsEntity.InventoryUnitPrice;
dbEntity.GoodTotalPrice = Math.Round(dbEntity.GoodsNumber * dbEntity.GoodsUnitPrice, 2);
//保存领用物品信息
Core.Container.Instance.Resolve <IServiceReceiveOrderDetail>().Create(dbEntity);
}
}
}
}
/// <summary>
/// 获取材料分类名称
/// </summary>
/// <param name="typeID">分类ID</param>
/// <returns>分类名称</returns>
public string GetType(string typeID)
{
EquipmentTypeInfo objType = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(int.Parse(typeID));
return(objType != null ? objType.TypeName : "");
}
private void SaveItem()
{
// 从每个选中的行中获取ID（在Grid1中定义的DataKeyNames）
List <int> ids = GetSelectedDataKeyIDs(Grid1);
WHGoodsDetail whGoodsEntity = new WHGoodsDetail();
ContractOrderDetail dbEntity = new ContractOrderDetail();
IList <ICriterion> qryList = new List <ICriterion>();
PriceSetInfo priceSetInfo = new PriceSetInfo();
//获取合同信息
ContractInfo contractInfo = Core.Container.Instance.Resolve <IServiceContractInfo>().GetEntity(ContractID);
// 执行数据库操作
foreach (int ID in ids)
{
//获取物品信息
whGoodsEntity = Core.Container.Instance.Resolve <IServiceWHGoodsDetail>().GetEntity(ID);
if (whGoodsEntity != null)
{
whGoodsEntity.GoodsInfo = Core.Container.Instance.Resolve <IServiceEquipmentInfo>().GetEntity(whGoodsEntity.GoodsID);
//判断是否已经添加改商品物品
if (whGoodsEntity.GoodsInfo != null && !IsExists(whGoodsEntity.GoodsID))
{
#region 主材
dbEntity = new ContractOrderDetail();
dbEntity.OrderNO = OrderNO;
dbEntity.OrderDate = DateTime.Now;
dbEntity.GoodsID = whGoodsEntity.GoodsID;
dbEntity.GoodTypeID = whGoodsEntity.GoodsTypeID;
dbEntity.GoodsNumber = 1;
dbEntity.FormerlyGoodsNumber = 1;
dbEntity.FixGoodsNumber = 0;
dbEntity.GoodsUnit = whGoodsEntity.InventoryUnit;
//dbEntity.GoodsCalcUnit = whGoodsEntity.GoodsInfo.CalcPriceUnit;
//dbEntity.NotOffsetNumber = dbEntity.GoodsNumber;
//dbEntity.GoodCalcPriceNumber = dbEntity.GoodsNumber * whGoodsEntity.GoodsInfo.Standard;
//dbEntity.PayUnit = whGoodsEntity.GoodsInfo.PayUnit;
/*-------------------获取价格-------------------*/
//获取主材类别，根据类别的报价策略获取价格
EquipmentTypeInfo equipmentTypeInfo = Core.Container.Instance.Resolve <IServiceEquipmentTypeInfo>().GetEntity(whGoodsEntity.GoodsInfo.EquipmentTypeID);
//dbEntity.IsStockByRepaired = equipmentTypeInfo.IsStockByRepaired;
//priceSetInfo = Core.Container.Instance.Resolve<IServicePriceSetInfo>().GetEntity(contractInfo.PriceSetID);
qryList = new List <ICriterion>();
qryList.Add(Expression.Eq("SetID", priceSetInfo.ID));
// 报价类型 1:按类别统计报价 2：按物品分别报价 3：不参与合同报价
//if (equipmentTypeInfo.PriceSetType == 1)
//{
// qryList.Add(Expression.Eq("EquipmentID", whGoodsEntity.GoodsInfo.EquipmentTypeID));
//}
//if (equipmentTypeInfo.PriceSetType == 2)
//{
// qryList.Add(Expression.Eq("EquipmentID", whGoodsEntity.GoodsID));
//}
PriceSetGoodsInfo priceSetGoodsInfo = Core.Container.Instance.Resolve <IServicePriceSetGoodsInfo>().GetEntityByFields(qryList);
if (priceSetGoodsInfo != null)
{
dbEntity.GoodsUnitPrice = priceSetGoodsInfo.DailyRents;
//判断物品费用是日租金还是现金买赔
//if (whGoodsEntity.GoodsInfo.IsPayNow == 1)
//{
// dbEntity.GoodsUnitPrice = priceSetGoodsInfo.UnitPrice;
//}
}
else
{
// dbEntity.GoodsUnitPrice = whGoodsEntity.GoodsInfo.DailyRents;
//判断物品费用是日租金还是现金买赔
//if (whGoodsEntity.GoodsInfo.IsPayNow == 1)
//{
// dbEntity.GoodsUnitPrice = whGoodsEntity.GoodsInfo.UnitPrice;
//}
}
dbEntity.NotOffsetNumber = 1;
dbEntity.WareHouseID = int.Parse(ddlWH.SelectedValue);
//保存领用主材信息
Core.Container.Instance.Resolve <IServiceContractOrderDetail>().Create(dbEntity);
#endregion 主材
//辅材列表
if (OrderType == 1)
{
//创建发货单辅材信息
CreateFHSecondaryDetail(dbEntity, priceSetInfo, whGoodsEntity);
}
else
{
//创建收货单辅材信息
CreateSHSecondaryDetail(dbEntity, priceSetInfo, whGoodsEntity);
}
}
}
}
}
/// <summary>
/// 依據傳入的工作站取得可使用機台清單
/// </summary>
/// <param name="operationName">工作站名稱</param>
public static List <EquipmentInfo> GetEquipmentListByOperationName(string operationName)
{
//清除機台清單
List <EquipmentInfo> equipmentList = new List <EquipmentInfo>();
//取得批號目前的工作站資料
var operationData = OperationInfo.GetOperationByName(operationName);
if (operationData == null)
{
//[00171]工作站:{0}不存在!!
throw new Exception(TextMessage.Error.T00171(operationName));
}
//確認工作站是否有啟用使用機台的功能
if (operationData.EQUIPFLAG == "Y")
{
//依據工作站找出歸屬的機台群組清單
List <OperationResourceInfoEx> resourceDataList = OperationResourceInfoEx.GetDataByOperSID(operationData.OperationSID);
if (resourceDataList.Count > 0)
{
#region 取得該工作站可使用的所有機台資料
foreach (var resourceData in resourceDataList)
{
if (resourceData.ResourceType == "Group")
{
//如果資源類別為Group，則找出此機台群組內的所有機台資訊
var equipGroupData = EquipmentGroupInfo.GetEquipmentGroupByID(resourceData.ResourceID);
//用群組SID找出在該群組下的工作站
List <EquipGroupEquipInfoEx> eqGroupDataList = EquipGroupEquipInfoEx.GetEquipGroupByGroupSID(equipGroupData.ID);
if (eqGroupDataList.Count > 0)
{
foreach (var eqGroupData in eqGroupDataList)
{
//取得機台資訊
var equipmentData = EquipmentInfo.GetEquipmentByName(eqGroupData.EquipmentName);
//如果機台資料不為NULL才要確認是否己經加入清單內
if (equipmentData != null)
{
//確認是否已經加入機台清單
if (equipmentList.Contains(equipmentData) == false)
{
equipmentList.Add(equipmentData);
}
}
}
}
}
else if (resourceData.ResourceType == "Equip")
{
//如果資源類別為Equip，則加入此機台資訊
var equipmentData = EquipmentInfo.GetEquipmentByID(resourceData.ResourceID);
//如果機台資料不為NULL才要確認是否己經加入清單內
if (equipmentData != null)
{
//確認是否已經加入機台清單
if (equipmentList.Contains(equipmentData) == false)
{
equipmentList.Add(equipmentData);
}
}
}
else if (resourceData.ResourceType == "Type")
{
//如果資源類別為Type，則加入所有此Type的機台資訊
var equipmentTypeData = EquipmentTypeInfo.GetEquipmentTypeByID(resourceData.ResourceID);
var equipmentDatalList = EquipmentInfo.GetEquipmentsByType(equipmentTypeData);
foreach (var equipmentData in equipmentDatalList)
{
//確認是否已經加入機台清單
if (equipmentList.Contains(equipmentData) == false)
{
equipmentList.Add(equipmentData);
}
}
}
}
#endregion
}
}
//以機台名稱排序
equipmentList.Sort(p => p.EquipmentName);
return(equipmentList);
}
