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