/// <summary>
/// 新增维修记录
/// </summary>
/// <param name="model"></param>
public void AddDicByRepairOrder(Models.ys_RepairOrder model)
{
#region sqltext
string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_RepairOrder]
([Id]
,[RepairNo]
,[AssetsId]
,[CompanyId]
,[CompanyName]
,[RepairUserId]
,[RepairUserName]
,[Repairday]
,[OperatorId]
,[OperatorName]
,[RepairPrice]
,[RepairReason]
,[IsRemoved]
,[CreateTime]
,[OldStatusId])
VALUES(@Id
,@RepairNo
,@AssetsId
,@CompanyId
,@CompanyName
,@RepairUserId
,@RepairUserName
,@Repairday
,@OperatorId
,@OperatorName
,@RepairPrice
,@RepairReason
,@IsRemoved
,@CreateTime
,@OldStatusId)";
#endregion
#region sqlParam
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@RepairNo", model.RepairNo);
SqlParameter s3 = new SqlParameter("@AssetsId", model.AssetsId);
SqlParameter s4 = new SqlParameter("@CompanyId", model.CompanyId);
SqlParameter s5 = new SqlParameter("@CompanyName", model.CompanyName);
SqlParameter s6 = new SqlParameter("@RepairUserId", model.RepairUserId);
SqlParameter s7 = new SqlParameter("@RepairUserName", model.RepairUserName);
SqlParameter s8 = new SqlParameter("@Repairday", model.Repairday);
SqlParameter s9 = new SqlParameter("@OperatorId", model.OperatorId);
SqlParameter s10 = new SqlParameter("@OperatorName", model.OperatorName);
SqlParameter s11 = new SqlParameter("@RepairPrice", model.RepairPrice);
SqlParameter s12 = new SqlParameter("@CreateTime", model.CreateTime);
SqlParameter s13 = new SqlParameter("@IsRemoved", model.IsRemoved);
SqlParameter s14 = new SqlParameter("@RepairReason", model.RepairReason);
SqlParameter s15 = new SqlParameter("@OldStatusId", model.OldStatusId);
#endregion
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13, s14, s15 };
dicCmd.Add(cmdPara, sqlText);
}
private void sbtnDelete_Click(object sender, EventArgs e)
{
if (gvData.FocusedRowHandle >= 0)
{
Models.ys_RepairOrder model = selectview.Find(s => s.AssetsId.Equals(gvData.GetFocusedRowCellValue("AssetsId")));
selectview.Remove(model);
gcData.RefreshDataSource();
cbxAsset.EditValue = null;
Allview.Add(assetsManager.GetOneById(model.AssetsId));
cbxStock_EditValueChanged(null, null);
}
}
/// <summary>
/// 修改指定的维修记录
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public void AddDicModifyByRepairOrder(Models.ys_RepairOrder model)
{
#region sqltext
string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_RepairOrder]
SET [RepairNo] = @RepairNo
,[AssetsId] = @AssetsId
,[CompanyId] = @CompanyId
,[CompanyName] = @CompanyName
,[RepairUserId] = @RepairUserId
,[RepairUserName] = @RepairUserName
,[Repairday] = @Repairday
,[OperatorId] = @OperatorId
,[OperatorName] = @OperatorName
,[RepairPrice] = @RepairPrice
,[RepairReason] = @RepairReason
,[RepairDescription] = @RepairDescription
,[FinishUserId] = @FinishUserId
,[FinishUserName] = @FinishUserName
,[Finishday] = @Finishday
,[IsFinish] = @IsFinish
,[IsRemoved] = @IsRemoved
,[CreateTime] = @CreateTime
WHERE [Id] = @Id";
#endregion
#region sqlParam
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@RepairNo", model.RepairNo);
SqlParameter s3 = new SqlParameter("@AssetsId", model.AssetsId);
SqlParameter s4 = new SqlParameter("@CompanyId", model.CompanyId);
SqlParameter s5 = new SqlParameter("@CompanyName", model.CompanyName);
SqlParameter s6 = new SqlParameter("@RepairUserId", model.RepairUserId);
SqlParameter s7 = new SqlParameter("@RepairUserName", model.RepairUserName);
SqlParameter s8 = new SqlParameter("@Repairday", model.Repairday);
SqlParameter s9 = new SqlParameter("@OperatorId", model.OperatorId);
SqlParameter s10 = new SqlParameter("@OperatorName", model.OperatorName);
SqlParameter s11 = new SqlParameter("@RepairPrice", model.RepairPrice);
SqlParameter s12 = new SqlParameter("@CreateTime", model.CreateTime);
SqlParameter s13 = new SqlParameter("@IsRemoved", model.IsRemoved);
SqlParameter s14 = new SqlParameter("@Finishday", model.Finishday);
SqlParameter s15 = new SqlParameter("@FinishUserId", model.FinishUserId);
SqlParameter s16 = new SqlParameter("@FinishUserName", model.FinishUserName);
SqlParameter s17 = new SqlParameter("@IsFinish", model.IsFinish);
SqlParameter s19 = new SqlParameter("@RepairDescription", model.RepairDescription);
SqlParameter s20 = new SqlParameter("@RepairReason", model.RepairReason);
#endregion
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13, s14, s15, s16, s17, s19, s20 };
dicCmd.Add(cmdPara, sqlText);
}
/// <summary>
/// 初始化方法
/// </summary>
/// <param name="Id"></param>
private void Initial(Guid Id)
{
AppPublic.Control.InitalControlHelper.ys_Company_GridLookUpEdit(cbxCompany);
AppPublic.Control.InitalControlHelper.Assets_GridLookUpEdit(cbxAssets, new AssetsStatus[] { AssetsStatus.WX });
model = manager.GetOneById(Id);
txtWXID.Text = model.RepairNo;
dBeginday.DateTime = model.Repairday;
txtOperatorUser.EditValue = model.OperatorName;
txtRepairUser.EditValue = model.RepairUserName;
txtRepairReason.EditValue = model.RepairReason;
txtPrice.EditValue = model.RepairPrice;
txtRepairDescription.Text = model.RepairDescription;
cbxCompany.EditValue = model.CompanyId;
cbxAssets.EditValue = model.AssetsId;
}
/// <summary>
/// 更新资产状态
/// </summary>
/// <param name="model"></param>
public void AddDicByUpdateAssets(Models.ys_RepairOrder model)
{
if (model.IsFinish)
{
string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_Assets]
SET [StatusId] = @StatusId
WHERE [Id] = @Id";
SqlParameter s1 = new SqlParameter("@Id", model.AssetsId);
SqlParameter s2 = new SqlParameter("@StatusId", model.OldStatusId);
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2 };
dicCmd.Add(cmdPara, sqlText);
}
else
{
string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_Assets]
SET [StatusId] = @StatusId
WHERE [Id] = @Id";
SqlParameter s1 = new SqlParameter("@Id", model.AssetsId);
SqlParameter s2 = new SqlParameter("@StatusId", "WX");
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2 };
dicCmd.Add(cmdPara, sqlText);
}
}
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_RepairOrder model)
{
return(sev.Modify(new List <Models.ys_RepairOrder> {
model
}));
}
