private void addaudit(string KeyIdName, string tableName, string tableKeyId, string tableDesc) { if (roleAuditingManager.IsNeedAuditByTableName(tableName)) { // Model.RoleAuditing roleAuditing = this.roleAuditingManager.SelectByInvoiceIdAndTable(invoice.InvoiceId, tableName); //if ( isUpdate == 0) //代表 添加 if (this.action == "insert") { Model.RoleAuditing roleAuditing = new Book.Model.RoleAuditing(); roleAuditing.RoleAuditingId = Guid.NewGuid().ToString(); roleAuditing.AuditRank = 0; roleAuditing.NextAuditRole = new BL.RoleManager().select_byAuditRandTableName(1, tableName); if (roleAuditing.NextAuditRole != null) { roleAuditing.NextAuditRoleId = roleAuditing.NextAuditRole.RoleId; } roleAuditing.AuditState = (int)global::Helper.InvoiceAudit.WaitAudit; roleAuditing.Employee0Id = BL.V.ActiveOperator.EmployeeId; roleAuditing.InsertTime = DateTime.Now; roleAuditing.InvoiceId = tableKeyId; roleAuditing.InvoiceName = new BL.OperationManager().GetOperationNamebyTabel(tableName);; roleAuditing.TableName = tableName; this.roleAuditingManager.Insert(roleAuditing); } if (this.action == "update") { if (AuditState() == 4) { Model.RoleAuditing roleAuditing = this.roleAuditingManager.SelectByInvoiceIdAndTable(tableKeyId, tableName); roleAuditing.AuditRank = 0; roleAuditing.NextAuditRole = new BL.RoleManager().select_byAuditRandTableName(1, tableName); if (roleAuditing.NextAuditRole != null) { roleAuditing.NextAuditRoleId = roleAuditing.NextAuditRole.RoleId; } roleAuditing.AuditState = (int)global::Helper.InvoiceAudit.WaitAudit; roleAuditing.Employee0Id = BL.V.ActiveOperator.EmployeeId; this.roleAuditingManager.Update(roleAuditing); } } string sql = "update " + tableName + " set AuditState= " + (int)global::Helper.InvoiceAudit.WaitAudit + " where " + KeyIdName + "='" + tableKeyId + "'"; new BL.InvoiceXJManager().UpdateSql(sql); } }
public void Insert(Model.Invoice invoice) { _ValidateForInsert(invoice); //MethodInfo methodinfo = this.GetType().GetMethod("HasRows", new Type[] { typeof(string) }); //bool f = (bool)methodinfo.Invoke(this, new object[] { invoice.InvoiceId }); //if (f) //{ // throw new Helper.InvalidValueException(Model.Invoice.PROPERTY_INVOICEID); //} try { V.BeginTransaction(); invoice.InsertTime = DateTime.Now; TiGuiExists(invoice); string tableName = this.GetType().Name.Substring(0, this.GetType().Name.IndexOf("Manager")); if (roleAuditingManager.IsNeedAuditByTableName(tableName)) { // Model.RoleAuditing roleAuditing = this.roleAuditingManager.SelectByInvoiceIdAndTable(invoice.InvoiceId, tableName); //if ( isUpdate == 0) //代表 添加 { invoice.AuditState = (int)global::Helper.InvoiceAudit.WaitAudit; Model.RoleAuditing roleAuditing = new Book.Model.RoleAuditing(); roleAuditing.RoleAuditingId = Guid.NewGuid().ToString(); roleAuditing.AuditRank = 0; roleAuditing.NextAuditRole = new BL.RoleManager().select_byAuditRandTableName(1, tableName); if (roleAuditing.NextAuditRole != null) { roleAuditing.NextAuditRoleId = roleAuditing.NextAuditRole.RoleId; } roleAuditing.AuditState = (int)global::Helper.InvoiceAudit.WaitAudit; roleAuditing.Employee0Id = V.ActiveOperator.EmployeeId; roleAuditing.InsertTime = DateTime.Now; roleAuditing.InvoiceId = invoice.InvoiceId; roleAuditing.InvoiceName = new OperationManager().GetOperationNamebyTabel(tableName); roleAuditing.TableName = tableName; this.roleAuditingManager.Insert(roleAuditing); } } else { invoice.AuditState = (int)global::Helper.InvoiceAudit.NoUsing; } _Insert(invoice); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, invoice.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, invoice.InsertTime.Value.Year, invoice.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, invoice.InsertTime.Value.ToString("yyyy-MM-dd")); string sequencekey = string.Format(invoiceKind); SequenceManager.Increment(sequencekey_y); SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); SequenceManager.Increment(sequencekey); V.CommitTransaction(); } catch { V.RollbackTransaction(); throw; } }
private void ClickSave(int flagAut, string KeyIdName, string tableName, string tableKeyId) { try { bool checkwf = false; //if (this.action == "insert") //{ // Workflowinsert wfinsert = new Workflowinsert(); // if (!string.IsNullOrEmpty(this.tableCode())) // { // checkwf = wfinsert.Checkwfbytablescode(this.tableCode().Substring(0, this.tableCode().IndexOf(','))); // if (checkwf) // saveAuditState = (int)global::Helper.InvoiceAudit.WaitAudit; // } //} saveAuditState = (int)global::Helper.InvoiceAudit.NoUsing; this.Save(); //MessageBox.Show("fdafda"); if (flagAut == 1 && roleAuditingManager.IsNeedAuditByTableName(tableName)) { // Model.RoleAuditing roleAuditing = this.roleAuditingManager.SelectByInvoiceIdAndTable(invoice.InvoiceId, tableName); //if ( isUpdate == 0) //代表 添加 if (this.action == "insert") { Model.RoleAuditing roleAuditing = new Book.Model.RoleAuditing(); roleAuditing.RoleAuditingId = Guid.NewGuid().ToString(); roleAuditing.AuditRank = 0; roleAuditing.NextAuditRole = new BL.RoleManager().select_byAuditRandTableName(1, tableName); if (roleAuditing.NextAuditRole != null) { roleAuditing.NextAuditRoleId = roleAuditing.NextAuditRole.RoleId; } roleAuditing.AuditState = (int)global::Helper.InvoiceAudit.WaitAudit; roleAuditing.Employee0Id = BL.V.ActiveOperator.EmployeeId; roleAuditing.InsertTime = DateTime.Now; roleAuditing.InvoiceId = tableKeyId; roleAuditing.InvoiceName = new BL.OperationManager().GetOperationNamebyTabel(tableName);; roleAuditing.TableName = tableName; this.roleAuditingManager.Insert(roleAuditing); } if (this.action == "update") { if (AuditState() == 4) { Model.RoleAuditing roleAuditing = this.roleAuditingManager.SelectByInvoiceIdAndTable(tableKeyId, tableName); roleAuditing.AuditRank = 0; roleAuditing.NextAuditRole = new BL.RoleManager().select_byAuditRandTableName(1, tableName); if (roleAuditing.NextAuditRole != null) { roleAuditing.NextAuditRoleId = roleAuditing.NextAuditRole.RoleId; } roleAuditing.AuditState = (int)global::Helper.InvoiceAudit.WaitAudit; roleAuditing.Employee0Id = BL.V.ActiveOperator.EmployeeId; this.roleAuditingManager.Update(roleAuditing); } } string sql = "update " + tableName + " set AuditState= " + (int)global::Helper.InvoiceAudit.WaitAudit + " where " + KeyIdName + "='" + tableKeyId + "'"; new BL.AcademicBackGroundManager().UpdateSqlMap(sql); } //catch (Exception ex) //{ // BL.V.RollbackTransaction(); // throw ex; //} this.action = "view"; this.Refresh(); } catch (Helper.MessageValueException ex) { if (!string.IsNullOrEmpty(ex.Message) && !ex.Message.Equals("SaveCancel", StringComparison.InvariantCultureIgnoreCase)) { MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } return; } catch (Helper.RequireValueException ex) { if (this.requireValueExceptions.ContainsKey(ex.Message)) { AA aa = this.requireValueExceptions[ex.Message]; MessageBox.Show(aa.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); aa.Control.Focus(); return; } throw; } catch (Helper.InvalidValueException ex) { if (this.invalidValueExceptions.ContainsKey(ex.Message)) { AA aa = this.invalidValueExceptions[ex.Message]; MessageBox.Show(aa.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); aa.Control.Focus(); return; } throw; } catch (Helper.ViolateConstraintException ex) { MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } catch (Helper.VersionOverTimeException) { MessageBox.Show(Properties.Resources.ObjectHasChange, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.action = "view"; this.Refresh(); return; } catch (Exception ex) { MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } MessageBox.Show(Properties.Resources.SuccessfullySaved, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; }