//Find GridView MC Daily Delivery
public static DataTable GridItemDetail(MCDelObj objI)
{
string SQL = string.Empty;
DataTable dt = new DataTable();
objI.DelDate = (!String.IsNullOrEmpty(objI.DelDate) ? objI.DelDate : null);
objI.DelType = (!String.IsNullOrEmpty(objI.DelType) ? objI.DelType : null);
objI.KDLot = (!String.IsNullOrEmpty(objI.KDLot) ? objI.KDLot : null);
SQL = "exec spx_GetDataGrideView_MCDaily "
+ "@inDelDate = '" + objI.DelDate + "',@inDelType = '" + objI.DelType + "',@inKDLot = '" + objI.KDLot + "',@ERROR_NUMBER = '',@ERROR_MESSAGE = '' ";
dt = ExecuteReader(SQL);
return(dt);
}
//Insert MC Daily Delivery CKD
public static void Insert_MCDailyDelivery_CKD(MCDelObj objI)
{
SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["IM"].ConnectionString);
SqlCommand objCmd = new SqlCommand();
String strStored = "spx_Generate_Daily_Delivery_MC_CKD";
objCmd.Parameters.Add(new SqlParameter("@inDelDate", SqlDbType.VarChar)).Value = objI.DelDate;
objCmd.Parameters.Add(new SqlParameter("@inUserID", SqlDbType.VarChar)).Value = "admin-e";
objCmd.Parameters.Add(new SqlParameter("@ERROR_NUMBER", SqlDbType.VarChar)).Value = "";
objCmd.Parameters.Add(new SqlParameter("@ERROR_MESSAGE", SqlDbType.VarChar)).Value = "";
objConn.Open();
objCmd.Connection = objConn;
objCmd.CommandText = strStored;
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.ExecuteNonQuery();
objConn.Close();
objConn = null;
}