testtesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttestt<b>a</b>

private bool end_task()
        {
            string sql = "";

            sql = string.Format("SELECT tasklist_handle_count, tasklist_index, tasklist_inner_index, tasklist_module_id" +
                                " FROM tasklist_det" +
                                " WHERE tasklist_id = '{0}'" +
                                " ORDER BY tasklist_inner_index DESC" +
                                " LIMIT 0,1",
                                task_id);

            DataTable dt = DBAccess.getData(sql);

            task_handle_count = dt.Rows[0][0].ToString();
            task_index = string.Format("{0:D3}", dt.Rows[0][1]);
            mod_id = dt.Rows[0][3].ToString();
            task_inner_index = Int32.Parse(dt.Rows[0][2].ToString()) + 1;

            sql = "SELECT user_name FROM user_mstr WHERE user_id = '" + user_id + "';";
            dt = DBAccess.getData(sql);
            if (dt.Rows.Count > 0)
            {
                user_name = dt.Rows[0][0].ToString();
            }
            if (task_date != "")
            {
                sql = string.Format(
                                "INSERT INTO tasklist_det(tasklist_id, tasklist_step, tasklist_handle_count, tasklist_text_desc," +
                                " tasklist_memo, tasklist_user_id, tasklist_datetime, tasklist_index," +
                                " tasklist_module_id, tasklist_inner_index, tasklist_attachment)" +
                                " VALUES('{0}', {1}, {2}, '{3}', '{4}', '{5}', '{6}', {7}, {8}, {9}, '{10}');",
                                COMM.assertVal(task_id),
                                5,
                                task_handle_count,
                                COMM.assertVal(task_desc),
                                COMM.assertVal(task_memo),
                                COMM.assertVal(user_id),
                                COMM.assertVal(task_date),
                                task_index,
                                COMM.assertVal(mod_id),
                                task_inner_index,
                                task_uploaded_files);
            }

            try
            {
                DBAccess.ExecuteNonQuery(sql);
                return true;
            }
            catch (Exception e)
            {
                err = e.ToString();
                return false;
            }
        }

　　好的

ok　　行