Beispiel #1
0
        private FC_H_QSDC CreateFC_H_QSDC(DataGridViewRow row)
        {
            FC_H_QSDC h = new FC_H_QSDC();

            h.LSZTYBM = null == row.Cells["BuildingInfo_id"].Value ? null : row.Cells["BuildingInfo_id"].Value.ToString();
            h.TSTYBM= null == row.Cells["HouseInfo_id"].Value ? null : row.Cells["HouseInfo_id"].Value.ToString();
            h.DYH = null==row.Cells["H_CeCode"].Value ? null : row.Cells["H_CeCode"].Value.ToString();
            h.FJH= null == row.Cells["H_RoNum"].Value ? null : row.Cells["H_RoNum"].Value.ToString();
            h.GHYT = ConvertToGHYT(row.Cells["H_HoUse"]);
            h.JZMJ = GetJZMJ(row.Cells["H_ConAcre"]);
            h.ZL = GetZL(row.Cells["I_Dist"], row.Cells["I_ItSite"], row.Cells["I_ItName"], row.Cells["BuName"], row.Cells["H_CeCode"], row.Cells["H_RoNum"]);

            return h;


        }
Beispiel #2
0
        private void InsertIntoBDC(FC_H_QSDC h)
        {
            try
            {
                DbHelper.Conn = new Oracle.DataAccess.Client.OracleConnection(SXK);
                DbHelper.SetProvider(MyDBType.Oracle);
                string sql = DbHelper.CreateInsertStr<FC_H_QSDC>(h, "FC_H_QSDC", MyDBType.Oracle);
                sql = sql.Trim().Replace("\r\n", "");
                DbParameter[] param = DbHelper.GetParamArray<FC_H_QSDC>(h, MyDBType.Oracle);

                DbHelper.ExecuteNonQuery(DbHelper.Conn, System.Data.CommandType.Text, sql, param);
            }
            catch(Exception ex)
            {
                throw ex;
            }
            finally { DbHelper.CloseConn(); }
        }
Beispiel #3
0
 private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
 {
     if(DialogResult.Yes==MessageBox.Show("是否导入?","提示",MessageBoxButtons.YesNo))
     {
         int index = e.RowIndex;
         if ((null != dataGridView1.Rows[index].Cells[1].Value && dataGridView1.Rows[index].Cells[1].Value.ToString() == "1") || (null != dataGridView1.Rows[index].Cells[2].Value && dataGridView1.Rows[index].Cells[2].Value.ToString() == "1"))
         {
             MessageBox.Show("禁止操作");
         }
         else
         {
             DataGridViewRow row = dataGridView1.Rows[index];
             FC_H_QSDC h = CreateFC_H_QSDC(row);
             InsertIntoBDC(h);
             MessageBox.Show("导入成功!");
         }
         
     }
 }
Beispiel #4
0
 private Oracle.DataAccess.Client.OracleParameter[] GetParams(FC_H_QSDC fc_dyxx)
 {
     return DbHelper.GetParamArray<FC_H_QSDC>(fc_dyxx);
 }