/// <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)); //프로시저를 활용 }