常用表操作方法

一、创建一个空表并加记录

        //PubTruckCustomer打印信息
        public static DataRow GetPubTruckCustomerPrintInfo(string customerNo)
        {
            //定义DataTable结构
            var dataTable = new DataTable();
            dataTable.AddColumn("CustomerNo", "客戶編號", typeof(string));
            dataTable.AddColumn("CustomerName", "客戶名稱", typeof(string));
            dataTable.AddColumn("Tel", "公司電話", typeof(string));
            dataTable.AddColumn("Fax", "公司傳真", typeof(string));

            //加一行记录   
            var dataRow = dataTable.Rows.Add();
            if (!string.IsNullOrEmpty(customerNo))
            {
                StringBuilder cmd = new StringBuilder();
                cmd.AppendLine("select top 1 CustomerNo, CustomerName, Tel, Fax ");
                cmd.AppendLine("from PubTruckCustomer ");
                cmd.AppendLine("where CustomerNo='" + customerNo.ToString() + "'");
                var customer = SmartRemoteAgent.StaticAgent.GetDataRow(cmd.ToString());
                if (customer != null)
                {
                    dataRow["CustomerNo"] = customer.Field<string>("CustomerNo");
                    dataRow["CustomerName"] = customer.Field<string>("CustomerName");
                    dataRow["Tel"] = customer.Field<string>("Tel");
                    dataRow["Fax"] = customer.Field<string>("Fax");
                }
            }
            return dataRow;
        }

二、克隆表结构并加记录

                // 1.取当前数据库中的记录
                var ds = SmartRemoteAgent.StaticAgent.GetDataSet("select * from PubTruckPort where TruckID = '" + this.CurrentItem.Row.Field<Guid>("ID") + "'");
                var dbTable = ds.Tables[0];


                // 2.创建与数据表结构一致的空临时表
                var memoryTable = dbTable.Clone();


                // 3.插入数据到临时表
                foreach (DataRow port in this.Ports.Table.Select("IsSelected = 1"))
                {
                    var newRow = memoryTable.Rows.Add();
                    newRow.SetField("ID", Guid.NewGuid());
                    newRow.SetField("TruckID", this.CurrentItem.Row.Field<Guid>("ID"));
                    newRow.SetField("PortID", port.Field<Guid>("ID"));
                    newRow.SetField("RowStatus", 0);
                }