public static bool InsertUnnormalData(Model_Data data) { data.OrderDate = data.OrderDate.Substring(0, data.OrderDate.IndexOf(" ") + 1); data.SortDate = data.SortDate.Substring(0, data.SortDate.IndexOf(" ") + 1); string sqlStr = "insert into T_PRODUCE_CALLBACK values('" + data.LineName + "','" + data.LineCode + "','" + data.CusName + "','" + data.CusCode + "','" + data.BillCode + "','" + data.OrderDate + "','" + data.PackageNo + "','" + data.Null1 + "','" + data.Null2 + "','" + data.Length + "','" + data.Width + "','" + data.Height + "','" + data.CigName + "','" + data.CigCode + "','" + data.PositionX + "','" + data.PositionY + "','" + data.PositionZ + "','" + data.CigNum + "','" + data.CusPhoneNum + "','" + data.CusAddress + "','" + data.CusBusiness + "','" + data.SortDate + "','" + data.Null3 + "','" + data.CusSeq + "','" + data.CusDeliverSeq + "','" + data.CigLength + "','" + data.CigWidth + "','" + data.CigHeight + "','" + data.CusPackageSeq + "','" + data.CusTotalPackage + "','" + data.LinePackageSeq + "','" + data.LineTotalPackage + "','" + data.PackageNum + "','" + data.CusNum + "','" + data.LineCusCount + "','" + data.LabelingStatus + "','" + data.ID + "','" + data.Null4 + "','" + data.LegalPerson + "'," + data.PNo + ")"; return(OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionString, System.Data.CommandType.Text, sqlStr) > 0); }
public static List <Model_Data> GetData(decimal pno) { string sqlStr = "select * from T_PRODUCE_CALLBACK where PNO=" + pno + " order by id"; OracleDataReader reader = OracleHelper.ExecuteReader(OracleHelper.ConnectionString, System.Data.CommandType.Text, sqlStr); List <Model_Data> list = new List <Model_Data>(); while (reader.Read()) { Model_Data billInfo = new Model_Data() { CigName = reader["CIGARETTENAME"].ToString(), CigCode = reader["CIGARETTECODE"].ToString(), ID = Convert.ToInt32(reader["ID"]), PackageNo = Convert.ToInt32(reader["PACKAGENO"].ToString().Trim()), BillCode = reader["BILLCODE"].ToString(), CusAddress = reader["CUSTOMERADDRESS"].ToString(), CusName = reader["CUSTOMERNAME"].ToString(), LabelingStatus = reader["LABELINGSTATUS"].ToString(), LineName = reader["LINENAME"].ToString(), OrderDate = reader["ORDERDATE"].ToString(), PositionY = reader["POSITIONY"].ToString(), PositionZ = reader["POSITIONZ"].ToString(), CusTotalPackage = reader["CUSTOTALPACKAGE"].ToString(), PackageNum = reader["PACKAGENUM"].ToString(), LineCusCount = reader["LINECUSCOUNT"].ToString(), LineTotalPackage = reader["LINETOTALPACKAGE"].ToString(), LinePackageSeq = reader["LINEPACKAGESEQ"].ToString(), Length = reader["LENGTH"].ToString(), Width = reader["WIDTH"].ToString(), Height = reader["HEIGHT"].ToString() }; list.Add(billInfo); } reader.Close(); return(list); }
public static List <Model_Data> ReadUnFile(string path, out string msg) { StreamReader reader; List <Model_Data> list = new List <Model_Data>(); string strs = ""; try { reader = new StreamReader(path, Encoding.Default); string line; while ((line = reader.ReadLine()) != null) { string[] str = new string[37]; str = line.Split(','); Model_Data data = new Model_Data() { LineName = str[0], LineCode = str[1], CusName = str[2], CusCode = str[3], BillCode = str[4], OrderDate = str[5], PackageNo = Convert.ToInt32(str[6]), Null1 = str[7], Null2 = str[8], Length = str[9], Width = str[10], Height = str[11], CigName = str[12], CigCode = str[13], PositionX = str[14], PositionY = str[15], PositionZ = str[16], CigNum = str[17], CusPhoneNum = str[18], CusAddress = str[19], LegalPerson = Convert.ToInt32(str[20]), CusBusiness = str[21], SortDate = str[22], Null3 = str[23], CusSeq = str[24], CusDeliverSeq = str[25], Null4 = str[26], CigLength = str[27], CigWidth = str[28], CigHeight = str[29], CusPackageSeq = str[30], CusTotalPackage = str[31], LinePackageSeq = str[32], LineTotalPackage = str[33], PackageNum = str[34], CusNum = str[35], LineCusCount = str[36] }; list.Add(data); line = null; } } catch (Exception ex) { strs = ex.Message; } msg = strs; return(list); }