Exemplo n.º 1
0
        private bool IntiRow(DataRow row)
        {
            string pid = tbId.Text.Trim();
            string innerid = tbInnerId.Text.Trim();
            string size = tbSize.Text.Trim();
            string colornum = tbColorNum.Text.Trim();
            string name = tbName.Text.Trim();
            string pos = tbPosition.Text.Trim();

            decimal price = nudPrice.Value;
            decimal cost = nudCost.Value;
            decimal store = nudStore.Value;
            decimal pkgnum = nudPkgNum.Value;

            if (String.IsNullOrEmpty(innerid))
            {
                MessageBox.Show("编号不能为空!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return false;
            }

            row.SetField<string>("productid", pid);
            row.SetField<string>("innerid", innerid);
            row.SetField<string>("size", size);
            row.SetField<string>("colornum", colornum);
            row.SetField<string>("name", name);
            row.SetField<string>("position", pos);
            row.SetField<decimal>("price", price);
            row.SetField<decimal>("cost", cost);
            row.SetField<decimal>("storenum", store);
            row.SetField<decimal>("packagenum", pkgnum);
            row.SetField<string>("opr", GlobalVar.LogInfo.Name);
            return true;
        }
Exemplo n.º 2
0
        private void btnAddSou_Click(object sender, EventArgs e)
        {
            int       ixh = GetMaxXH() + 1;
            DataTable dt  = this.treePosPair.DataSource as DataTable;

            System.Data.DataRow row = dt.NewRow();
            row.SetField("I_XH", ixh);
            row.SetField("WKID", this._wkid);
            dt.Rows.Add(row);
            this.treePosPair.DataSource = dt;
            this.treePosPair.RefreshDataSource();
        }
        private void button1_Click(object sender, System.EventArgs e)
        {
            DataTable gridDataTable = this.sfDataGrid.DataSource as DataTable;

            if (gridDataTable == null || this.sfDataGrid.View == null)
            {
                return;
            }

            // Creates a new row.
            System.Data.DataRow addNewRow = sfDataGrid.View.AddNew() as System.Data.DataRow;

            // Commits the newly created row.
            sfDataGrid.View.CommitNew();

            // Initialize the values of first row to the newly added row.
            addNewRow.SetField(0, gridDataTable.Rows[0][0]);
            addNewRow.SetField(1, gridDataTable.Rows[0][1]);
            addNewRow.SetField(2, gridDataTable.Rows[0][2]);
            addNewRow.SetField(3, gridDataTable.Rows[0][3]);
            addNewRow.SetField(4, gridDataTable.Rows[0][4]);
        }
Exemplo n.º 4
0
        //function adding data to sql table
        public void SqlTableAdd()
        {
            System.Data.DataRow[] foundRows;
            String Strtofind;

            if (textBox1.Text == "" ||
                textBox2.Text == "" ||
                textBox3.Text == "" ||
                textBox4.Text == "" ||
                textBox5.Text == "" ||
                textBox6.Text == "" ||
                textBox7.Text == "" ||
                textBox8.Text == "" ||
                textBox9.Text == "" ||
                textBox10.Text == "" ||
                textBox11.Text == "" ||
                textBox12.Text == "" ||
                textBox13.Text == "" ||
                textBox14.Text == "" ||
                textBox17.Text == "")
            {
                System.Windows.Forms.MessageBox.Show("Incomplete Information, Try Again !!");
                return;
            }

            Strtofind = "PartnerID =" + textBox1.Text;
            foundRows = ds.Tables["AwarObjSqlTable"].Select(Strtofind);
            if (foundRows.Length == 0)
            {
                //its a new record, we should be able to add
                System.Data.DataRow NewRow = ds.Tables["AwarObjSqlTable"].NewRow();
                //Next line is needed so we can update the database
                System.Data.OleDb.OleDbCommandBuilder Cb = new System.Data.OleDb.OleDbCommandBuilder(da);
                //NewRow.SetField<int>("PartnerID", Convert.ToInt32(textBox1.Text));
                //NewRow.SetField<String>("PartnetType", textBox2.Text);
                //NewRow.SetField<String>("Name", textBox3.Text);
                //NewRow.SetField<String>("Phone", textBox4.Text);
                //NewRow.SetField<String>("AlternativePhone", textBox5.Text);
                //NewRow.SetField<String>("FaxNumber", textBox6.Text);
                //NewRow.SetField<String>("Email", textBox7.Text);
                //NewRow.SetField<String>("AlternativeEmail", textBox8.Text);
                //NewRow.SetField<String>("SuiteNumber", textBox9.Text);
                //NewRow.SetField<String>("StreetNumber", textBox10.Text);
                //NewRow.SetField<String>("StreetName", textBox11.Text);
                //NewRow.SetField<String>("City", textBox12.Text);
                //NewRow.SetField<String>("Province", textBox13.Text);
                //NewRow.SetField<String>("PostalCode", textBox14.Text);

                SaveinSqlTable();
                NewRow.SetField <Int16>("WhichDB", Convert.ToInt16(textBox17.Text));
                ds.Tables["AwarObjSqlTable"].Rows.Add(NewRow);
                //da.UpdateCommand = Cb.GetUpdateCommand();
                da.Update(ds, "AwarObjSqlTable");
                //da.AcceptChangesDuringUpdate = true;
                //ds.AcceptChanges();
                RecordCount = RecordCount + 1;
                //Adding a record for starting Credit Balance
                //On Transaction

                System.Windows.Forms.MessageBox.Show("Record Added Succesfully");
                //sending an email
            }
            else
            {
                System.Windows.Forms.MessageBox.Show("Duplicate ID, try Again!!!");
                return;
            }
        }
Exemplo n.º 5
0
        private void frmColumnSorting_Load(object sender, EventArgs e)
        {
            ds_ViewColumns = obj_bllFormCustomization.LoadDefaultColumnsSorting();

            for (int i = 0; i <= ds_TakeQryData.Tables[0].Columns.Count - 1; i++)
            {
                dr_ViewColumn = ds_ViewColumns.Tables[0].NewRow();
                //dr_ViewColumn = new DataRow();

                dr_ViewColumn.SetField("Column Name", ds_TakeQryData.Tables[0].Columns[i].Caption.ToString());
                dr_ViewColumn.SetField("ASC", 0);
                dr_ViewColumn.SetField("DESC", 0);

                ds_ViewColumns.Tables[0].Rows.Add(dr_ViewColumn);
                ds_ViewColumns.AcceptChanges();
            }
            gridView1.GridControl.DataSource = ds_ViewColumns.Tables[0];

            foreach (GridColumn column in gridView1.Columns) // disable editing for all columns
            {
                if (column.AbsoluteIndex == 0)
                {
                    column.OptionsColumn.AllowEdit = false;
                }
                //column.OptionsColumn.AllowEdit = false;
            }
            gridView1.BestFitColumns(true);
            for (int i = 0; i <= gridView1.Columns.Count - 1; i++)
            {
                gridView1.Columns[i].BestFit();
            }
        }
Exemplo n.º 6
0
 private void calcExtraColumns(DataRow row)
 {
     // For some reason, if the file was selected from the ComboBox,
     // then the FileNumber text was not displayed if it was bound
     // to the expression column expr_FileNumber.
     // So, I'm making it much more explicit here.
     if (row == null)
     return;
     int fileid = row.Field<int>("FileID");
     var file = fileDropTable.FindByFileID(fileid);
     string filenum = file == null ? "" : file.FileNumber;
     row.SetField<String>("extra_FileNumber", filenum);
 }
Exemplo n.º 7
0
 /// <summary>
 /// 将合同信息加入行中
 /// </summary>
 /// <param name="row"></param>
 /// <param name="con"></param>
 /// <returns></returns>
 public static DataRow getRowFromContract(DataRow row, Contract con)
 {
     row.SetField(0, con.proCate);
     row.SetField(1, con.proName);
     row.SetField(2, con.proId);
     row.SetField(3, con.unicomLinkMan);
     row.SetField(4, con.linkPhone);
     row.SetField(5, con.groupCusManager);
     row.SetField(6, con.proSignUnitName);
     row.SetField(7, con.unitAdd);
     row.SetField(8, con.proSign);
     row.SetField(9, con.signUnitLinkMan);
     row.SetField(10, con.signUnitLinkPhone);
     row.SetField(11, con.payPhone); ;
     row.SetField(12, con.payStand);
     row.SetField(13, con.proSignDate);
     row.SetField(14, con.proSignExeDate);
     row.SetField(15, con.proDeadLine);
     row.SetField(16, con.proExpireData);
     row.SetField(17, con.proDesc);
     row.SetField(18, con.remark);
     row.SetField(19, con.dltdh);
     row.SetField(20, con.fileName);
     return row;
 }
Exemplo n.º 8
0
 private void ReadStringField(int colIndex, ColumnMeta meta, DataRow dataRow, BinaryReader br)
 {
     if (m_dbreader is WDBReader)
         dataRow.SetField(colIndex, br.ReadStringNull());
     else if (m_dbreader is STLReader)
     {
         int offset = br.ReadInt32();
         dataRow.SetField(colIndex, (m_dbreader as STLReader).ReadString(offset));
     }
     else
     {
         try
         {
             dataRow.SetField(colIndex, m_dbreader.IsSparseTable ? br.ReadStringNull() : m_dbreader.StringTable[br.ReadInt32(meta)]);
         }
         catch
         {
             dataRow.SetField(colIndex, "Invalid string index!");
         }
     }
 }
Exemplo n.º 9
0
        private void btnedtSou_TextChanged(object sender, EventArgs e)
        {
            if (btnedtSou.Text == "")
            {
                return;
            }
            string[] sPosPairs = System.IO.File.ReadAllLines(btnedtSou.Text);
            if (sPosPairs == null || sPosPairs.Length == 0)
            {
                MessageBox.Show("请选择正确的文件");
                return;
            }
            int startIndex = 0;

            if (chkBegin2.Checked)
            {
                startIndex = 1;
            }
            if (sPosPairs.Length <= startIndex)
            {
                MessageBox.Show("请选择正确的文件");
                return;
            }
            int       ixh = GetMaxXH() + 1;
            DataTable dt = this.treePosPair.DataSource as DataTable;
            double    soux, souy, souz, tarx, tary, tarz;
            int       errCount = 0;

            for (int i = startIndex; i < sPosPairs.Length; i++)
            {
                souz = 0;
                tarz = 0;
                try
                {
                    string[] parts = sPosPairs[i].Split(',');
                    soux = Convert.ToDouble(parts[1]);
                    souy = Convert.ToDouble(parts[2]);
                    if (chkHavZ.Checked)
                    {
                        souz = Convert.ToDouble(parts[3]);
                        tarx = Convert.ToDouble(parts[4]);
                        tary = Convert.ToDouble(parts[5]);
                        tarz = Convert.ToDouble(parts[6]);
                    }
                    else
                    {
                        tarx = Convert.ToDouble(parts[3]);
                        tary = Convert.ToDouble(parts[4]);
                    }
                }
                catch
                {
                    errCount++;
                    continue;
                }
                System.Data.DataRow row = dt.NewRow();
                row.SetField("I_XH", ixh++);
                row.SetField("WKID", this._wkid);
                row.SetField("SOU_X", soux);
                row.SetField("SOU_Y", souy);
                row.SetField("SOU_Z", souz);
                row.SetField("TAR_X", tarx);
                row.SetField("TAR_Y", tary);
                row.SetField("TAR_Z", tarz);
                dt.Rows.Add(row);
            }
            if (errCount == 0 || DialogResult.OK == MessageBox.Show(string.Format("总计{0}条记录,其中无效记录{1}条,\r\n是否继续添加?点击“OK”,则继续添加,否则不添加。", sPosPairs.Length - startIndex, errCount), "提示", MessageBoxButtons.OKCancel))
            {
                this.treePosPair.DataSource = dt;
                this.treePosPair.RefreshDataSource();
            }
            else
            {
                this.btnedtSou.Text = "";
            }
        }