/// <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;
}
