public string OH_GetSecondTable(T_OrderHistorySearch data)
{
var companyCD = Session["CompanyCD"].ToString();
dt = bl._SelectOrderDetail(data, companyCD);
var Jsondata = JsonConvert.SerializeObject(dt);
return(Jsondata);
}
public string Check_MakerItemCD(T_OrderHistorySearch model)
{
var companyCD = Session["CompanyCD"].ToString();
DataTable dt = bl._SelectOrderDetail(model, companyCD);
string result = string.Empty;
if (dt.Rows.Count > 0)
{
result = "OK";
}
else
{
result = "NOK";
}
return(JsonConvert.SerializeObject(result));
}
public DataTable _SelectOrderDetail(T_OrderHistorySearch data, string companyCD)
{
string MakerItemCD = string.Empty;
SqlParameter[] prms = new SqlParameter[7];
var micd = new string[8] {
data.m1, data.m2, data.m3, data.m4, data.m5, data.m6, data.m7, data.m8
};
for (var i = 0; i < 8; i++)
{
if (micd[i] != null)
{
MakerItemCD += micd[i].Trim() + ',';
}
}
string MkCd = MakerItemCD.TrimEnd(',').Trim().ToString();
prms[0] = new SqlParameter("@company", SqlDbType.VarChar)
{
Value = companyCD
};
if (data.id == null)
{
prms[1] = new SqlParameter("@id", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[1] = new SqlParameter("@id", SqlDbType.VarChar)
{
Value = (data.id).Trim()
};
}
if (data.o_f == null)
{
prms[2] = new SqlParameter("@of", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[2] = new SqlParameter("@of", SqlDbType.VarChar)
{
Value = Convert.ToDateTime(data.o_f)
};
}
if (data.o_t == null)
{
prms[3] = new SqlParameter("@ot", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[3] = new SqlParameter("@ot", SqlDbType.VarChar)
{
Value = Convert.ToDateTime(data.o_t)
};
}
if (data.s_f == null)
{
prms[4] = new SqlParameter("@sf", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[4] = new SqlParameter("@sf", SqlDbType.VarChar)
{
Value = Convert.ToDateTime(data.s_f)
};
}
if (data.s_t == null)
{
prms[5] = new SqlParameter("@st", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[5] = new SqlParameter("@st", SqlDbType.VarChar)
{
Value = Convert.ToDateTime(data.s_t)
};
}
if (MkCd == "")
{
prms[6] = new SqlParameter("@m1", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prms[6] = new SqlParameter("@m1", SqlDbType.VarChar)
{
Value = MkCd
};
}
//if (data.m1 == null)
//{
// prms[6] = new SqlParameter("@m1", SqlDbType.VarChar) { Value = DBNull.Value };
//}
//else
//{
// prms[6] = new SqlParameter("@m1", SqlDbType.VarChar) { Value = (data.m1).Trim() };
//}
//if (data.m2 == null)
//{
// prms[7] = new SqlParameter("@m2", SqlDbType.VarChar) { Value = DBNull.Value };
//}
//else
//{
// prms[7] = new SqlParameter("@m2", SqlDbType.VarChar) { Value = (data.m2).Trim() };
//}
//if (data.m3 == null)
//{
// prms[8] = new SqlParameter("@m3", SqlDbType.VarChar) { Value = DBNull.Value };
//}
//else
//{
// prms[8] = new SqlParameter("@m3", SqlDbType.VarChar) { Value = (data.m3).Trim() };
//}
//if (data.m4 == null)
//{
// prms[9] = new SqlParameter("@m4", SqlDbType.VarChar) { Value = DBNull.Value };
//}
//else
//{
// prms[9] = new SqlParameter("@m4", SqlDbType.VarChar) { Value = (data.m4).Trim() };
//}
//if (data.m5 == null)
//{
// prms[10] = new SqlParameter("@m5", SqlDbType.VarChar) { Value = DBNull.Value };
//}
//else
//{
// prms[10] = new SqlParameter("@m5", SqlDbType.VarChar) { Value = (data.m5).Trim() };
//}
//if (data.m6 == null)
//{
// prms[11] = new SqlParameter("@m6", SqlDbType.VarChar) { Value = DBNull.Value };
//}
//else
//{
// prms[11] = new SqlParameter("@m6", SqlDbType.VarChar) { Value = (data.m6).Trim() };
//}
//if (data.m7 == null)
//{
// prms[12] = new SqlParameter("@m7", SqlDbType.VarChar) { Value = DBNull.Value };
//}
//else
//{
// prms[12] = new SqlParameter("@m7", SqlDbType.VarChar) { Value = (data.m7).Trim() };
//}
//if (data.m8 == null)
//{
// prms[13] = new SqlParameter("@m8", SqlDbType.VarChar) { Value = DBNull.Value };
//}
//else
//{
// prms[13] = new SqlParameter("@m8", SqlDbType.VarChar) { Value = (data.m8).Trim() };
//}
dt = dl.SelectData("Order_History_SelectSearch", prms);
return(dt);
}
