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