Exemple #1
0
        public str_sys_dw f_constr_load(string as_username, string as_winname, ref DataWindow adw_dw, ref str_sys_dw astr_dws_g, ref str_sys_dw astr_dws_i)
        {
            //待实现
            str_sys_dw ret = new str_sys_dw();

            return(ret);
        }
Exemple #2
0
        public long f_delt_dw_pre_file(ref DataWindow adw_dw)
        {// 数据浏览界面删除数据不做检查
         //choose case left(adw_dw.tag,1)
         //    case "0","1"
         //        return 0
         //end choose
            ////上传文件的字段后缀必须是“_7z”
            //long ll_ci,ll_i,ll_j,ll_cj
            //string ls_data,ls_col
            //ll_ci = adw_dw.rowcount()
            //ll_cj=long(adw_dw.Object.DataWindow.Column.Count)
            //for ll_j = 1 to ll_cj
            //    if left(adw_dw.Describe("#" + string(ll_j) + ".coltype") , 5) <> "char(" then continue // 不是字符型的不判断
            //    ls_col = adw_dw.Describe("#" + string(ll_j) + ".name")
            //    if right(ls_col,3) <> "_7z" then continue // 后缀名不是_7z的不判断
            //    for ll_i = 1 to ll_ci
            //        ls_data = adw_dw.getitemstring(ll_i, ls_col)
            //        if isnull(ls_data) or trim(ls_data) = "" then continue
            //        f_msg( "请先删除,第 " + string(ll_i) + " 行 " + adw_dw.describe(ls_col + "_t.text") + " 的上传文件 " + ls_data )
            //        return -1
            //    next
            //next

            return(0);
        }
Exemple #3
0
 public void f_constr_private(ref DataWindow adw_dw)
 {
     //adw_dw.SetTransObject(sqlca)
     //string ls_sort
     //ls_sort = adw_dw.object.DataWindow.Table.Sort //adw_dw.describe("DataWindow.Table.Sort")
     //if not (((ls_sort = "?") or (ls_sort = "!") or (ls_sort = "") or isnull(ls_sort))) then
     //    adw_dw.title = ls_sort
     //    adw_dw.setsort("")
     //end if
     //adw_dw.object.DataWindow.Table.Sort=""
     ////adw_dw.modify('DataWindow.Table.Sort=""')
     ////settrans()和settransobject()得功能几乎一样,只是前者内部自动调用connect或disconnect,在系统中这样频繁的调用对系统的性能是有影响。
     //string ls_colname,ls_t9,ls_9
     //string ls_lpobjects
     //long ll_looppos
     //ls_9 = char(9)
     //ls_t9 = "_t" + ls_9
     //ls_lpobjects = adw_dw.Describe("datawindow.objects") + ls_9
     //if ls_lpobjects = ls_9 then
     //    f_error("datawindow未设置", adw_dw.classname())
     ////f_msg("",g5_sys.s_object)
     //end if
     //ll_looppos = pos(ls_lpobjects,ls_t9)
     //do while ll_looppos >= 2
     //    ls_colname = left(ls_lpobjects, ll_looppos - 1)
     ////	ls_lpobjects = mid(ls_lpobjects, ll_looppos + 3)
     //    ll_looppos = pos(ls_lpobjects, ls_t9, ll_looppos + 3)
     //    if lastpos(ls_colname, ls_9) >= 1 then ls_colname = midw(ls_colname, lastpos(ls_colname, ls_9) + 1)
     //    if adw_dw.Describe(ls_colname + ".visible") = "0" then adw_dw.modify(ls_colname + '_t.tag="private"')
     //loop
     //adw_dw.object.datawindow.print.documentname = string(long(adw_dw.DesCribe('datawindow.detail.height')) - 8)
 }
Exemple #4
0
 public void f_get_sql_id_table(ref DataWindow adw_dw, ref string as_id_name, ref string as_sql_name, ref string as_tb_name)
 {
     as_id_name  = adw_dw.IdCol;
     as_sql_name = adw_dw.SqlName;
     as_tb_name  = adw_dw.TableName;
     //if (lower(left(as_tb_name,4)) == "dbo." )
     //    as_tb_name = mid(as_tb_name,5);
 }
