//거래처 등록 메서드
/// <summary>
/// 거래처 등록하는 메서드
/// </summary>
/// <param name="OffName">거래처 이름</param>
/// <param name="OwnerName">대표자이름</param>
/// <param name="OffAddr">대표 주소</param>
/// <param name="mgr">담당 매니저</param>
/// <param name="mgrMobile">매니저 번호</param>
/// <param name="OffMobile">회사 번호</param>
/// <returns>결과 메시지 반환</returns>
internal string OffInsert(string OffName, string OwnerName, string OffAddr, string mgr, string mgrMobile, string OffMobile)
{
string sp = "Bom_JW_OffInsert";
SqlParameter[] sqlParameters;
int sqlParameterSize = 5;
string result = "";
if (OffMobile != null)
{
sqlParameterSize++;
}
sqlParameters = new SqlParameter[sqlParameterSize];
sqlParameters[0] = new SqlParameter("@OffName", OffName);
sqlParameters[1] = new SqlParameter("@OwnerName", OwnerName);
sqlParameters[2] = new SqlParameter("@OffAddr", OffAddr);
sqlParameters[3] = new SqlParameter("@offMgrName", mgr);
sqlParameters[4] = new SqlParameter("@OffMgrPhone", mgrMobile);
if (OffMobile != null)
{
sqlParameters[5] = new SqlParameter("@OwnerPhone", OffMobile);
}
if (dbp.ExecuteParameters(sp, sqlParameters) != 0)
{
result = "등록성공";
}
else
{
result = "등록실패";
}
return(result);
}
/// <summary>
/// BOM등록 하는 메서드
/// </summary>
/// <param name="parentMatNo">부모 자재의 자재 번호</param>
/// <param name="childMatNo">자식 자재의 자재 번호</param>
/// <param name="childMatEA">필요 자식 자재 개수</param>
/// <returns>등록이 성공인지 실패인지 여부를 반환</returns>
internal bool InsertBom(string parentMatNo, string childMatNo, string childMatEA)
{
string sp = "Bom_Bom_Insert_Procedure";
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter("@BOM_ParentNo", Int32.Parse(parentMatNo));
sqlParameters[1] = new SqlParameter("@BOM_ChildNo", Int32.Parse(childMatNo));
sqlParameters[2] = new SqlParameter("@BOM_ChildEA", Int32.Parse(childMatEA));
bool result = false;
if (con.ExecuteParameters(sp, sqlParameters) != -1)
{
result = true;
}
else
{
result = false;
}
return(result);
}
public void InsertMat(int mat_No, int mat_Type_No, string mat_Manufactur, string mat_Name, int mat_Cost, int mat_Level, int mat_EA, int off_No)
{
try
{
string sp = "Materials_Insert_Procedure";
SqlParameter[] sqlParameters = new SqlParameter[8];
sqlParameters[0] = new SqlParameter("@mat_No", mat_No);
sqlParameters[1] = new SqlParameter("@mat_Type_No", mat_Type_No);
sqlParameters[2] = new SqlParameter("@mat_Manufactur", mat_Manufactur);
sqlParameters[3] = new SqlParameter("@mat_Name", mat_Name);
sqlParameters[4] = new SqlParameter("@mat_Cost", mat_Cost);
sqlParameters[5] = new SqlParameter("@mat_Level", mat_Level);
sqlParameters[6] = new SqlParameter("@mat_EA", mat_EA);
sqlParameters[7] = new SqlParameter("@off_No", off_No);
dp.ExecuteParameters(sp, sqlParameters);
}
catch (SqlException)
{
throw;
}
}
public int InsertOrder(int off_Order_OrderNo, int mat_No, int off_Order_EA, int off_No)
{
try
{
string sp = "Offerer_Order_Insert_Procedure";
SqlParameter[] sqlParameters = new SqlParameter[4];
sqlParameters[0] = new SqlParameter("@off_Order_OrderNo", off_Order_OrderNo);
sqlParameters[1] = new SqlParameter("mat_No", mat_No);
sqlParameters[2] = new SqlParameter("off_Order_EA", off_Order_EA);
sqlParameters[3] = new SqlParameter("off_No", off_No);
return(dp.ExecuteParameters(sp, sqlParameters));
}
catch (Exception)
{
throw;
}
}
public int InsertProducts(int mat_TypeNo, string mat_Name, int mat_Cost, int pro_Price, string pro_Name, string pro_Spec, byte[] pro_Img)
{
try
{
string sp = "Products_Insert_Procedure";
SqlParameter[] sqlParameters = new SqlParameter[7];
sqlParameters[0] = new SqlParameter("@mat_TypeNo", mat_TypeNo);
sqlParameters[1] = new SqlParameter("@mat_Name", mat_Name);
sqlParameters[2] = new SqlParameter("@mat_Cost", mat_Cost);
sqlParameters[3] = new SqlParameter("@pro_Price", pro_Price);
sqlParameters[4] = new SqlParameter("@pro_Name", pro_Name);
sqlParameters[5] = new SqlParameter("@pro_Spec", pro_Spec);
sqlParameters[6] = new SqlParameter("@pro_Img", pro_Img);
return(dp.ExecuteParameters(sp, sqlParameters));
}
catch (SqlException)
{
throw;
}
}
/// <summary>
/// 제품가격 변경하는 메서드
/// </summary>
/// <param name="ProNo">제품 번호</param>
/// <param name="Price">변경할 가격</param>
/// <returns>결과를 bool타입으로 반환</returns>
internal bool PriceUpdate(int ProNo, int ChangPrice)
{
string sp = "Bom_JW_ProPriceChinge_Procedure";
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("@no", ProNo);
sqlParameters[1] = new SqlParameter("@Price", ChangPrice);
bool TrueFalse = false;
try
{
if (dbp.ExecuteParameters(sp, sqlParameters) != -1)
{
TrueFalse = true;
}
}
catch (Exception)
{
return(false);
}
return(TrueFalse);
}
public string DateInsert1()
{
int year = 0;
int month = 0;
int day = 0;
DateTime dt;
Random rd = new Random();
DBProcessor dbp = new DBProcessor(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString);
int cusno = 0;
int empno = 0;
int prono = 0;
int cusorderorderno = 0;
string date = null;
int price = 0;
int ea = 0;
string sp1 = "DataInsertProPrice";
SqlParameter[] sqlParameter1 = new SqlParameter[1];
string sp2 = "DataInsert";
SqlParameter[] sqlParameters2 = new SqlParameter[8];
int errorCheck = 0;
for (int i = 0; i < 50; i++) // >> 버튼 한번클릭마다 인트 i = 0 초기값을 올려줘야함
{
try
{
errorCheck++;
price = 0;
prono = new Random().Next(24, 28);
ea = new Random().Next(1, 4);
year = rd.Next(2019, (int)DateTime.Today.Year + 1);
month = rd.Next(1, 3);
day = rd.Next(1, 28);
date = month.ToString() + "/" + day.ToString() + "/" + year.ToString();
dt = DateTime.Parse(date);
/////////////////////////////////////////////////////////////////////////////
sqlParameter1[0] = new SqlParameter("@pro_No", prono);
//dbp.ExecuteParametersDT(sp1, sqlParameter1);
foreach (DataRow item in dbp.ExecuteParametersDT(sp1, sqlParameter1).Rows)
{
price = Int32.Parse(item["Pro_Price"].ToString()) * ea;
}
//////////////////////////////////////////////////////////////////////////////////
sqlParameters2[0] = new SqlParameter("@cus_No", 10); //5~9번 있음
sqlParameters2[1] = new SqlParameter("@emp_No", new Random().Next(1, 5)); //4명
sqlParameters2[2] = new SqlParameter("@pro_No", prono); //6개
sqlParameters2[3] = new SqlParameter("@cus_Order_OrderNo", i + 1047); // >> 버튼 한번클릭마다 인트 i = 0 초기값을 올려줘야함
sqlParameters2[4] = new SqlParameter("@cus_Order_Date", dt);
sqlParameters2[5] = new SqlParameter("@cus_OrderComplete", 2); //2번고정
sqlParameters2[6] = new SqlParameter("@cus_Order_Price", price);
sqlParameters2[7] = new SqlParameter("@cus_Order_EA", ea);
dbp.ExecuteParameters(sp2, sqlParameters2);
}
catch (Exception)
{
return(errorCheck.ToString() + "번째에서 멈춤");
}
}
return("완료");
}