protected override void Loading() { if (UserStatics.OptrType == "Test") { ctModeNo.Enabled = false; ctProductType.Enabled = false; } ctProductType.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "适应产品"); ctProductType.DisplayMember = "Name"; ctWhoUninstalled.DataSource = BllTechnologicalEquipment.GetWhoRepairByWorkShop(UserStatics.OptrType, UserStatics.WorkShop); ctWhoUninstalled.DisplayMember = "Name"; ctTeHandle.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "工装处理"); ctTeHandle.DisplayMember = "Name"; ctSupplier.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "供应商"); ctSupplier.DisplayMember = "Name"; var obj = TechnologicalEquipment.FindById(long.Parse(ItemID)); FrmAddEditBindComboBoxText.BindObjectToControls(obj, tabPage1); ctUninstallDate.Value = UserStatics.GetSqlServerDateTime(); OwnTE = ctTeNo.Text; OwnWhoInstalled = ctWhoInstalled.Text; }
protected override void Saving() { //将原先的工装,改为报废,并保存时.保存一份旧档. //a.窗口打开时,读取工装编号和安装人,放在窗体变量。先保存旧档。 //b.新建一个新档,初始化后保存 //不为报废,保存时,保存动作不变 if (ctTeHandle.Text == "报废") { var obj = TechnologicalEquipment.FindById(long.Parse(ItemID)); FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1); obj.OptrType = UserStatics.OptrType; obj.TeNo = OwnTE; obj.WhoInstalled = OwnWhoInstalled; obj.Save(); var obj2 = TechnologicalEquipment.New; FrmAddEditBindComboBoxText.BindControlsToObject(obj2, tabPage1); obj2.OptrType = UserStatics.OptrType; obj2.InstallDate = DateTime.Now; obj2.UninstallDate = Convert.ToDateTime("1900-01-01 00:00:00"); obj2.UninstallReason = ""; obj2.WhoUninstalled = ""; obj2.UseCount = 0; obj2.TechnologicalEquipmentStatus = 0; obj2.TeHandle = "在用"; obj2.Save(); } else { var obj = TechnologicalEquipment.FindById(long.Parse(ItemID)); FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1); obj.OptrType = UserStatics.OptrType; obj.Save(); } }
public static DataTable GetNoUseTable(string optrType) { var dt = TechnologicalEquipment.Find(CK.K["OptrType"] == optrType && CK.K["TeHandle"] == "报废", "EquipmentNo").ToDataTable(); dt.Columns[1].ColumnName = "机台号"; dt.Columns[2].ColumnName = "模具号"; dt.Columns[3].ColumnName = "工装编号"; dt.Columns[4].ColumnName = "产品类型"; dt.Columns[5].ColumnName = "工装类型"; dt.Columns[6].ColumnName = "工装状态"; dt.Columns[7].ColumnName = "安装日期"; dt.Columns[8].ColumnName = "安装者"; dt.Columns[9].ColumnName = "原始寿命"; dt.Columns[10].ColumnName = "寿命下限"; dt.Columns[11].ColumnName = "寿命上限"; dt.Columns[12].ColumnName = "拆卸日期"; dt.Columns[13].ColumnName = "使用寿命"; dt.Columns[14].ColumnName = "拆卸原因"; dt.Columns[15].ColumnName = "拆卸者"; dt.Columns[16].ColumnName = "工装处理"; dt.Columns[17].ColumnName = "供应商"; dt.Columns[18].ColumnName = "备注"; dt.Columns[19].ColumnName = "用户类型"; dt.Columns[20].ColumnName = "保存日期"; return(dt); }
protected override void Saving() { ////如果使用寿命 != 0 并且 工装处理 = 备用,则原始寿命= 原始寿命+使用寿命 //if (ctUseCount.Value != 0 && (ctTeHandle.Text == "备用" || ctTeHandle.Text == "报废")) //{ // var obj = TechnologicalEquipment.FindById(long.Parse(ItemID)); // FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1); // obj.OptrType = UserStatics.OptrType; // obj.ElderCount = obj.UseCount + obj.ElderCount; // obj.UseCount = 0; // obj.Save(); //} //else //{ //工装状态+1 ctTechnologicalEquipmentStatus.Value = ctTechnologicalEquipmentStatus.Value + 1; ctUseCount.Value = 0; //原始寿命必须清零 ctElderCount.Value = 0; var obj = TechnologicalEquipment.FindById(long.Parse(ItemID)); FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1); obj.OptrType = UserStatics.OptrType; obj.Save(); //} }
protected override void Loading() { var obj = TechnologicalEquipment.FindById(long.Parse(ItemID)); FrmAddEditBindComboBoxText.BindObjectToControls(obj, tabPage1); ctUseCount.Value = BllTechnologicalEquipment.GetUseAmount(long.Parse(ItemID)); ctUninstallDate.Value = UserStatics.GetSqlServerDateTime(); }
protected override void Saving() { if (!IsAdd) { var obj = TechnologicalEquipment.FindById(long.Parse(ItemID)); FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1); obj.OptrType = UserStatics.OptrType; obj.TeHandle = "在用"; obj.Save(); } }
public static void DelCell(long id) { TechnologicalEquipment.DeleteAll(CK.K["Id"] == id); }