更新信息.待审批~虚拟缓存..笔记

///

        [WebMethod]
        public string cache(string table_name,string index_row_name,string where_str) {
            DataTable my_cache = mtdt_sql("Select name from syscolumns Where ID=OBJECT_ID('" + table_name + "') ");
            string my_cache_row = "";
            if (my_cache != null) {
                for (int i = 0; i != my_cache.Rows.Count; i++) {
                    if (my_cache.Rows[i]["name"].ToString() != index_row_name) {
                        if (my_cache_row == "") {
                            my_cache_row += my_cache.Rows[i]["name"].ToString();
                        }
                        else {
                            my_cache_row += "," + my_cache.Rows[i]["name"].ToString();
                        }
                    }
                }
            }
            string index_row_id = MyDs_ExecuteScalar("INSERT INTO " + table_name + " select " + my_cache_row + " from "+table_name+" where " + where_str + " SELECT @@IDENTITY").ToString();
            return index_row_id;
            //mtdt_sql_Operation("Select name from syscolumns Where ID=OBJECT_ID('PersonnelInfo')");
        }

///

MyServer.FirearmsInfo_UP(sqlstr3, "FID = " + MyServer.cache("FirearmsInfo", "FID", "FID = " + Request.QueryString["FID"].ToString()));

///

if (Request.Cookies["Divided"].Value == "3") {
                        HtmlStr1 += "<td><a onclick=\"javascript:del_data('del.aspx?url_str=" + Request.Url.ToString() + "&table_name=FirearmsInfo&where_str=FID=" + MyDt.Rows[i]["FID"] + "&type=up&where_str_=FirearmsNB=" + MyDt.Rows[i]["FirearmsNB"] + "^and^DeptID=" + MyDt.Rows[i]["DeptID"] + "^and^Approval=1')\">审批</a></td>";

                        string Approval = MyDt.Rows[i]["Approval"].ToString();
                        if (Approval == "0") {
                            HtmlStr1 += "<td><a >新增审批</a></td>";
                        }
                        else if (Approval == "3") {
                            HtmlStr1 += "<td><a >更新审批</a></td>";
                        }
                    }

///

<script language="javascript" type="text/javascript">
function del_data(url){
    var r = confirm("确定进行此操作吗?");
    if(r == true){
        window.location.href=url;
    }
    else{}
}
</script>

///

        protected void Page_Load(object sender, EventArgs e) {
            string sqlstr = "";
            if (Request.QueryString["type"] == null) {
                sqlstr = "DELETE FROM " + Request.QueryString["table_name"].ToString() + " WHERE " + Request.QueryString["where_str"].ToString();
            }
            else {
                DataTable mydt = MyServer.mtdt_sql("select * from " + Request.QueryString["table_name"].ToString() + " WHERE " + Request.QueryString["where_str"].ToString());
                string where_str_ = "";
                string where_str_s = "";
                if (Request.QueryString["where_str_"] != null) {
                    where_str_ = Request.QueryString["where_str_"].ToString();
                    string[] where_str_arr = where_str_.Split('^');
                    for (int i = 0; i != where_str_arr.Length; i++) {
                        where_str_s += " " + where_str_arr[i];
                    }
                }
                if (mydt.Rows[0]["Approval"].ToString() == "3") {
                    sqlstr = "DELETE FROM " + Request.QueryString["table_name"].ToString() + " WHERE " + where_str_s;
                    sqlstr = "UPDATE " + Request.QueryString["table_name"].ToString() + " SET Approval = 1 WHERE " + Request.QueryString["where_str"].ToString();
                }
                else if (mydt.Rows[0]["Approval"].ToString() == "0") {
                    sqlstr = "UPDATE " + Request.QueryString["table_name"].ToString() + " SET Approval = 1 WHERE " + Request.QueryString["where_str"].ToString();
                }
            }//UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson' 
            MyServer.mtdt_sql_Operation(sqlstr);
            Response.Redirect(Request.QueryString["url_str"].ToString());
        }

只做为笔记..具体功能也还木时间写!!!可以看看~~~