Exemple #5
0
        public long f_itemchanged(ref long row, ref string dwo, ref string data, ref DataWindow adw_dw, DateTime adt_0)
        {
            //if isnull(data) or data = "" then return 0
            //long ll_data,ll_year,ll_jk
            //string ls_mess = "",ls_name
            //CHOOSE CASE dwo.ColType
            //    CASE "date","datetime"
            //        ll_data = long(left(data,4))
            //        ll_year = year(date(adt_0)) // 服务器上的当前日期
            //        if ll_data <= 1753 then
            //            ls_mess = "您输入的 " + adw_dw.describe(dwo.name+"_t.text") + ":" + data + "太小了,必须大于1753年!"
            //            goto rtend
            //        end if
            //        ls_name = trim(adw_dw.describe(dwo.name+"_t.tag"))
            //        choose case ls_name
            //            case "?",""
            //                ls_name = right(dwo.name,3)
            //        end choose
            //        choose case ls_name
            //            case "_1t"
            //                ll_jk = 10
            //            case "_2t"
            //                ll_jk = 20
            //            case "_5t"
            //                ll_jk = 50
            //            case "_1h"
            //                ll_jk = 100
            //            case "_2h"
            //                ll_jk = 200
            //            case "_5h"
            //                ll_jk = 500
            //            case "_1k"
            //                ll_jk = 1000
            //            case "_2k"
            //                ll_jk = 2000
            //            case "_5k"
            //                ll_jk = 5000
            //            case else
            //                ll_jk = 1
            //        end choose
            //        if ll_data > ll_year + ll_jk or ll_data < ll_year - ll_jk then
            //            ls_mess = "您输入的 " + adw_dw.describe(dwo.name+"_t.text") + ":" + data + "不正确,与当前日期相差太大了!"
            //            goto rtend
            //        end if
            //END CHOOSE



            //rtend:
            //if ls_mess = "" then
            //    return 0
            //else
            //    f_msg(ls_mess)
            //    return 1
            //end if
            return(0);
        }
Exemple #6
0
 public void f_sql_retrieve(string as_select, string as_cxtj, ref DataWindow adw_dw, bool ab_retrieve)
 {
     if (as_cxtj.Contains("\""))
     {
         MessageBox.Show("查询语句中不能含有双引号!");
         return;
     }
     adw_dw.CurrentConditoin = as_cxtj;
     adw_dw.Retrieve();
 }
Exemple #7
0
        public void f_dddw_show(string as_col, ref DataWindow adw_dw, ref long al_dropdown_show)
        {
            //choose case adw_dw.DesCribe(as_col+'.edit.style')
            //    case 'dddw'
            //        if al_dropdown_show <= 256 then
            //            keybd_event(115, 0, 0, 0 )         //  按下F4
            //            keybd_event(115, 0, 2, 0 )         //  释放F4
            //        end if
            //    case 'ddlb'
            //        if al_dropdown_show <= 256 then
            //            keybd_event(115, 0, 0, 0 )         //  按下F4
            //            al_dropdown_show = 888
            //            keybd_event(115, 0, 2, 0 )         //  释放F4
            //        end if

            //end choose
        }
