CO BY QT(Change datagrid row color and delete datagrid row)

 Delete DataGrid row:
if  ( e.Item.Cells[ 1 ].ForeColor  ==  Color.Green )
{
    
if  (Session[ " CreateWay " ].ToString()  ==   " 1 " )
    {
        Session[
" ItemStatus " =   " New " ;
        Session[
" qtItemNo " =  e.Item.Cells[ 1 ].Text.Trim();
    
        DataSet ds
= new  DataSet();
    
        ds 
=  (DataSet)Session[ " ItemInfo " ];
        
        
for ( int  i  =   0 ;i < ds.Tables[ 0 ].Rows.Count;i ++ )
            {
                
if (e.Item.Cells[ 1 ].Text.ToString()  ==  ds.Tables[ 0 ].Rows[i][ 0 ].ToString())
                {
                    DataRow dr 
=  ds.Tables[ 0 ].Rows[i];
                    ds.Tables[
0 ].Rows.Remove(dr);
                }
            }
        setQTItemData();
    }
}

Data load:

            DataTable dt = new  DataTable();
            dt.Columns.Add(
new  DataColumn( " item_No " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " shipto_No " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " status " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " MS_Code " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " catg_flg " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " srce_type " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " reserve_no " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " qty_order " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " sp_contr " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " sales_dept " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " prod_prep_dept " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " lead_time " , typeof ( string )));
            dt.Columns.Add(
new  DataColumn( " date_sche_ship " , typeof ( string )));                
                    
            DataSet itemList;
            itemList 
=  COService.listCoItemInfoOfShipment(companyID,costCenterID,cono,shipmentNo);

            txt_PageNO.Text 
=  Convert.ToString(dg_itemList.CurrentPageIndex  +   1 );
            txt_TotalNum.Text 
=  Convert.ToString( dg_itemList.PageCount  +   1 ); 
            
if  (Session[ " HeadStatus " ].ToString()  ==   " Query " )
            {        
                dg_itemList.DataSource 
=  itemList;
                dg_itemList.DataBind();
                txt_PageNO.Text 
=  Convert.ToString(dg_itemList.CurrentPageIndex  +   1  );
                txt_TotalNum.Text 
=  Convert.ToString( dg_itemList.PageCount ); 
            }
            
else
            {
                
if  ( Session[ " CreateWay " ].ToString()  ==   " 1 "  )
                {            
                    DataSet ds
= new  DataSet();

                    ds 
=  (DataSet)Session[ " ItemInfo " ];

                    
for  (  int  i  =   0 ; i < itemList.Tables[ 0 ].Rows.Count; i ++  )
                    {
                        DataRow dr
= dt.NewRow();
                        dr[
" item_No " ] =  itemList.Tables[ 0 ].Rows[i][ " item_no " ].ToString();
                        dr[
" shipto_No " ] = itemList.Tables[ 0 ].Rows[i][ " SHIPTO_NO " ].ToString();
                        dr[
" status " ] = itemList.Tables[ 0 ].Rows[i][ " STATUS " ].ToString();
                        dr[
" MS_Code " ] = itemList.Tables[ 0 ].Rows[i][ " MS_CODE " ].ToString();
                        dr[
" catg_flg " ] = itemList.Tables[ 0 ].Rows[i][ " CATG_FLG " ].ToString();
                        dr[
" srce_type " ] = itemList.Tables[ 0 ].Rows[i][ " srce_type " ].ToString();
                        dr[
" qty_order " ] = itemList.Tables[ 0 ].Rows[i][ " qty_order " ].ToString();
                        dr[
" sp_contr " ] = itemList.Tables[ 0 ].Rows[i][ " sp_contr " ].ToString();
                        dr[
" reserve_no " ] = itemList.Tables[ 0 ].Rows[i][ " reserve_no " ].ToString();
                        dr[
" sales_dept " ] = itemList.Tables[ 0 ].Rows[i][ " sales_dept " ].ToString();
                        dr[
" lead_time " ] = itemList.Tables[ 0 ].Rows[i][ " lead_time " ].ToString();                        
                        
                        dt.Rows.Add(dr);
                    }

                    
for int  i  =   0 ; i  <  ds.Tables[ 0 ].Rows.Count; i ++  )
                    {
                        DataRow dr
= dt.NewRow();
                        dr[
" item_No " ] =  ds.Tables[ 0 ].Rows[i][ " ItemNO " ].ToString();
                        dr[
" shipto_No " ] = ds.Tables[ 0 ].Rows[i][ " ShiptoNO " ].ToString();
                        dr[
" status " ] = ds.Tables[ 0 ].Rows[i][ " Status " ].ToString();
                        dr[
" MS_Code " ] = ds.Tables[ 0 ].Rows[i][ " MSCode " ].ToString();
                        dr[
" catg_flg " ] = ds.Tables[ 0 ].Rows[i][ " Catalog " ].ToString();
                        dr[
" srce_type " ] = ds.Tables[ 0 ].Rows[i][ " SourceType " ].ToString();
                        dr[
" qty_order " ] = ds.Tables[ 0 ].Rows[i][ " QTY " ].ToString();
                        dr[
" sp_contr " ] = ds.Tables[ 0 ].Rows[i][ " ListPrice " ].ToString();
                        dr[
" reserve_no " ] = ds.Tables[ 0 ].Rows[i][ " ReserveNO " ].ToString();
                        dr[
" sales_dept " ] = ds.Tables[ 0 ].Rows[i][ " SalesDepart " ].ToString();
                        dr[
" lead_time " ] = ds.Tables[ 0 ].Rows[i][ " LeadTime " ].ToString();                        
                        
                        dt.Rows.Add(dr);
                        
                    }

                    DataSet ds1
= new  DataSet();
                    ds1.Tables.Add(dt);
                dg_itemList.DataSource 
= ds1;
                        dg_itemList.DataBind();
                        
for int  i  =   0 ; i  <  ds.Tables[ 0 ].Rows.Count; i ++  )
                        {
                            ChangeColor(dg_itemList,dg_itemList.Items.Count
- i - 1 ,Color.Green);
                        }
                    
}

Change DataGrid row color:

         public   void  ChangeColor(DataGrid dg, int  index,Color cl)
        {
            
for ( int  i = 0 ;i < dg.Columns.Count;i ++ )
            {
                dg.Items[index].Cells[i].ForeColor
= cl;
            }
            
        }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值