/// <summary>
/// 由设备进行初始化
/// </summary>
/// <param name="_Equipment"></param>
public frm_Equipment_Maintenance(Maticsoft.Model.EquipmentInfo _Equipment)
{
InitializeComponent();
this._Equipment = _Equipment;
cmb_ResultCode.ItemsSource = MCP_CS._M_Equipment_TypeList.GetStringList("Type = 'Ma_验收结果'");
Maintain.Ass_Num = _Equipment.AssetNum;
Maintain.Ass_Name = _Equipment.AssetName;
Maintain.Ass_MakeNum = _Equipment.MakeNum;
Maintain.Ass_Type = _Equipment.AssetType;
Maintain.Apply_Date = DateTime.Now.ToString();
grd_Maintain.DataContext = Maintain;
}
//
//验收
//
private void btn_Check_Click(object sender, RoutedEventArgs e)
{
_Equipment = MCP_CS._M_Equipment.GetModel(Maintain.Ass_Num);
_Equipment.State = "使用中";
Maintain.Check_Date = DateTime.Now.ToString();
if (MCP_CS.Enquipment_Maintain.Update(Maintain))
{
MCP_CS._M_Equipment.Update(_Equipment);
My_MessageBox.My_MessageBox_Message("提交成功！\r\n本次维修完成！");
}
else
{
My_MessageBox.My_MessageBox_Message("提交失败！");
}
grd_Maintain.DataContext = Maintain; //更新数据源在窗体的显示
}
/// <summary>
/// 获取一台设备 用于新增
/// </summary>
/// <returns></returns>
private Maticsoft.Model.EquipmentInfo Get_Equipment_for_Control()
{
Maticsoft.Model.EquipmentInfo _TemEquipment = new Maticsoft.Model.EquipmentInfo()
{
AssetType = cmb_AssetType.Text.Trim(),
Department = cmb_Department.Text.Trim(),
InstallationSite = cmb_InstallationSite.Text.Trim(),
AddMode = cmb_AddMode.Text.Trim(),
VerifyDate = dtp_VerigyDate.DisplayDate,
VerifyInterval = txb_VerifyInterval.Text.Trim(),
MaintenanceDate = dtp_MaintenanceDate.DisplayDate,
MaintenanceInterval = txb_MaintenanceInterval.Text.Trim(),
LoginDate = dtp_LoginDate.DisplayDate,
UsefulLife = txb_UsefulLife.Text.Trim(),
DeliveryUser = txb_DeliveryUser.Text.Trim(),
CheckUser = txb_CheckUser.Text.Trim(),
CareUser = txb_CareUser.Text.Trim(),
//
AssetNum = txb_AssetNum.Text.Trim(),
AssetName = txb_AssetName.Text.Trim(),
AliasName = txb_AliasName.Text.Trim(),
MakeNum = txb_MakeNum.Text.Trim(),
State = cmb_State.Text.Trim(),
Count = txb_Count.Text.Trim(),
Unit = cmb_Unit.Text.Trim(),
Efficiency = txb_Efficiency.Text.Trim(),
EquipentOEE = txb_EquipmentOee.Text.Trim(),
//
EquipentModel = txb_EquipmentModel.Text.Trim(),
Specification = txb_EquipmentSpecification.Text.Trim(),
FunctionDescription = txb_FunctionDescription.Text.Trim(),
//
Supplier = txb_Supplier.Text.Trim(),
ManufacturingDate = dtp_ManufacturingDate.DisplayDate,
OfficialWedsite = txb_OfficialWedsite.Text.Trim(),
AferSaleTel = txb_AferSaleTel.Text.Trim(),
PhotoPatch = txb_PhotoPatch.Text.Trim(),
SafetySpecification = txb_SafetySpecification.Text.Trim(),
OI = txb_OI.Text.Trim(),
ChechSheet = txb_ChechSheet.Text.Trim()
};
return(_TemEquipment);
}
/// <summary>
/// 获取一台设备 用于更新
/// </summary>
/// <param name="_Euipment"></param>
/// <returns></returns>
private Maticsoft.Model.EquipmentInfo Get_Equipment_for_Control(Maticsoft.Model.EquipmentInfo _Euipment)
{
_Euipment.AssetType = cmb_AssetType.Text.Trim();
_Euipment.Department = cmb_Department.Text.Trim();
_Euipment.InstallationSite = cmb_InstallationSite.Text.Trim();
_Euipment.AddMode = cmb_AddMode.Text.Trim();
_Euipment.VerifyDate = dtp_VerigyDate.DisplayDate;
_Euipment.VerifyInterval = txb_VerifyInterval.Text.Trim();
_Euipment.MaintenanceDate = dtp_MaintenanceDate.DisplayDate;
_Euipment.MaintenanceInterval = txb_MaintenanceInterval.Text.Trim();
_Euipment.LoginDate = dtp_LoginDate.DisplayDate;
_Euipment.UsefulLife = txb_UsefulLife.Text.Trim();
_Euipment.DeliveryUser = txb_DeliveryUser.Text.Trim();
_Euipment.CheckUser = txb_CheckUser.Text.Trim();
_Euipment.CareUser = txb_CareUser.Text.Trim();
//
_Euipment.AssetNum = txb_AssetNum.Text.Trim();
_Euipment.AssetName = txb_AssetName.Text.Trim();
_Euipment.AliasName = txb_AliasName.Text.Trim();
_Euipment.MakeNum = txb_MakeNum.Text.Trim();
_Euipment.State = cmb_State.Text.Trim();
_Euipment.Count = txb_Count.Text.Trim();
_Euipment.Unit = cmb_Unit.Text.Trim();
_Euipment.Efficiency = txb_Efficiency.Text.Trim();
_Euipment.EquipentOEE = txb_EquipmentOee.Text.Trim();
//
_Euipment.EquipentModel = txb_EquipmentModel.Text.Trim();
_Euipment.Specification = txb_EquipmentSpecification.Text.Trim();
_Euipment.FunctionDescription = txb_FunctionDescription.Text.Trim();
//
_Euipment.Supplier = txb_Supplier.Text.Trim();
_Euipment.ManufacturingDate = dtp_ManufacturingDate.DisplayDate;
_Euipment.OfficialWedsite = txb_OfficialWedsite.Text.Trim();
_Euipment.AferSaleTel = txb_AferSaleTel.Text.Trim();
_Euipment.PhotoPatch = txb_PhotoPatch.Text.Trim();
_Euipment.SafetySpecification = txb_SafetySpecification.Text.Trim();
_Euipment.OI = txb_OI.Text.Trim();
_Euipment.ChechSheet = txb_ChechSheet.Text;
return(_Euipment);
}
//
//保存更改
//
private void btn_Save_Click(object sender, RoutedEventArgs e)
{
if (txb_AssetNum.Text != "")
{
if (MCP_CS._M_Equipment.Exists(Equipment.Eqp_ID)) //判断记录是否存在
{
Equipment = Get_Equipment_for_Control(Equipment);
if (MCP_CS._M_Equipment.Update(Equipment)) //存在则更新记录
{
My_MessageBox.My_MessageBox_Message("更新成功！");
btn_Edit.IsEnabled = true;
btn_Save.IsEnabled = false;
IsEn_Control(false);
}
else
{
My_MessageBox.My_MessageBox_Message("未更新！\r\n更新设备时失败，请确认信息是否完整！");
}
}
else //不存在则添加记录
{
Equipment = Get_Equipment_for_Control();
if (MCP_CS._M_Equipment.Add(Equipment) > 0)
{
My_MessageBox.My_MessageBox_Message("添加成功！");
btn_Edit.IsEnabled = true;
btn_Save.IsEnabled = false;
IsEn_Control(false);
}
else
{
My_MessageBox.My_MessageBox_Message("未添加！\r\n添加设备时失败，请确认信息是否完整！");
}
}
}
else
{
My_MessageBox.My_MessageBox_Message("未添加！\r\n添加设备时失败，请确认信息是否完整！");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.EquipmentInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_EquipmentInfo(");
strSql.Append("AssetType,Department,InstallationSite,AddMode,VerifyDate,VerifyInterval,MaintenanceDate,MaintenanceInterval,LoginDate,UsefulLife,DeliveryUser,CheckUser,CareUser,AssetNum,AssetName,AliasName,MakeNum,EquipentModel,Specification,FunctionDescription,Supplier,ManufacturingDate,OfficialWedsite,SupplierTel,AferSaleTel,State,Count,Unit,Efficiency,EquipentOEE,PhotoPatch,SafetySpecification,OI,ChechSheet)");
strSql.Append(" values (");
strSql.Append("@AssetType,@Department,@InstallationSite,@AddMode,@VerifyDate,@VerifyInterval,@MaintenanceDate,@MaintenanceInterval,@LoginDate,@UsefulLife,@DeliveryUser,@CheckUser,@CareUser,@AssetNum,@AssetName,@AliasName,@MakeNum,@EquipentModel,@Specification,@FunctionDescription,@Supplier,@ManufacturingDate,@OfficialWedsite,@SupplierTel,@AferSaleTel,@State,@Count,@Unit,@Efficiency,@EquipentOEE,@PhotoPatch,@SafetySpecification,@OI,@ChechSheet)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AssetType", SqlDbType.VarChar, 50),
new SqlParameter("@Department", SqlDbType.VarChar, 50),
new SqlParameter("@InstallationSite", SqlDbType.VarChar, 50),
new SqlParameter("@AddMode", SqlDbType.VarChar, 50),
new SqlParameter("@VerifyDate", SqlDbType.DateTime),
new SqlParameter("@VerifyInterval", SqlDbType.VarChar, 50),
new SqlParameter("@MaintenanceDate", SqlDbType.DateTime),
new SqlParameter("@MaintenanceInterval", SqlDbType.VarChar, 50),
new SqlParameter("@LoginDate", SqlDbType.DateTime),
new SqlParameter("@UsefulLife", SqlDbType.VarChar, 50),
new SqlParameter("@DeliveryUser", SqlDbType.VarChar, 50),
new SqlParameter("@CheckUser", SqlDbType.VarChar, 50),
new SqlParameter("@CareUser", SqlDbType.VarChar, 50),
new SqlParameter("@AssetNum", SqlDbType.VarChar, 50),
new SqlParameter("@AssetName", SqlDbType.VarChar, 50),
new SqlParameter("@AliasName", SqlDbType.VarChar, 50),
new SqlParameter("@MakeNum", SqlDbType.VarChar, 50),
new SqlParameter("@EquipentModel", SqlDbType.VarChar, 255),
new SqlParameter("@Specification", SqlDbType.VarChar, 255),
new SqlParameter("@FunctionDescription", SqlDbType.VarChar, 255),
new SqlParameter("@Supplier", SqlDbType.VarChar, 50),
new SqlParameter("@ManufacturingDate", SqlDbType.DateTime),
new SqlParameter("@OfficialWedsite", SqlDbType.VarChar, 100),
new SqlParameter("@SupplierTel", SqlDbType.VarChar, 100),
new SqlParameter("@AferSaleTel", SqlDbType.VarChar, 100),
new SqlParameter("@State", SqlDbType.VarChar, 50),
new SqlParameter("@Count", SqlDbType.VarChar, 50),
new SqlParameter("@Unit", SqlDbType.VarChar, 50),
new SqlParameter("@Efficiency", SqlDbType.VarChar, 50),
new SqlParameter("@EquipentOEE", SqlDbType.VarChar, 50),
new SqlParameter("@PhotoPatch", SqlDbType.VarChar, 100),
new SqlParameter("@SafetySpecification", SqlDbType.VarChar, 100),
new SqlParameter("@OI", SqlDbType.VarChar, 100),
new SqlParameter("@ChechSheet", SqlDbType.VarChar, 100)
};
parameters[0].Value = model.AssetType;
parameters[1].Value = model.Department;
parameters[2].Value = model.InstallationSite;
parameters[3].Value = model.AddMode;
parameters[4].Value = model.VerifyDate;
parameters[5].Value = model.VerifyInterval;
parameters[6].Value = model.MaintenanceDate;
parameters[7].Value = model.MaintenanceInterval;
parameters[8].Value = model.LoginDate;
parameters[9].Value = model.UsefulLife;
parameters[10].Value = model.DeliveryUser;
parameters[11].Value = model.CheckUser;
parameters[12].Value = model.CareUser;
parameters[13].Value = model.AssetNum;
parameters[14].Value = model.AssetName;
parameters[15].Value = model.AliasName;
parameters[16].Value = model.MakeNum;
parameters[17].Value = model.EquipentModel;
parameters[18].Value = model.Specification;
parameters[19].Value = model.FunctionDescription;
parameters[20].Value = model.Supplier;
parameters[21].Value = model.ManufacturingDate;
parameters[22].Value = model.OfficialWedsite;
parameters[23].Value = model.SupplierTel;
parameters[24].Value = model.AferSaleTel;
parameters[25].Value = model.State;
parameters[26].Value = model.Count;
parameters[27].Value = model.Unit;
parameters[28].Value = model.Efficiency;
parameters[29].Value = model.EquipentOEE;
parameters[30].Value = model.PhotoPatch;
parameters[31].Value = model.SafetySpecification;
parameters[32].Value = model.OI;
parameters[33].Value = model.ChechSheet;
object obj = dbs.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.EquipmentInfo GetModel(decimal Eqp_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Eqp_ID,AssetType,Department,InstallationSite,AddMode,VerifyDate,VerifyInterval,MaintenanceDate,MaintenanceInterval,LoginDate,UsefulLife,DeliveryUser,CheckUser,CareUser,AssetNum,AssetName,AliasName,MakeNum,EquipentModel,Specification,FunctionDescription,Supplier,ManufacturingDate,OfficialWedsite,SupplierTel,AferSaleTel,State,Count,Unit,Efficiency,EquipentOEE,PhotoPatch,SafetySpecification,OI,ChechSheet from tb_EquipmentInfo ");
strSql.Append(" where Eqp_ID=@Eqp_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Eqp_ID", SqlDbType.Decimal)
};
parameters[0].Value = Eqp_ID;
Maticsoft.Model.EquipmentInfo model = new Maticsoft.Model.EquipmentInfo();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Eqp_ID"] != null && ds.Tables[0].Rows[0]["Eqp_ID"].ToString() != "")
{
model.Eqp_ID = decimal.Parse(ds.Tables[0].Rows[0]["Eqp_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["AssetType"] != null && ds.Tables[0].Rows[0]["AssetType"].ToString() != "")
{
model.AssetType = ds.Tables[0].Rows[0]["AssetType"].ToString();
}
if (ds.Tables[0].Rows[0]["Department"] != null && ds.Tables[0].Rows[0]["Department"].ToString() != "")
{
model.Department = ds.Tables[0].Rows[0]["Department"].ToString();
}
if (ds.Tables[0].Rows[0]["InstallationSite"] != null && ds.Tables[0].Rows[0]["InstallationSite"].ToString() != "")
{
model.InstallationSite = ds.Tables[0].Rows[0]["InstallationSite"].ToString();
}
if (ds.Tables[0].Rows[0]["AddMode"] != null && ds.Tables[0].Rows[0]["AddMode"].ToString() != "")
{
model.AddMode = ds.Tables[0].Rows[0]["AddMode"].ToString();
}
if (ds.Tables[0].Rows[0]["VerifyDate"] != null && ds.Tables[0].Rows[0]["VerifyDate"].ToString() != "")
{
model.VerifyDate = DateTime.Parse(ds.Tables[0].Rows[0]["VerifyDate"].ToString());
}
if (ds.Tables[0].Rows[0]["VerifyInterval"] != null && ds.Tables[0].Rows[0]["VerifyInterval"].ToString() != "")
{
model.VerifyInterval = ds.Tables[0].Rows[0]["VerifyInterval"].ToString();
}
if (ds.Tables[0].Rows[0]["MaintenanceDate"] != null && ds.Tables[0].Rows[0]["MaintenanceDate"].ToString() != "")
{
model.MaintenanceDate = DateTime.Parse(ds.Tables[0].Rows[0]["MaintenanceDate"].ToString());
}
if (ds.Tables[0].Rows[0]["MaintenanceInterval"] != null && ds.Tables[0].Rows[0]["MaintenanceInterval"].ToString() != "")
{
model.MaintenanceInterval = ds.Tables[0].Rows[0]["MaintenanceInterval"].ToString();
}
if (ds.Tables[0].Rows[0]["LoginDate"] != null && ds.Tables[0].Rows[0]["LoginDate"].ToString() != "")
{
model.LoginDate = DateTime.Parse(ds.Tables[0].Rows[0]["LoginDate"].ToString());
}
if (ds.Tables[0].Rows[0]["UsefulLife"] != null && ds.Tables[0].Rows[0]["UsefulLife"].ToString() != "")
{
model.UsefulLife = ds.Tables[0].Rows[0]["UsefulLife"].ToString();
}
if (ds.Tables[0].Rows[0]["DeliveryUser"] != null && ds.Tables[0].Rows[0]["DeliveryUser"].ToString() != "")
{
model.DeliveryUser = ds.Tables[0].Rows[0]["DeliveryUser"].ToString();
}
if (ds.Tables[0].Rows[0]["CheckUser"] != null && ds.Tables[0].Rows[0]["CheckUser"].ToString() != "")
{
model.CheckUser = ds.Tables[0].Rows[0]["CheckUser"].ToString();
}
if (ds.Tables[0].Rows[0]["CareUser"] != null && ds.Tables[0].Rows[0]["CareUser"].ToString() != "")
{
model.CareUser = ds.Tables[0].Rows[0]["CareUser"].ToString();
}
if (ds.Tables[0].Rows[0]["AssetNum"] != null && ds.Tables[0].Rows[0]["AssetNum"].ToString() != "")
{
model.AssetNum = ds.Tables[0].Rows[0]["AssetNum"].ToString();
}
if (ds.Tables[0].Rows[0]["AssetName"] != null && ds.Tables[0].Rows[0]["AssetName"].ToString() != "")
{
model.AssetName = ds.Tables[0].Rows[0]["AssetName"].ToString();
}
if (ds.Tables[0].Rows[0]["AliasName"] != null && ds.Tables[0].Rows[0]["AliasName"].ToString() != "")
{
model.AliasName = ds.Tables[0].Rows[0]["AliasName"].ToString();
}
if (ds.Tables[0].Rows[0]["MakeNum"] != null && ds.Tables[0].Rows[0]["MakeNum"].ToString() != "")
{
model.MakeNum = ds.Tables[0].Rows[0]["MakeNum"].ToString();
}
if (ds.Tables[0].Rows[0]["EquipentModel"] != null && ds.Tables[0].Rows[0]["EquipentModel"].ToString() != "")
{
model.EquipentModel = ds.Tables[0].Rows[0]["EquipentModel"].ToString();
}
if (ds.Tables[0].Rows[0]["Specification"] != null && ds.Tables[0].Rows[0]["Specification"].ToString() != "")
{
model.Specification = ds.Tables[0].Rows[0]["Specification"].ToString();
}
if (ds.Tables[0].Rows[0]["FunctionDescription"] != null && ds.Tables[0].Rows[0]["FunctionDescription"].ToString() != "")
{
model.FunctionDescription = ds.Tables[0].Rows[0]["FunctionDescription"].ToString();
}
if (ds.Tables[0].Rows[0]["Supplier"] != null && ds.Tables[0].Rows[0]["Supplier"].ToString() != "")
{
model.Supplier = ds.Tables[0].Rows[0]["Supplier"].ToString();
}
if (ds.Tables[0].Rows[0]["ManufacturingDate"] != null && ds.Tables[0].Rows[0]["ManufacturingDate"].ToString() != "")
{
model.ManufacturingDate = DateTime.Parse(ds.Tables[0].Rows[0]["ManufacturingDate"].ToString());
}
if (ds.Tables[0].Rows[0]["OfficialWedsite"] != null && ds.Tables[0].Rows[0]["OfficialWedsite"].ToString() != "")
{
model.OfficialWedsite = ds.Tables[0].Rows[0]["OfficialWedsite"].ToString();
}
if (ds.Tables[0].Rows[0]["SupplierTel"] != null && ds.Tables[0].Rows[0]["SupplierTel"].ToString() != "")
{
model.SupplierTel = ds.Tables[0].Rows[0]["SupplierTel"].ToString();
}
if (ds.Tables[0].Rows[0]["AferSaleTel"] != null && ds.Tables[0].Rows[0]["AferSaleTel"].ToString() != "")
{
model.AferSaleTel = ds.Tables[0].Rows[0]["AferSaleTel"].ToString();
}
if (ds.Tables[0].Rows[0]["State"] != null && ds.Tables[0].Rows[0]["State"].ToString() != "")
{
model.State = ds.Tables[0].Rows[0]["State"].ToString();
}
if (ds.Tables[0].Rows[0]["Count"] != null && ds.Tables[0].Rows[0]["Count"].ToString() != "")
{
model.Count = ds.Tables[0].Rows[0]["Count"].ToString();
}
if (ds.Tables[0].Rows[0]["Unit"] != null && ds.Tables[0].Rows[0]["Unit"].ToString() != "")
{
model.Unit = ds.Tables[0].Rows[0]["Unit"].ToString();
}
if (ds.Tables[0].Rows[0]["Efficiency"] != null && ds.Tables[0].Rows[0]["Efficiency"].ToString() != "")
{
model.Efficiency = ds.Tables[0].Rows[0]["Efficiency"].ToString();
}
if (ds.Tables[0].Rows[0]["EquipentOEE"] != null && ds.Tables[0].Rows[0]["EquipentOEE"].ToString() != "")
{
model.EquipentOEE = ds.Tables[0].Rows[0]["EquipentOEE"].ToString();
}
if (ds.Tables[0].Rows[0]["PhotoPatch"] != null && ds.Tables[0].Rows[0]["PhotoPatch"].ToString() != "")
{
model.PhotoPatch = ds.Tables[0].Rows[0]["PhotoPatch"].ToString();
}
if (ds.Tables[0].Rows[0]["SafetySpecification"] != null && ds.Tables[0].Rows[0]["SafetySpecification"].ToString() != "")
{
model.SafetySpecification = ds.Tables[0].Rows[0]["SafetySpecification"].ToString();
}
if (ds.Tables[0].Rows[0]["OI"] != null && ds.Tables[0].Rows[0]["OI"].ToString() != "")
{
model.OI = ds.Tables[0].Rows[0]["OI"].ToString();
}
if (ds.Tables[0].Rows[0]["ChechSheet"] != null && ds.Tables[0].Rows[0]["ChechSheet"].ToString() != "")
{
model.ChechSheet = ds.Tables[0].Rows[0]["ChechSheet"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.EquipmentInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_EquipmentInfo set ");
strSql.Append("AssetType=@AssetType,");
strSql.Append("Department=@Department,");
strSql.Append("InstallationSite=@InstallationSite,");
strSql.Append("AddMode=@AddMode,");
strSql.Append("VerifyDate=@VerifyDate,");
strSql.Append("VerifyInterval=@VerifyInterval,");
strSql.Append("MaintenanceDate=@MaintenanceDate,");
strSql.Append("MaintenanceInterval=@MaintenanceInterval,");
strSql.Append("LoginDate=@LoginDate,");
strSql.Append("UsefulLife=@UsefulLife,");
strSql.Append("DeliveryUser=@DeliveryUser,");
strSql.Append("CheckUser=@CheckUser,");
strSql.Append("CareUser=@CareUser,");
strSql.Append("AssetNum=@AssetNum,");
strSql.Append("AssetName=@AssetName,");
strSql.Append("AliasName=@AliasName,");
strSql.Append("MakeNum=@MakeNum,");
strSql.Append("EquipentModel=@EquipentModel,");
strSql.Append("Specification=@Specification,");
strSql.Append("FunctionDescription=@FunctionDescription,");
strSql.Append("Supplier=@Supplier,");
strSql.Append("ManufacturingDate=@ManufacturingDate,");
strSql.Append("OfficialWedsite=@OfficialWedsite,");
strSql.Append("SupplierTel=@SupplierTel,");
strSql.Append("AferSaleTel=@AferSaleTel,");
strSql.Append("State=@State,");
strSql.Append("Count=@Count,");
strSql.Append("Unit=@Unit,");
strSql.Append("Efficiency=@Efficiency,");
strSql.Append("EquipentOEE=@EquipentOEE,");
strSql.Append("PhotoPatch=@PhotoPatch,");
strSql.Append("SafetySpecification=@SafetySpecification,");
strSql.Append("OI=@OI,");
strSql.Append("ChechSheet=@ChechSheet");
strSql.Append(" where Eqp_ID=@Eqp_ID");
SqlParameter[] parameters =
{
new SqlParameter("@AssetType", SqlDbType.VarChar, 50),
new SqlParameter("@Department", SqlDbType.VarChar, 50),
new SqlParameter("@InstallationSite", SqlDbType.VarChar, 50),
new SqlParameter("@AddMode", SqlDbType.VarChar, 50),
new SqlParameter("@VerifyDate", SqlDbType.DateTime),
new SqlParameter("@VerifyInterval", SqlDbType.VarChar, 50),
new SqlParameter("@MaintenanceDate", SqlDbType.DateTime),
new SqlParameter("@MaintenanceInterval", SqlDbType.VarChar, 50),
new SqlParameter("@LoginDate", SqlDbType.DateTime),
new SqlParameter("@UsefulLife", SqlDbType.VarChar, 50),
new SqlParameter("@DeliveryUser", SqlDbType.VarChar, 50),
new SqlParameter("@CheckUser", SqlDbType.VarChar, 50),
new SqlParameter("@CareUser", SqlDbType.VarChar, 50),
new SqlParameter("@AssetNum", SqlDbType.VarChar, 50),
new SqlParameter("@AssetName", SqlDbType.VarChar, 50),
new SqlParameter("@AliasName", SqlDbType.VarChar, 50),
new SqlParameter("@MakeNum", SqlDbType.VarChar, 50),
new SqlParameter("@EquipentModel", SqlDbType.VarChar, 255),
new SqlParameter("@Specification", SqlDbType.VarChar, 255),
new SqlParameter("@FunctionDescription", SqlDbType.VarChar, 255),
new SqlParameter("@Supplier", SqlDbType.VarChar, 50),
new SqlParameter("@ManufacturingDate", SqlDbType.DateTime),
new SqlParameter("@OfficialWedsite", SqlDbType.VarChar, 100),
new SqlParameter("@SupplierTel", SqlDbType.VarChar, 100),
new SqlParameter("@AferSaleTel", SqlDbType.VarChar, 100),
new SqlParameter("@State", SqlDbType.VarChar, 50),
new SqlParameter("@Count", SqlDbType.VarChar, 50),
new SqlParameter("@Unit", SqlDbType.VarChar, 50),
new SqlParameter("@Efficiency", SqlDbType.VarChar, 50),
new SqlParameter("@EquipentOEE", SqlDbType.VarChar, 50),
new SqlParameter("@PhotoPatch", SqlDbType.VarChar, 100),
new SqlParameter("@SafetySpecification", SqlDbType.VarChar, 100),
new SqlParameter("@OI", SqlDbType.VarChar, 100),
new SqlParameter("@ChechSheet", SqlDbType.VarChar, 100),
new SqlParameter("@Eqp_ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.AssetType;
parameters[1].Value = model.Department;
parameters[2].Value = model.InstallationSite;
parameters[3].Value = model.AddMode;
parameters[4].Value = model.VerifyDate;
parameters[5].Value = model.VerifyInterval;
parameters[6].Value = model.MaintenanceDate;
parameters[7].Value = model.MaintenanceInterval;
parameters[8].Value = model.LoginDate;
parameters[9].Value = model.UsefulLife;
parameters[10].Value = model.DeliveryUser;
parameters[11].Value = model.CheckUser;
parameters[12].Value = model.CareUser;
parameters[13].Value = model.AssetNum;
parameters[14].Value = model.AssetName;
parameters[15].Value = model.AliasName;
parameters[16].Value = model.MakeNum;
parameters[17].Value = model.EquipentModel;
parameters[18].Value = model.Specification;
parameters[19].Value = model.FunctionDescription;
parameters[20].Value = model.Supplier;
parameters[21].Value = model.ManufacturingDate;
parameters[22].Value = model.OfficialWedsite;
parameters[23].Value = model.SupplierTel;
parameters[24].Value = model.AferSaleTel;
parameters[25].Value = model.State;
parameters[26].Value = model.Count;
parameters[27].Value = model.Unit;
parameters[28].Value = model.Efficiency;
parameters[29].Value = model.EquipentOEE;
parameters[30].Value = model.PhotoPatch;
parameters[31].Value = model.SafetySpecification;
parameters[32].Value = model.OI;
parameters[33].Value = model.ChechSheet;
parameters[34].Value = model.Eqp_ID;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 显示设备信息
/// </summary>
/// <param name="_Equipment"></param>
/// <returns></returns>
private bool ShowEquipmentInfo(Maticsoft.Model.EquipmentInfo _Equipment)
{
if (_Equipment.AssetNum != null)
{
cmb_AssetType.Text = _Equipment.AssetType;
cmb_Department.Text = _Equipment.Department;
cmb_InstallationSite.Text = _Equipment.InstallationSite;
cmb_AddMode.Text = _Equipment.AddMode;
if (_Equipment.VerifyDate != null)
{
dtp_VerigyDate.DisplayDate = (DateTime)_Equipment.VerifyDate;
}
txb_VerifyInterval.Text = _Equipment.VerifyInterval;
if (_Equipment.MaintenanceDate != null)
{
dtp_MaintenanceDate.DisplayDate = (DateTime)_Equipment.MaintenanceDate;
}
txb_MaintenanceInterval.Text = _Equipment.MaintenanceInterval;
if (_Equipment.LoginDate != null)
{
dtp_LoginDate.DisplayDate = (DateTime)_Equipment.LoginDate;
}
txb_UsefulLife.Text = _Equipment.UsefulLife;
txb_DeliveryUser.Text = _Equipment.DeliveryUser;
txb_CheckUser.Text = _Equipment.CheckUser;
txb_CareUser.Text = _Equipment.CareUser;
//
txb_AssetNum.Text = _Equipment.AssetNum;
txb_AssetName.Text = _Equipment.AssetName;
txb_AliasName.Text = _Equipment.AliasName;
txb_MakeNum.Text = _Equipment.MakeNum;
cmb_State.Text = _Equipment.State;
txb_Count.Text = _Equipment.Count;
cmb_Unit.Text = _Equipment.Unit;
txb_Efficiency.Text = _Equipment.Efficiency;
txb_EquipmentOee.Text = _Equipment.EquipentOEE;
//
txb_EquipmentModel.Text = _Equipment.EquipentModel;
txb_EquipmentSpecification.Text = _Equipment.Specification;
txb_FunctionDescription.Text = _Equipment.FunctionDescription;
//
txb_Supplier.Text = _Equipment.Supplier;
if (_Equipment.ManufacturingDate != null)
{
dtp_ManufacturingDate.DisplayDate = (DateTime)_Equipment.ManufacturingDate;
}
txb_OfficialWedsite.Text = _Equipment.OfficialWedsite;
txb_AferSaleTel.Text = _Equipment.AferSaleTel;
txb_PhotoPatch.Text = _Equipment.PhotoPatch;
txb_SafetySpecification.Text = _Equipment.SafetySpecification;
txb_OI.Text = _Equipment.OI;
txb_ChechSheet.Text = _Equipment.ChechSheet;
dgv_Maintain.ItemsSource = MCP_CS.Enquipment_Maintain.GetModelList("Ass_Num = '" + _Equipment.AssetNum + "'");
return(true);
}
else
{
btn_Edit.IsEnabled = false;
return(false);
}
}