Exemple #8
0
        public void f_constr_save(string as_username, string as_winname, DataWindow adw_dw)
        {
            //string ls_dwname;
            //ls_dwname = adw_dw.DataObject + "_" + adw_dw.Tag.ToString().Substring(0,3);
            //string ls_colwb,ls_colxb,ls_colvb,ls_colsortb,ls_colnb;
            //string[] ls_colxa,ls_colna,ls_colwa,ls_colva;
            //f_constr_getx(adw_dw,ls_colna,ls_colxa,ls_colwa,ls_colva);
            //ls_colnb=global.gu_pub1.f_s_arraytolista(ls_colna,";");
            //ls_colxb=global.gu_pub1.f_s_arraytolista(ls_colxa,";");
            //ls_colwb=global.gu_pub1.f_s_arraytolista(ls_colwa,";");
            //ls_colvb=global.gu_pub1.f_s_arraytolista(ls_colva,";");


            //string ls_colwc,ls_colxc,ls_colvc,ls_colnc,ls_colsortc,ls_colsortsetc
            //select top 1 colname,colx,colwidth,colvisible,colsort,sort_set
            //into :ls_colnc,:ls_colxc,:ls_colwc,:ls_colvc,:ls_colsortc,:ls_colsortsetc
            //    from mis_dw_argument WITH (NOLOCK)
            //    where user_name1 = :as_username and window1 = :as_winname and dataobject = :ls_dwname ;
            //if ls_colsortsetc = "Y" then // 每次打开页面时排序固定,用在设置页面设置好的排序
            //    if ls_colnc + ls_colxc + ls_colwc + ls_colvc = ls_colnb + ls_colxb + ls_colwb + ls_colvb then return
            //    update mis_dw_argument set
            //        colname = :ls_colnb,
            //        colx = :ls_colxb,
            //        colwidth = :ls_colwb,
            //        colvisible = :ls_colvb,
            //        lrsj=getdate()
            //    where user_name1 = :as_username and window1 = :as_winname and dataobject = :ls_dwname ;
            //elseif ls_colsortsetc = "N" then // 每次打开页面时排序不固定,用每次关闭页面时的排序
            //    ls_colsortb = adw_dw.title //describe("DataWindow.Table.Sort")
            //    if ls_colnc + ls_colxc + ls_colwc + ls_colvc + ls_colsortc = ls_colnb + ls_colxb + ls_colwb + ls_colvb + ls_colsortb then return
            //    update mis_dw_argument set
            //        colname = :ls_colnb,
            //        colx = :ls_colxb,
            //        colwidth = :ls_colwb,
            //        colvisible = :ls_colvb,
            //        colsort = :ls_colsortb,
            //        lrsj=getdate()
            //    where user_name1 = :as_username and window1 = :as_winname and dataobject = :ls_dwname ;
            //else
            //    ls_colsortb = adw_dw.title //describe("DataWindow.Table.Sort")
            //    insert into mis_dw_argument (user_name1,window1,dataobject,colname,colx,colwidth,colvisible,colsort,sort_set,lrsj)
            //    values (:as_username,:as_winname,:ls_dwname,:ls_colnb,:ls_colxb,:ls_colwb,:ls_colvb,:ls_colsortb,"N",getdate()) ;
            //end if
        }
Exemple #9
0
        public void f_dwsort(DataWindow adw_dw, string as_colname)
        {
            //if mid(adw_dw.tag,5,1) = "N" then return
            //string ls_sort
            ////f_msg("2",as_dwname+as_colname)
            //if rightw(as_colname,2) = '_t' then
            //    adw_dw.SetRedraw(false)
            //    ls_sort = f_dwsort_ctrl(adw_dw,as_colname)
            //else
            //    ls_sort = f_dwsort_sort(adw_dw,as_colname)
            //end if

            //if trim(ls_sort) = "" or isnull(ls_sort) then
            //    if rightw(as_colname,2) = '_t' then adw_dw.SetRedraw(true)
            //    return
            //end if

            //adw_dw.title = ls_sort
            //string ls_upper[],ls_col
            //long ll_i,ll_ci
            //any lll
            //gu_pub1.f_s_listtoarray(ls_sort,", ",ls_upper[])
            //ll_ci = upperbound(ls_upper[])
            //for ll_i = 1 to ll_ci
            //    ls_col = left(ls_upper[ll_i],len(ls_upper[ll_i]) - 2)
            //    if left(adw_dw.Describe(ls_col+'.coltype') , 5) = "char(" then
            //         ls_upper[ll_i] = "upper("+ls_col+") " + right(ls_upper[ll_i],1)
            //    end if
            //next
            //ls_sort = gu_pub1.f_s_arraytolists(ls_upper[],", ")

            //adw_dw.SetSort(ls_sort)
            //adw_dw.Sort()
            //adw_dw.SetSort("")
            //adw_dw.GroupCalc()//重新计算分组
            ////	f_msg("当前排序",fdw_dw.describe("DataWindow.Table.Sort"))

            //if rightw(as_colname,2) = '_t' then adw_dw.SetRedraw(true)
            //return
        }
Exemple #10
0
        private void Form1_Load(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();

            dt.Columns.Add("Name");
            dt.Columns.Add("Value");
            dt.Rows.Add("北京", "Y");
            dt.Rows.Add("上海", "N");
            dt.Rows.Add("南京", "N");
            dt.Rows.Add("哈尔滨", "N");
            myOptions1.Columns = 1;
            myOptions1.BindData(dt);

            ((MyOptionsColumn)dataGridView1.Columns["Column1"]).DataSource = dt;
            dataGridView1.Rows.Add();
            dataGridView1.Rows[0].Cells[0].Value             = "哈尔滨";
            dataGridView1.Columns[0].DefaultCellStyle.Format = "";
            dataWindow1.Retrieve("1");
            DataWindow dw = dataWindow1;

            dw.setitem(0, "pihao", "aaaaa");
        }
