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