예제 #1
0
파일: editpro.cs 프로젝트: rzguo/fpNew
        /// <summary>
        /// 项目编辑
        /// </summary>
        private void 编辑EToolStripMenuItem_Click(object sender, EventArgs e)
        {
            // 录入准备
            prepareForEdit(true, false, null, true, false, false, false, false, false, false, false, editType.editPro, "项目信息");

            #region 建立表格样式
            dgv_editpro.Columns.Add("proInfo", "项目信息");
            dgv_editpro.Columns.Add("content", "内容");
            dgv_editpro.Columns[0].DefaultCellStyle = new DataGridViewCellStyle() { BackColor = Color.Gray };
            dgv_editpro.Columns[0].ReadOnly = true;
            dgv_editpro.Columns[0].Width = 150;
            dgv_editpro.Columns[1].Width = 500;
            dgv_editpro.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
            dgv_editpro.Columns[1].SortMode = DataGridViewColumnSortMode.NotSortable;
            //添加行
            dgv_editpro.Rows.Add(7);
            setCell(0, 0, "坐标系统(国际ID)");
            setCell(1, 0, "地址");
            setCell(2, 0, "委托单位");
            setCell(3, 0, "地质基本情况");
            setCell(4, 0, "设计基本情况");
            setCell(5, 0, "备注");
            setCell(6, 0, "监测点位布置图");
            setCell(6, 1, "双击编辑点位图");
            dgv_editpro.Rows[6].Cells[1].ReadOnly = true;
            dgv_editpro.Rows[6].Cells[1].Style = new DataGridViewCellStyle() { BackColor = Color.Silver };
            #endregion

            #region 读出数据
            try
            {
                login.conn.Open();
                //先读出除图片外的数据
                SqlDataAdapter sda = new SqlDataAdapter("select coord,address,firstParty,geology,design,remark from fpPros where ID='" + proID + "'", login.conn);
                DataTable dt = new DataTable();
                sda.Fill(dt);
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    setCell(i, 1, dt.Rows[0][i]);
                }
            }
            catch (Exception exc) { throw exc; }
            finally
            {
                login.conn.Close();
            }
            #endregion

            #region 设定双击单元格事件
            CellDoubleClick += (object o, DataGridViewCellEventArgs ea) =>
            {
                if (ea.ColumnIndex == 1 && ea.RowIndex == 6)
                {
                    //双击图片单元格后读出image并传递到photoViewer
                    photoViewer pv = new photoViewer();
                    pv.proID = proID;
                    pv.Show();
                }
            };
            #endregion

            #region 设定保存事件
            save += (object o, EventArgs ea) =>
            {
                if (isSave) return;
                try
                {
                    //从表中读取数据
                    string[] content = new string[6];
                    for (int i = 0; i < content.Length; i++)
                    {
                        content[i] = dgv_editpro.Rows[i].Cells[1].Value.ToString();
                    }
                    //保存数据
                    login.conn.Open();
                    SqlCommand sc = new SqlCommand("update fpPros set coord='" + content[0] + "',address='" + content[1] + "',firstParty='" + content[2] + "',geology='" + content[3] + "',design='" + content[4] + "',remark='" + content[5] + "' where ID='" + proID + "'", login.conn);
                    sc.ExecuteNonQuery();
                    setSaveState(true);
                    //刷新视图
                    //login.conn.Close();
                    //编辑EToolStripMenuItem_Click(sender, e);
                }
                catch (Exception exc) { throw exc; }
                finally
                {
                    login.conn.Close();
                }
            };
            #endregion
        }
예제 #2
0
파일: addpro.cs 프로젝트: rzguo/fpNew
 /// <summary>
 /// 点击了图片地址
 /// </summary>
 private void lb_addpro_photoUrl_Click(object sender, EventArgs e)
 {
     if (photoUrl != null && photoUrl != "")
     {
         photoViewer pv = new photoViewer();
         pv.photoUrl = photoUrl;
         pv.Show();
     }
 }