/// <summary>
/// 자재 수정하는 메서드
/// </summary>
/// <param name="MatName">자재이름</param>
/// <param name="modifyOffNo">수정할 거래처번호</param>
/// <param name="modifyMatTypeNo">수정할 자재타입 번호</param>
/// <param name="matManufactur">수정할 제조사</param>
/// <param name="matName">수정할 자재이름</param>
/// <param name="matCost">수정할 단가</param>
internal void MatModify(string MatName, string modifyOffNo, string modifyMatTypeNo, string matManufactur, string matName, string matCost, string selectedItem)
{
MaterialsDataDataContext mddc = new MaterialsDataDataContext();
if (MatName == "")
{
MatName = null;
}
if (modifyOffNo == "")
{
modifyOffNo = "575213"; //임의로 설정한 값
}
if (modifyMatTypeNo == "")
{
modifyMatTypeNo = "575213";
}
if (matManufactur == "")
{
matManufactur = null;
}
if (matName == "")
{
matName = null;
}
if (matCost == "")
{
matCost = "575213";
}
if (selectedItem == "")
{
selectedItem = "575213";
}
mddc.Bom_JW_MatUpdate(MatName, Int32.Parse(modifyOffNo), Int32.Parse(modifyMatTypeNo), matManufactur, matName, Int32.Parse(matCost), Int32.Parse(selectedItem));
}
/// <summary>
/// 링큐를 이용하여 자재타입 고유번호 반환하는 메서드
/// </summary>
/// <param name="matTypeName">자재타입 이름</param>
/// <returns>자재 고유번호 반환</returns>
internal string GetMatTypeNo(string matTypeName)
{
MaterialsDataDataContext mddc = new MaterialsDataDataContext();
//mddc.BOM_JW_MOLLA()
int a = 0;
foreach (var item in mddc.BOM_JW_MOLLA(matTypeName))
{
a = Int32.Parse(item.Mat_Type_No.ToString());
}
return(a.ToString());
}
/// <summary>
/// 링큐를 이용하여 거래처 고유번호반환하는 메서드
/// </summary>
/// <param name="offName">거래처 이름</param>
/// <returns>거래처 고유번호 반환</returns>
public string GetOffNo(string offName)
{
MaterialsDataDataContext mddc = new MaterialsDataDataContext();
var GetNo =
from off in mddc.Offerer
where off.Off_Name == offName
select off.Off_No;
int a = 0;
foreach (var item in GetNo)
{
a = Int32.Parse(item.ToString());
}
return(a.ToString());
}
internal int MatDelete(string matName)
{
MaterialsDataDataContext mddc = new MaterialsDataDataContext();
string result = "";
return(mddc.Bom_JW_MatDelete(matName));
//var dept = mddc.Materials.Where(x => x.Mat_Name == matName).SingleOrDefault();
//if (dept != null)
//{
// mddc.Materials.DeleteOnSubmit(dept);
// mddc.SubmitChanges();
// return result = "삭제 완료";
//}
//else
//{
// return result = "삭제 실패";
//}
//var dept2 = from delete in mddc.Materials
// where delete.Mat_Name == matName
// select delete;
//foreach (var item in dept2)
//{
// mddc.Materials.DeleteOnSubmit(item);
//}
//try
//{
// mddc.SubmitChanges();
// result = "삭제 완료";
//}
//catch (Exception)
//{
// result = "삭제 실패";
// throw;
//}
}
/// <summary>
/// 링큐를 이용하여 자재정보를 반환하는 메서드
/// </summary>
/// <param name="MatName">자재이름</param>
/// <returns>재재정보 반환</returns>
internal ISingleResult <Bom_JW_MatInfoViewResult> LinqMatView(string MatName)
{
MaterialsDataDataContext mddc = new MaterialsDataDataContext();
return(mddc.Bom_JW_MatInfoView(MatName)); //프로시저를 활용
}
