ckdataset.designer.cs

将数据库中的一列汉字批量转换为拼音第一个字母并存到另一列

                this.columnspbh = base.Columns["spbh"];
                this.columnspmc = base.Columns["spmc"];
                this.columnspgg = base.Columns["spgg"];
                this.columnspdw = base.Columns["spdw"];
                this.columnchckbh = base.Columns["chckbh"];
                this.columncptype = base.Columns["cptype"];
                this.columnchck = base.Columns["chck"];
                this.columnspsl = base.Columns["spsl"];
                this.columnspdj = base.Columns["spdj"];
                this.columnspje = base.Columns["spje"];
                this.columngys = base.Columns["gys"];
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            private void InitClass() {
                this.columnspid = new System.Data.DataColumn("spid", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnspid);
                this.columnspbh = new System.Data.DataColumn("spbh", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnspbh);
                this.columnspmc = new System.Data.DataColumn("spmc", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnspmc);
                this.columnspgg = new System.Data.DataColumn("spgg", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnspgg);
                this.columnspdw = new System.Data.DataColumn("spdw", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnspdw);
                this.columnchckbh = new System.Data.DataColumn("chckbh", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnchckbh);
                this.columncptype = new System.Data.DataColumn("cptype", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columncptype);
                this.columnchck = new System.Data.DataColumn("chck", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnchck);
                this.columnspsl = new System.Data.DataColumn("spsl", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnspsl);
                this.columnspdj = new System.Data.DataColumn("spdj", typeof(double), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnspdj);
                this.columnspje = new System.Data.DataColumn("spje", typeof(double), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnspje);
                this.columngys = new System.Data.DataColumn("gys", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columngys);
                this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
                                this.columnspid}, true));
                this.columnspid.AutoIncrement = true;
                this.columnspid.AllowDBNull = false;
                this.columnspid.ReadOnly = true;
                this.columnspid.Unique = true;
                this.columnspbh.MaxLength = 53;
                this.columnspmc.MaxLength = 255;
                this.columnspgg.MaxLength = 10;
                this.columnspdw.MaxLength = 255;
                this.columnchckbh.MaxLength = 255;
                this.columncptype.MaxLength = 50;
                this.columnchck.MaxLength = 255;
                this.columngys.MaxLength = 255;
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public kcRow NewkcRow() {
                return ((kcRow)(this.NewRow()));
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
                return new kcRow(builder);
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override System.Type GetRowType() {
                return typeof(kcRow);
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.kcRowChanged != null)) {
                    this.kcRowChanged(this, new kcRowChangeEvent(((kcRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.kcRowChanging != null)) {
                    this.kcRowChanging(this, new kcRowChangeEvent(((kcRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.kcRowDeleted != null)) {
                    this.kcRowDeleted(this, new kcRowChangeEvent(((kcRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.kcRowDeleting != null)) {
                    this.kcRowDeleting(this, new kcRowChangeEvent(((kcRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public void RemovekcRow(kcRow row) {
                this.Rows.Remove(row);
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
                System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
                System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
                ckDataSet ds = new ckDataSet();
                xs.Add(ds.GetSchemaSerializable());
                System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
                any1.Namespace = "http://www.w3.org/2001/XMLSchema";
                any1.MinOccurs = new decimal(0);
                any1.MaxOccurs = decimal.MaxValue;
                any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
                sequence.Items.Add(any1);
                System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
                any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
                any2.MinOccurs = new decimal(1);
                any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
                sequence.Items.Add(any2);
                System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
                attribute1.Name = "namespace";
                attribute1.FixedValue = ds.Namespace;
                type.Attributes.Add(attribute1);
                System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
                attribute2.Name = "tableTypeName";
                attribute2.FixedValue = "kcDataTable";
                type.Attributes.Add(attribute2);
                type.Particle = sequence;
                return type;
            }
        }
        
        [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
        public partial class kcRow : System.Data.DataRow {
            
            private kcDataTable tablekc;
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            internal kcRow(System.Data.DataRowBuilder rb) : 
                    base(rb) {
                this.tablekc = ((kcDataTable)(this.Table));
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public int spid {
                get {
                    return ((int)(this[this.tablekc.spidColumn]));
                }
                set {
                    this[this.tablekc.spidColumn] = value;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public string spbh {
                get {
                    try {
                        return ((string)(this[this.tablekc.spbhColumn]));
                    }
                    catch (System.InvalidCastException e) {
                        throw new System.Data.StrongTypingException("表“kc”中列“spbh”的值为 DBNull。", e);
                    }
                }
                set {
                    this[this.tablekc.spbhColumn] = value;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public string spmc {
                get {
                    try {
                        return ((string)(this[this.tablekc.spmcColumn]));
                    }
                    catch (System.InvalidCastException e) {
                        throw new System.Data.StrongTypingException("表“kc”中列“spmc”的值为 DBNull。", e);
                    }
                }
                set {
                    this[this.tablekc.spmcColumn] = value;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public string spgg {
                get {
                    try {
                        return ((string)(this[this.tablekc.spggColumn]));
                    }
                    catch (System.InvalidCastException e) {
                        throw new System.Data.StrongTypingException("表“kc”中列“spgg”的值为 DBNull。", e);
                    }
                }
                set {
                    this[this.tablekc.spggColumn] = value;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public string spdw {
                get {
                    try {
                        return ((string)(this[this.tablekc.spdwColumn]));
                    }
                    catch (System.InvalidCastException e) {
                        throw new System.Data.StrongTypingException("表“kc”中列“spdw”的值为 DBNull。", e);
                    }
                }
                set {
                    this[this.tablekc.spdwColumn] = value;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]