private bool CheckMaterialCustomField(DataTable Exceldt, string ColName, int MaterialId, string CustomFieldValue) { CommonCodeMgr common = new CommonCodeMgr(); CustomFieldMgr customFieldMgr = new CustomFieldMgr(); MaterialMgr materialMgr = new MaterialMgr(); MaterialCustomFieldMgr materialCustomFieldMgr = new MaterialCustomFieldMgr(); TypeCustomField customField = new TypeCustomField(); TypeMaterialCustomField materialCustomField = new TypeMaterialCustomField(); SigmaResultType mResult = new SigmaResultType(); SigmaResultType cResult = new SigmaResultType(); DataSet CustomFiledSD = materialCustomFieldMgr.ListMaterialCustomFieldByFieldName(ColName); if (CustomFiledSD.Tables[0].Rows.Count > 0) // CustomField Table 동일 FieldName이 있으면 MaterialCustomField Table 입력 { DataRow CustomFiledSR = CustomFiledSD.Tables[0].Rows[0]; materialCustomField.MaterialId = MaterialId; materialCustomField.CustomFieldId = Convert.ToInt32(CustomFiledSR["CustomFieldId"].ToString()); materialCustomField.Value = CustomFieldValue; materialCustomField.CreatedBy = userinfo.SigmaUserId; mResult = materialMgr.AddMaterialCustomField(materialCustomField); } else // CustomField Table & MaterialCustomField Table 에 입력 { customField.FieldName = ColName; customField.IsDisplayable = "Y"; customField.CreatedBy = userinfo.SigmaUserId; cResult = customFieldMgr.AddCustomField(customField); if (cResult.IsSuccessful) { materialCustomField.MaterialId = MaterialId; materialCustomField.CustomFieldId = cResult.ScalarValue; materialCustomField.Value = CustomFieldValue; materialCustomField.CreatedBy = userinfo.SigmaUserId; mResult = materialMgr.AddMaterialCustomField(materialCustomField); } } return mResult.IsSuccessful; }
private bool CheckEquipmentCustomField(DataTable Exceldt, string ColName, int EquipmentId, string CustomFieldValue) { CommonCodeMgr common = new CommonCodeMgr(); CustomFieldMgr customFieldMgr = new CustomFieldMgr(); EquipmentMgr equipmentMgr = new EquipmentMgr(); MaterialCustomFieldMgr materialCustomFieldMgr = new MaterialCustomFieldMgr(); TypeCustomField customField = new TypeCustomField(); TypeEquipmentCustomField equipmentCustomField = new TypeEquipmentCustomField(); SigmaResultType mResult = new SigmaResultType(); SigmaResultType cResult = new SigmaResultType(); DataSet CustomFiledSD = materialCustomFieldMgr.ListMaterialCustomFieldByFieldName(ColName); DataRow CustomFiledSR = CustomFiledSD.Tables[0].Rows[0]; if (CustomFiledSD.Tables[0].Rows.Count > 0) { equipmentCustomField.EquipmentId = EquipmentId; equipmentCustomField.CustomFieldId = Convert.ToInt32(CustomFiledSR["CustomFieldId"].ToString()); equipmentCustomField.Value = CustomFieldValue; equipmentCustomField.CreatedBy = userinfo.SigmaUserId; mResult = equipmentMgr.AddEquipmentCustomField(equipmentCustomField); } else { customField.FieldName = ColName; customField.IsDisplayable = "Y"; customField.CreatedBy = userinfo.SigmaUserId; cResult = customFieldMgr.AddCustomField(customField); if (cResult.IsSuccessful) { equipmentCustomField.EquipmentId = EquipmentId; equipmentCustomField.CustomFieldId = cResult.ScalarValue; equipmentCustomField.Value = CustomFieldValue; equipmentCustomField.CreatedBy = userinfo.SigmaUserId; mResult = equipmentMgr.AddEquipmentCustomField(equipmentCustomField); } } return mResult.IsSuccessful; }