public string book_return(string barcode, string returntime, string userid, string userlocation) { string host = libhp.ini_opacurl(); string st = string.Format("server={0};database=database;User ID=user;Password=pwd;Trusted_Connection=false;", host); using (SqlConnection con = new SqlConnection(st)) { con.Open(); string sql = string.Format("exec dbo.wsrv_return @acce01='{0}', @i1=1, @i2=1, @autosave=1,@hist01 = '{1}', @sent06 = '{2}', @hist14='{3}',@returntype = 1, @stoptype=1;", barcode, returntime, userid, userlocation); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(sql, con); da.Fill(dt); Book_return book_return = new Book_return(); book_return.result = dt.Rows[0][0].ToString(); book_return.msg = dt.Rows[0][1].ToString(); book_return.cata11 = dt.Rows[0][13].ToString(); book_return.acce01 = dt.Rows[0][2].ToString(); book_return.cata12 = dt.Rows[0][8].ToString(); book_return.sent02 = dt.Rows[0][3].ToString() + " 23:59"; book_return.hist01 = dt.Rows[0][4].ToString(); book_return.overday = dt.Rows[0][19].ToString(); book_return.hist03 = dt.Rows[0][6].ToString(); string result = JsonConvert.SerializeObject(book_return); return(result); } }
private void btn_hs_Click(object sender, EventArgs e) // { string opacurl = libhp.ini_opacurl(); string barcode = txt_barcode2.Text.Trim(); string hist01 = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); string userid = string1; string userlocation = string2; string url = string.Format("http://{0}/getservice.ashx?mode=4&barcode={1}&userid={2}&userlocation={3}", opacurl, barcode, userid, userlocation); string get = string.Empty; if (libhp.ini_mode() == "0") { get = libhp.getservice(url); } else { get = sqlhp.book_return(barcode, hist01, userid, userlocation); } Book_return m = JsonConvert.DeserializeObject <Book_return>(get); switch (m.result.ToString()) { case "0": { int i = Convert.ToInt32(label18.Text) + 1; dataGridView_hs.Rows.Insert(0, Image.FromFile("c:\\check.png"), i, m.acce01, m.cata12, m.sent02, m.hist01, m.msg); dataGridView_hs.CurrentCell = dataGridView_hs.Rows[0].Cells[0]; dataGridView_hs.CurrentRow.DefaultCellStyle.BackColor = Color.White; dataGridView_hs.ClearSelection(); libhp.clean_control(txt_barcode2); label18.Text = i.ToString(); break; } default: { int i = Convert.ToInt32(label18.Text) + 1; dataGridView_hs.Rows.Insert(0, Image.FromFile("c:\\notice.png"), i, m.acce01, m.cata12, "", "", m.msg); dataGridView_hs.CurrentCell = dataGridView_hs.Rows[0].Cells[0]; dataGridView_hs.CurrentRow.DefaultCellStyle.BackColor = Color.Yellow; dataGridView_hs.ClearSelection(); libhp.clean_control(txt_barcode2); label18.Text = i.ToString(); break; } } }