Пример #1
0
        /// <summary>
        /// 读取预分装列表
        /// </summary>
        /// <returns></returns>
        public List <AddvanceSubInfo> ReadSubInfo()
        {
            List <AddvanceSubInfo> returnVal = new List <AddvanceSubInfo>();

            string ConnString = ConfigurationManager.AppSettings["Sngoo"];
            //string inputPs, readPS;

            string        ConnQuery  = "  select * from AddvanceSub ";
            SqlConnection connection = new SqlConnection(ConnString);

            connection.Open();
            SqlCommand    lo_cmd = new SqlCommand(ConnQuery, connection);
            SqlDataReader reader = lo_cmd.ExecuteReader();

            while (reader.Read())
            {
                AddvanceSubInfo item = new AddvanceSubInfo();
                item.AddvanceSubState = Convert.ToInt32(reader["AddvanceSubState"]);
                item.CountTime        = Convert.ToDateTime(reader["CountTime"]);
                item.Details          = reader["Details"].ToString();
                item.id         = Convert.ToInt32(reader["id"]);
                item.OrderNum   = Convert.ToInt32(reader["OrderNum"]);
                item.AddvanceId = reader["AddvanceId"].ToString();
                returnVal.Add(item);
            }



            reader.Close();
            connection.Close();
            connection.Dispose();

            //ConnString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=sngoo712;Data Source=(local)";
            return(returnVal);
        }
Пример #2
0
        /// <summary>
        /// 写入预分装列表
        /// </summary>
        /// <param name="info">与分装信息</param>
        public void WriteIntoSub(AddvanceSubInfo info)
        {
            string ConnString = ConfigurationManager.AppSettings["Sngoo"];
            string ConnQuery  = "  insert into  AddvanceSub (CountTime,OrderNum,Details,AddvanceSubState,AddvanceId) values('" + info.CountTime + "'," + info.OrderNum + ",'" + info.Details + "'," + info.AddvanceSubState + ",'" + info.AddvanceId + "')";

            SqlConnection connection = new SqlConnection(ConnString);

            connection.Open();
            SqlCommand lo_cmd = new SqlCommand(ConnQuery, connection);

            lo_cmd.ExecuteNonQuery();



            connection.Close();
            connection.Dispose();
        }