private void LoadYijian()
        {
            JObject     jo;
            YouGeWebApi yg = new YouGeWebApi();

            try
            {
                if (yg.GetYijian(out jo))
                {
                    int i = 0;
                    gdt.Rows.Clear();
                    while (!string.IsNullOrEmpty(jo["data"][i]["id"].ToString()))
                    {
                        DataRow dr = gdt.NewRow();
                        dr["id"]      = Convert.ToInt32(jo["data"][i]["id"].ToString());
                        dr["content"] = jo["data"][i]["content"].ToString();
                        dr["time"]    = MyOperation.Unix2Datetime(jo["data"][i]["time"].ToString());
                        dr["status"]  = jo["data"][i]["status"].ToString();
                        dr["staff"]   = jo["data"][i]["staff"].ToString();
                        if (string.IsNullOrEmpty(jo["data"][i]["stime"].ToString()))
                        {
                            dr["stime"] = jo["data"][i]["stime"].ToString();
                        }
                        else
                        {
                            dr["stime"] = MyOperation.Unix2Datetime(jo["data"][i]["stime"].ToString());
                        }
                        dr["mark"] = jo["data"][i]["mark"].ToString();
                        gdt.Rows.Add(dr);
                        i++;
                    }
                }
                else
                {
                    MessageBox.Show("初始化意见列表失败");
                }
            }
            catch (Exception e)
            {
                MyOperation.DebugPrint("LoadYijian出现catch异常:" + e.Message);
            }
            finally
            {
                dataGridView1.DataSource = gdt.DefaultView;
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 增删改操作
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <returns>执行后的条数</returns>
        public int AddDelUpdate(string sql)
        {
            MySqlConnection conn = null;
            MySqlCommand    cmd  = null;

            try
            {
                conn = this.GetConn();
                conn.Open();
                cmd = new MySqlCommand(sql, conn);
                int i = cmd.ExecuteNonQuery();
                conn.Close();
                return(i);
            }
            catch (Exception ex)
            {
                MyOperation.DebugPrint(ex.Message);
                throw;
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            int index = dataGridView1.CurrentRow.Index; //获取选中行的行号
            IDictionary <string, string> parameters = new Dictionary <string, string>();

            parameters.Add("id", dataGridView1.Rows[index].Cells[0].Value.ToString());
            parameters.Add("staff", GlobalVar.name);
            parameters.Add("status", "处理中");
            parameters.Add("stime", MyOperation.Datetime2Unix(DateTime.Now.ToString()));
            YouGeWebApi yg = new YouGeWebApi();

            if (yg.UpdateYijian(parameters))
            {
                MessageBox.Show("接单成功!");
                LoadYijian();
            }
            else
            {
                MessageBox.Show("接单失败!");
            }
        }
Esempio n. 4
0
        /// <summary>
        /// 查询操作
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public DataTable Selectinfo(string sql)
        {
            MySqlConnection  mysqlconn = null;
            MySqlDataAdapter sda       = null;
            DataTable        dt        = null;

            try
            {
                mysqlconn = this.GetConn();
                mysqlconn.Open();
                sda = new MySqlDataAdapter(sql, mysqlconn);
                dt  = new DataTable();
                sda.Fill(dt);
                mysqlconn.Close();
                return(dt);
            }
            catch (Exception ex)
            {
                MyOperation.DebugPrint(ex.Message);
                throw;
            }
        }