/// <summary> /// 删除选择的数据集记录 /// </summary> private void sbtnDelete_Click(object sender, EventArgs e) { if (gvData.FocusedRowHandle >= 0) { Models.ys_Assets m = selectList.FirstOrDefault(s => s.Id.Equals(gvData.GetFocusedRowCellValue("Id"))); assetsList.Add(m); selectList.Remove(m); cbStock_EditValueChanged(null, null); gcData.RefreshDataSource(); } }
/// <summary> /// 添加选择的数据集记录 /// </summary> private void sbtnAdd_Click(object sender, EventArgs e) { if (cbAssets.EditValue != null) { Models.ys_Assets m = assetsList.FirstOrDefault(a => a.Id.Equals(cbAssets.EditValue)); assetsList.Remove(m); selectList.Add(m); cbStock_EditValueChanged(null, null); cbAssets.EditValue = null; gcData.RefreshDataSource(); } }
/// <summary> /// 删除选择的数据集记录 /// </summary> private void sbtnDelete_Click(object sender, EventArgs e) { if (gvData.FocusedRowHandle >= 0) { Models.ys_Assets m = selectAssets.Find(s => s.Id.Equals(gvData.GetFocusedRowCellValue("Id"))); selectAssets.Remove(m); AllAssets.Add(m); glu_FA_Stock_EditValueChanged(null, null); gcData.RefreshDataSource(); } }
/// <summary> /// 添加选择的数据集记录 /// </summary> private void sbtnAdd_Click(object sender, EventArgs e) { if (glu_FA.EditValue != null) { Models.ys_Assets m = AllAssets.Find(s => s.Id.Equals(glu_FA.EditValue)); AllAssets.Remove(m); selectAssets.Add(m); glu_FA_Stock_EditValueChanged(null, null); glu_FA.EditValue = null; gcData.RefreshDataSource(); } }
/// <summary> /// 修改产资信息 /// </summary> public override void Modify() { object objId = gvData.GetFocusedRowCellValue("Id"); if (objId != null && gvData.GetFocusedRowCellValue("StatusName").ToString() != "报废" && gvData.GetFocusedRowCellValue("StatusName").ToString() != "删除") { Models.ys_Assets model = AllAssets.FirstOrDefault(a => a.Id == (Guid)objId); AssetsEditForm sub = new AssetsEditForm(model); if (sub.ShowDialog() == DialogResult.OK) { Query(); } } }
public void AddLyOrder() { Models.ys_ApplyOrder lyModel = new Models.ys_ApplyOrder(); BLL.ApplyOrderManager applyOrderManager = new BLL.ApplyOrderManager(); if (cbtlDepartment.EditValue != null || cbtlDepartment.EditValue != null) { lyModel.ApplyNo = applyOrderManager.GetNewApplyNo();//生成订单号 lyModel.Id = Guid.NewGuid(); lyModel.Location = cblocation.Text; lyModel.ApplyUserId = Utils.cls.clsPublic.GetObjGUID(cbUser.EditValue); lyModel.ApplyUserName = cbUser.Text; if (cbtlDepartment.EditValue == null) { lyModel.ApplyDepartmentId = Utils.cls.clsPublic.GetObjGUID(cbUser.Properties.View.GetFocusedRowCellValue("DepartmentId")); } else { lyModel.ApplyDepartmentId = Utils.cls.clsPublic.GetObjGUID(cbtlDepartment.EditValue); } lyModel.OperatorId = clsSession._UserId; lyModel.OperatorName = clsSession._FullName; lyModel.Description = "登记时生成"; lyModel.Applyday = DateTime.Now; List <Models.ys_ApplyOrderDetail> details = new List <Models.ys_ApplyOrderDetail>(); Models.ys_ApplyOrderDetail d = new Models.ys_ApplyOrderDetail(); model = assetsManager.GetOneById(model.Id); d.AssetsId = model.Id; d.ApplyId = lyModel.Id; d.OldStatusId = model.StatusId; details.Add(d); lyModel.Detail = details; //生成新的领用单 if (applyOrderManager.AddNew(lyModel)) { clsPublic.ShowMessage("领用单生成成功!", Text); } else { clsPublic.ShowMessage("领用单生成失败!", Text); } } }
/// <summary> /// 修改 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool Modify(Models.ys_Assets model) { string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_Assets] SET [Barcode] = @Barcode ,[Name] = @Name ,[Model] = @Model ,[CompanyId] = @CompanyId ,[CategoryId] = @CategoryId ,[DepartmentId] = @DepartmentId ,[UserId] = @UserId ,[Buyday] = @Buyday ,[Location] = @Location ,[StockId] = @StockId ,[Price] = @Price ,[Description] = @Description ,[CreateTime] = @CreateTime ,[XmlInf] = @XmlInf ,[StatusId] = @StatusId ,[IsRemoved] = @IsRemoved WHERE [Id] = @Id"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@Barcode", model.Barcode); SqlParameter s3 = new SqlParameter("@Name", model.Name); SqlParameter s4 = new SqlParameter("@Model", model.Model); SqlParameter s5 = new SqlParameter("@CategoryId", model.CategoryId); SqlParameter s6 = new SqlParameter("@CompanyId", model.CompanyId); SqlParameter s7 = new SqlParameter("@DepartmentId", model.DepartmentId); SqlParameter s8 = new SqlParameter("@UserId", model.UserId); SqlParameter s9 = new SqlParameter("@Buyday", model.Buyday); SqlParameter s10 = new SqlParameter("@Location", model.Location); SqlParameter s16 = new SqlParameter("@StockId", model.StockId); SqlParameter s17 = new SqlParameter("@Price", model.Price); SqlParameter s11 = new SqlParameter("@Description", model.Description); SqlParameter s12 = new SqlParameter("@CreateTime", model.CreateTime); SqlParameter s13 = new SqlParameter("@XmlInf", model.XmlInf); SqlParameter s14 = new SqlParameter("@StatusId", model.StatusId); SqlParameter s15 = new SqlParameter("@IsRemoved", model.IsRemoved); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4,s5,s6, s7, s8, s9, s10, s11, s12, s13, s14, s15, s16, s17 }; return Models.SqlHelper.ExecuteNoQuery(sqlText, cmdPara) > 0 ? true : false; }
public AssetsEditForm(Models.ys_Assets smodel) : this() { model = smodel; IsAddNew = false; groupUserInfo.Enabled = false; d_Buytime.Enabled = false; txtPrice.ReadOnly = true; txt_FA_Name.Text = model.Name; cbtlCategory.EditValue = model.CategoryId; txt_Barcode.Text = model.Barcode; cbCompany.EditValue = model.CompanyId; d_Buytime.DateTime = model.Buyday; txt_FA_Model.Text = model.Model; cbStock.EditValue = model.StockId; txtPrice.EditValue = model.Price; cblocation.Text = model.Location; txt_FA_Desc.Text = model.Description; setXmlInf(model.XmlInf); }
private void sbtnAdd_Click(object sender, EventArgs e) { if (cbxAsset.EditValue != null && txtRepairReason.Text.Trim() != "" && cbxRepairUser.EditValue != null && cbxCompany.EditValue != null) { Models.ys_Assets model = Allview.Find(s => s.Id.Equals((Guid)cbxAsset.EditValue)); Allview.Remove(model); cbxAsset.EditValue = null; #region Models.ys_RepairOrder m = new Models.ys_RepairOrder(); m.Id = Guid.NewGuid(); m.AssetsId = model.Id; m.CompanyId = (Guid)cbxCompany.EditValue; m.CompanyName = cbxCompany.Text; m.OperatorId = clsSession._UserId; m.OperatorName = clsSession._FullName; m.Repairday = tRepairday.DateTime; m.RepairNo = this.NewRepairNo; m.RepairPrice = clsPublic.ToDecimal(txtRepairPrice.EditValue); m.RepairReason = txtRepairReason.Text; m.RepairUserId = clsPublic.GetObjGUID(cbxRepairUser.EditValue); m.RepairUserName = cbxRepairUser.Text; m.OldStatusId = model.StatusId; m.AssetsModel = model; #endregion selectview.Add(m); gcData.RefreshDataSource(); cbxStock_EditValueChanged(null, null); } else { clsPublic.ShowMessage("维修机构、报修人员、维修资产、维修原因不能为空!", Text); } }
/// <summary> /// 修改 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool Modify(Models.ys_Assets model) { return(dal.Modify(model)); }
/// <summary> /// 新增 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool AddNew(Models.ys_Assets model) { return(dal.AddNew(model)); }
{ /// <summary> /// 新增 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool AddNew(Models.ys_Assets model) { Dictionary<SqlParameter[], string> sqlDic = new Dictionary<SqlParameter[], string>(); string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_Assets] ([Id] ,[Barcode] ,[Name] ,[Model] ,[CompanyId] ,[CategoryId] ,[DepartmentId] ,[UserId] ,[Buyday] ,[Location] ,[StockId] ,[Price] ,[Description] ,[CreateTime] ,[XmlInf] ,[StatusId] ,[IsRemoved]) VALUES (@Id ,@Barcode ,@Name ,@Model ,@CompanyId ,@CategoryId ,@DepartmentId ,@UserId ,@Buyday ,@Location ,@StockId ,@Price ,@Description ,@CreateTime ,@XmlInf ,@StatusId ,@IsRemoved)"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@Barcode", model.Barcode); SqlParameter s3 = new SqlParameter("@Name", model.Name); SqlParameter s4 = new SqlParameter("@Model", model.Model); SqlParameter s5 = new SqlParameter("@CategoryId", model.CategoryId); SqlParameter s6 = new SqlParameter("@CompanyId", model.CompanyId); SqlParameter s7 = new SqlParameter("@DepartmentId", model.DepartmentId); SqlParameter s8 = new SqlParameter("@UserId", model.UserId); SqlParameter s9 = new SqlParameter("@Buyday", model.Buyday); SqlParameter s10 = new SqlParameter("@Location", model.Location); SqlParameter s16 = new SqlParameter("@StockId", model.StockId); SqlParameter s17 = new SqlParameter("@Price", model.Price); SqlParameter s11 = new SqlParameter("@Description", model.Description); SqlParameter s12= new SqlParameter("@CreateTime", model.CreateTime); SqlParameter s13 = new SqlParameter("@XmlInf", model.XmlInf); SqlParameter s14 = new SqlParameter("@StatusId", model.StatusId); SqlParameter s15 = new SqlParameter("@IsRemoved", model.IsRemoved); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4,s5, s6, s7, s8,s9,s10,s11,s12,s13,s14,s15,s16,s17}; KeyValuePair<SqlParameter[], string> item = StatusChangeSerivce.AddNew("登记", "LK"+DateTime.Now.ToString("yyyyMMdd"), model.Id,model.OperatorId.ToString(),model.OperatorName); sqlDic.Add(item.Key, item.Value); sqlDic.Add(cmdPara, sqlText); return Models.SqlHelper.ExecuteTransaction1(sqlDic,false) > 0 ? true : false; }