private void b_ok_Click(object sender, EventArgs e) { ldt.Rows[0]["StoreType"] = (r_database2file.Checked ? "1" : (r_file2file.Checked ? "2" : "3")); ldt.Rows[0]["GetType"] = (r_fromtable.Checked ? "1" : "2"); ldt.Rows[0]["TableName"] = TableName.Text; ldt.Rows[0]["XH"] = XH.Text; ldt.Rows[0]["ZP"] = ZP.Text; ldt.Rows[0]["XHSQL"] = XHSQL.Text; ldt.Rows[0]["ZPSQL"] = ZPSQL.Text; ldt.Rows[0]["FROMSQL"] = FROMSQL.Text; ldt.Rows[0]["WHERESQL"] = WHERESQL.Text; //ldt.Rows[0]["db_name"] = (rbBs.Checked ? "bs" : "scm"); //ldt.Rows[0]["db_position"] = (cbPosition.Checked ? "0" : "1"); if (r_database2file.Checked) { ldt.Rows[0]["Compress"] = r_enable.Checked ? "1" : "0"; ldt.Rows[0]["CompressRate"] = CompressRate.Value; ldt.Rows[0]["BsPath"] = BsPath.Text; ldt.Rows[0]["OUR_XH"] = OurXh.Text; ldt.Rows[0]["ZPIsPath"] = cbZpIsPath.Checked ? "1" : "0"; } else if (r_file2file.Checked) { ldt.Rows[0]["Compress"] = r_enable1.Checked ? "1" : "0"; ldt.Rows[0]["CompressRate"] = CompressRate1.Value; ldt.Rows[0]["BsPath"] = BsPath1.Text; ldt.Rows[0]["OUR_XH"] = OurXh2.Text; } else if (r_file2database.Checked) { ldt.Rows[0]["TableName"] = tbTableName.Text; ldt.Rows[0]["XH"] = tbXH.Text; ldt.Rows[0]["ZP"] = tbZP.Text; ldt.Rows[0]["BsPath"] = tbFilePath.Text; } ldt.Rows[0]["width"] = nudWidth.Value; ldt.Rows[0]["height"] = nudHeight.Value; ldt.Rows[0]["FileToXHType"] = r_XH.Checked ? "0" : "1"; ldt.Rows[0]["PhotoNumbers"] = PhotoNumbers.Text; ldt.Rows[0]["TheirPhotoPath"] = TheirPhotoPath.Text; ldt.Rows[0]["StartPos"] = StartPos.Text; ldt.Rows[0]["EndPos"] = EndPos.Text; string ls_sql = "SELECT *" + " FROM IF_PHOTO where serial = 1"; AccessDBop.SQLExecute("delete from IF_Task where Task_id = '10000000000000'"); AccessDBop.SQLExecute("insert into IF_Task(Task_id,Task_Name,direction,IncrementInsert) values('10000000000000','" + t_taskname.Text + "','0','N')"); if (AccessDBop.SQLUpdate(ls_sql, ref ldt)) { MessageBox.Show("保存成功"); DialogResult = DialogResult.OK; } else { MessageBox.Show("保存失败"); } }
private void b_close_Click(object sender, EventArgs e) { string ls_sql = "SELECT id,Task_id, Task_Name, TheirTableName,TheirSql, OurTableName, OurTable_desc, OurSql,interfaceDesc,direction,IncrementInsert ,DeleteNotDrop,DropTable,GroupSql ,GroupField " + " FROM IF_Task Where Task_id ='" + t_task.Text + "'"; foreach (DataRow dr in gd_dt.Rows) { dr.SetAdded(); } string ls_sql1 = "delete FROM IF_Task Where Task_id ='" + t_task.Text + "'"; if (AccessDBop.SQLExecute(ls_sql1)) { if (!AccessDBop.SQLUpdate(ls_sql, ref gd_dt)) { MessageBox.Show("取消更新时出错!"); return; } } DialogResult = DialogResult.Cancel; }
private void b_save_Click(object sender, EventArgs e) { bool NeedTable = false; bool NeedField = false; bool NeedChecked = false; string NeedTableName = ""; //SetDGVColumn_Direction(1); DataTable ldt1 = (DataTable)dgv_task.DataSource; foreach (DataRow ldr in ldt1.Rows) { if (ldr.RowState != DataRowState.Deleted) { if (ldr["TheirTableName"].ToString() == "") { NeedTable = true; } if (ldr["interfaceDesc"].ToString() == "") { //如果是exe方式取数据,则不需要配置规则 if (!ldr["TheirTableName"].ToString().Contains(".exe")) { NeedField = true; NeedTableName = ldr["TheirTableName"].ToString(); break; } } if ( (ldr["IncrementInsert"].ToString().ToLower() == "n") && (ldr["DeleteNotDrop"].ToString().ToLower() == "n") && (ldr["DropTable"].ToString().ToLower() == "n") ) { NeedChecked = true; break; } ldr["Task_id"] = t_task.Text; ldr["Task_Name"] = t_taskname.Text; string sTemp = "导入" + Project.DB_Alias; ldr["direction"] = ldr["direction"].ToString() == sTemp ? "0" : "1"; } } if (NeedTable) { MessageBox.Show("请完全输入对方表名"); return; } if (NeedField) { MessageBox.Show("对方表[" + NeedTableName + "]未配置导入规则"); return; } if (NeedChecked) { MessageBox.Show("未进行选择数据导入方式!"); return; } string ls_sql = "SELECT id,Task_id, Task_Name, TheirTableName,TheirSql, OurTableName, OurTable_desc, OurSql,interfaceDesc,direction,IncrementInsert ,DeleteNotDrop,DropTable,GroupSql ,GroupField " + " FROM IF_Task Where Task_id ='" + t_task.Text + "'";; if (!AccessDBop.SQLUpdate(ls_sql, ref ldt1)) { MessageBox.Show("更新列时出错!"); return; } //else //{ MessageBox.Show("更新成功!"); } DialogResult = DialogResult.OK; }
private void b_ok_Click(object sender, EventArgs e) { if (tb_TableName.Text == "") { MessageBox.Show("请输入表名!"); return; } if (ucbTablePosition.Text == "") { MessageBox.Show("请选择表位置!"); return; } string ls_sql = ""; string ls_CompareTableName = (_TableType == "Z" ? "" : (cb_CompareTable.SelectedValue == null ? "" : cb_CompareTable.SelectedValue.ToString())); if (_TableName == "") { ls_sql = "INSERT INTO IF_Table_infor(Table_Name,Table_desc, Table_Type, CompareTableName,table_position) " + "VALUES ('{0}','{1}','" + _TableType + "','" + ls_CompareTableName + "','{2}')"; } else { ls_sql = "UPDATE IF_Table_infor Set Table_Name='{0}', Table_desc = '{1}', CompareTableName = '" + ls_CompareTableName + "',table_position='{2}' " + "Where Table_Name='" + _TableName + "' and Table_Type = '" + _TableType + "'"; } string sPosition = ucbTablePosition.Text == Project.DB_Alias ? "0" : "1"; ls_sql = String.Format(ls_sql, new object[] { tb_TableName.Text, tb_TableDesc.Text, sPosition }); _TableName = tb_TableName.Text; if (AccessDBop.SQLExecute(ls_sql)) { ls_sql = "SELECT Table_Name, Field_Name, Field_Desc, " + "Field_Type, IsPK, CanNull,ShowIndex,IsIdentity " + " FROM IF_field_infor " + " Where Table_Name ='" + _TableName + "'"; DataTable ldt1 = (DataTable)dgv_columns.DataSource; int k = 0; foreach (DataRow ldr in ldt1.Rows) { if (ldr.RowState != DataRowState.Deleted) { if (ldr["Field_Name"] == null || ldr["Field_Name"].ToString() == "") { MessageBox.Show("请输入列名!"); return; } if (ldr["Field_Type"] == null || ldr["Field_Type"].ToString() == "") { MessageBox.Show("请输入列类型!"); return; } ldr[0] = tb_TableName.Text; if (ldr["IsPK"] == null || ldr["IsPK"].ToString().Trim() == "") { ldr["IsPK"] = "N"; } if (ldr["CanNull"] == null || ldr["CanNull"].ToString().Trim() == "") { ldr["CanNull"] = "N"; } if (ldr["IsIdentity"] == null || ldr["IsIdentity"].ToString().Trim() == "") { ldr["IsIdentity"] = "N"; } ldr["ShowIndex"] = k++; } } bool updateFlag = !AccessDBop.SQLUpdate(ls_sql, ref ldt1); string db_type = ucbTablePosition.Text == Project.DB_Alias ? Project.DB_Type : Project.TheirDB_Type; string CreaateTableSQL = DataBaseManager.GetCreateTableSQL(_TableName, db_type); if (updateFlag || (CreaateTableSQL.Equals("") || CreaateTableSQL.Equals("error") ? false : !AccessDBop.SQLExecute("update IF_Table_infor set CreateTable='" + CreaateTableSQL.Replace("'", "''") + "' Where Table_Name='" + _TableName + "'"))) { MessageBox.Show("更新列时出错!"); return; } else { MessageBox.Show("更新列成功!"); } } else { MessageBox.Show("更新表时出错!"); return; } DialogResult = DialogResult.OK; }