Exemple #11
0
 public long f_dw_col_isnull(ref long row, ref string dwo, ref string data, ref DataWindow adw_dw)
 {
     //            choose case left(dwo.coltype , 5)
     //    case "char("
     //        if isnull(data) or data = "" or left(data,1) = " " or right(data,1) = " " then
     //            f_msg( adw_dw.describe(dwo.name + "_t.text") + " 为空或第一个字符为空或最后一个字符为空!")
     //            return -1
     //        end if
     //    case "date"
     //        if isnull(data) then
     //            f_msg( adw_dw.describe(dwo.name + "_t.text") + " 不能为空!")
     //            return -1
     //        end if
     //    case "datet"
     //        if isnull(data) then
     //            f_msg( adw_dw.describe(dwo.name + "_t.text") + " 不能为空!")
     //            return -1
     //        end if
     //    case "decim","int","long","numbe","real","ulong"
     //        if isnull(data) then
     //            f_msg( adw_dw.describe(dwo.name + "_t.text") + " 不能为空!")
     //            return -1
     //        end if
     //    case "time","times"
     //        if isnull(data) then
     //            f_msg( adw_dw.describe(dwo.name + "_t.text") + " 不能为空!")
     //            return -1
     //        end if
     //    case "!"
     //        f_msg("提示dw_col_isnull 找不到相对应的字段(" + string(dwo.name) + ")!")
     //        return 0
     //    case else
     //        f_msg("提示dw_col_isnull " + string(dwo.coltype) + " 未知的数据类型,请把这条信息发送给信息管理员")
     //        return 0
     //end choose
     return(0);
 }
Exemple #12
0
        public long f_delt_dw_row(ref DataWindow adw_dw, ref long al_focuschanged, long al_xuhao)
        {
            if (al_xuhao >= 0)
            {
                if (MessageBox.Show("您确实要删除吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return(-1);
                }
            }
            al_focuschanged = 666; //多行删除选中行后导致的焦点改变
            long ll_i, ll_count;

            ll_count = adw_dw.rowcount();
            if (adw_dw.Tag.ToString().Substring(0, 1) == "3")  // 单行删除
            {
                if (ll_count == 1)
                {
                    if (f_delt_dw_pre_file(ref adw_dw, ll_count) == -1)
                    {
                        return(-1);
                    }
                    adw_dw.deleterow(1);
                }
            }
            else // 多行删除
            {
                //for (ll_i = ll_count; ll_i >= 1; ll_i--)
                //{
                //    if (adw_dw.IsSelected(ll_i))
                //    {
                //        if (f_delt_dw_pre_file(ref adw_dw, ll_i) == -1)
                //            return -1;
                //        adw_dw.deleterow(ll_i);
                //    }
                //}
                for (int i = adw_dw.dataGridView1.SelectedRows.Count - 1; i >= 0; i--)
                {
                    if (f_delt_dw_pre_file(ref adw_dw, adw_dw.dataGridView1.SelectedRows[i].Index) == -1)
                    {
                        return(-1);
                    }
                    adw_dw.deleterow(adw_dw.dataGridView1.SelectedRows[i].Index);
                }
            }
            al_focuschanged = 0;
            //al_xuhao  // 1代表有序号的需要重新更改序号  0代表没有序号的跳过 负数代表不提示直接删除
            if (al_xuhao == 1)
            {
                string ls_colname, ls_sort = "";
                //ls_sort = adw_dw.title;
                ls_colname = adw_dw.Cols[0].Name;
                f_dwsort(adw_dw, ls_colname + " A");
                for (ll_i = 0; ll_i < adw_dw.rowcount(); ll_i++)
                {
                    if (adw_dw.GetItemData(ll_i, ls_colname) != ll_i.ToString())
                    {
                        adw_dw.setitem(ll_i, ls_colname, ll_i + 1);
                    }
                }
                f_dwsort(adw_dw, ls_sort);
            }
            return(1);
        }