private int SaveData() { if (VerificationText()) { return(0); } if (GeneralHelpler.ConfirmQuestionOperate("确定保存修改?") == DialogResult.Cancel) { return(0); } var drow = bindingSource1.Current; if (drow != null) { var row = ((DataRowView)drow).Row; row.EndEdit(); var entity = row.ToObjectSafe <AzMetaCustomCloumEntity>(); int result = 0; if (IsNew) { result = AzMetaCustomCloumHandle.Handle().Insert(entity).Id; IsNew = false; } else { result = AzMetaCustomCloumHandle.Handle().Update(entity); } if (result > 0) { row.AcceptChanges(); return(1); } } return(1); }
private void tspBtnSave_Click(object sender, System.EventArgs e) { if (GeneralHelpler.ConfirmQuestionOperate("确定保存当前所有修改吗?") == DialogResult.Cancel) { return; } azMetaCustomCloumListEntityBindingSource.EndEdit(); dataGridView1.EndEdit(); var vlist = (azMetaCustomCloumListEntityBindingSource.DataSource as DataTable).GetChanges(); if (vlist == null) { return; } foreach (DataRow item in vlist.Rows) { var entity = item.ToObjectSafe <AzMetaCustomCloumEntity>(); AzMetaCustomCloumHandle.Handle().UpdateBatch(entity); } vlist.AcceptChanges(); (azMetaCustomCloumListEntityBindingSource.DataSource as DataTable).AcceptChanges(); ButtonAction(); }
public static void ShowAzCustomColumsEdit(BindingSource dataSource, string tablename = "", bool isNew = false) { AzCustomColumsEdit customColumsEdit = new AzCustomColumsEdit(); if (isNew) { var row = (dataSource.DataSource as DataTable).NewRow(); var c = AzMetaCustomCloumHandle.Handle().NewAdd(tablename); DataTable data = Translator.Translate <AzMetaProfile, AzMetaCustomCloumEntity>(c, "AtkMetaCustomCloum"); row.ItemArray = data.AsEnumerable().FirstOrDefault().ItemArray; (dataSource.DataSource as DataTable).Rows.Add(row); dataSource.MoveLast(); customColumsEdit.IsNew = true; } customColumsEdit.bindingSource1 = dataSource; customColumsEdit.textFldName.DataBindings.Add("Text", dataSource, "FldName", true); customColumsEdit.cboBoxFldCodeType.DataBindings.Add("Text", dataSource, "FldCodeType", true); customColumsEdit.cboBoxFldType.DataBindings.Add("Text", dataSource, "FldType", true); customColumsEdit.textFldDisplay.DataBindings.Add("Text", dataSource, "FldDisplay", true); customColumsEdit.textFldLen.DataBindings.Add("Text", dataSource, "FldLen", true); customColumsEdit.ckBoxIsIdentity.DataBindings.Add("Checked", dataSource, "IsIdentity", true); customColumsEdit.ckBoxIsKeyField.DataBindings.Add("Checked", dataSource, "IsKeyField", true); customColumsEdit.ckBoxIsNullable.DataBindings.Add("Checked", dataSource, "IsNullable", true); customColumsEdit.ShowDialog(); }
private void tspClearAll_Click(object sender, System.EventArgs e) { if (GeneralHelpler.ConfirmQuestionOperate("确定清除所有行吗?") == DialogResult.Cancel) { return; } AzMetaCustomCloumHandle.Handle().DeleteAll(currentSelectObjModeName); LoadMataColum(currentschemaFrom); }
private void tspButtonImport_Click(object sender, System.EventArgs e) { if (GeneralHelpler.ConfirmQuestionOperate("确定导入元数据吗?") == DialogResult.Cancel) { return; } var azMetaTable = azMetaTableEntities.AsQueryable().Where(m => m.ObjModeName == currentSelectObjModeName).FirstOrDefault(); if (azMetaTable != null) { var listcol = AzMetaCustomCloumHandle.Handle().Select().Where(m => m.TableName == azMetaTable.SchemaFrom).Go(); MetadataOperate.ImportCustomMetaData(azMetaTable.SchemaFrom, azMetaTable.SchemaName, listcol.Count() == 0); LoadMataColum(azMetaTable.SchemaFrom); // tspButtonImport.Enabled = false; } }
private void tspMenuItemTurn_Click(object sender, EventArgs e) { if (GeneralHelpler.ConfirmQuestionOperate("确定根据DB数据类型初始代码数据类型吗?") == DialogResult.Cancel) { return; } var listcol = AzMetaCustomCloumHandle.Handle().Select().Where(t => t.TableName == currentObject.SchemaName).Go(); foreach (var item in listcol) { var entitype = MetaDataTypeHandle.GetMetaDataType(item.FldType); item.FldCodeType = entitype.CodeType; AzMetaCustomCloumHandle.Handle().Update(item); } LoadMataColum(); }
private void tspBtnDelete_Click(object sender, System.EventArgs e) { if (GeneralHelpler.ConfirmQuestionOperate("确定删除当前所选行吗?") == DialogResult.Cancel) { return; } var drow = azMetaCustomCloumListEntityBindingSource.Current; if (drow != null) { var row = ((DataRowView)drow).Row; var entity = row.ToObjectSafe <AzMetaCustomCloumEntity>(); if (AzMetaCustomCloumHandle.Handle().Delete(entity) == 1) { azMetaCustomCloumListEntityBindingSource.RemoveCurrent(); } } }
private void LoadMataColum(string schemaFrom) { toolStrip2.Enabled = true; var c = AzMetaCustomCloumHandle.Handle().Select().Where(t => t.TableName == currentSelectObjModeName).OrderBy(t => t.ShowOrder).Go(); DataTable data = Translator.Translate <AzMetaProfile, AzMetaCustomCloumEntity>(c, "AtkMetaCustomCloum"); data.AcceptChanges(); azMetaCustomCloumListEntityBindingSource.DataSource = data; azMetaCustomCloumListEntityBindingSource.EndEdit(); if (string.IsNullOrWhiteSpace(schemaFrom)) { tspButtonImport.Enabled = false; } else { tspButtonImport.Enabled = c.Where(m => m.SchemaFrom == schemaFrom).Count() == 0; } }
private int CreateDBTabeOp(string objModeName) { AzMetaTableEntity azMetaTable = AzMetaTableHandle.Handle().Select() .Where(t => t.ObjModeName == objModeName) .Go().FirstOrDefault(); IEnumerable <AzMetaCustomCloumEntity> cloumListEntities = AzMetaCustomCloumHandle.Handle().Select() .Where(t => t.TableName == azMetaTable.SchemaName) .Go(); string strcreate = DataOperate.CreateDBObject(azMetaTable, cloumListEntities); int result = MetadataOperate.ExecuteCmd(strcreate); if (result > 0) { azMetaTable.ObjModeType = 0; azMetaTable.ObjDataType = 0; AzMetaTableHandle.Handle().Updata(azMetaTable); } return(result); }
private void tspMenuItemDisplay_Click(object sender, System.EventArgs e) { if (GeneralHelpler.ConfirmQuestionOperate("确定生成显示名(已经有显示名的不合更改)?") == DialogResult.Cancel) { return; } var listcol = AzMetaCustomCloumHandle.Handle().Select().Where(t => t.TableName == currentSelectObjModeName).OrderBy(t => t.ShowOrder).Go(); foreach (var item in listcol) { if (string.IsNullOrWhiteSpace(item.FldDisplay)) { item.FldDisplay = item.FldName; AzMetaCustomCloumHandle.Handle().Update(item); } } LoadMataColum(currentschemaFrom); }
private void tspButtonSort_Click(object sender, System.EventArgs e) { if (GeneralHelpler.ConfirmQuestionOperate("确定生成顺序?") == DialogResult.Cancel) { return; } var listcol = AzMetaCustomCloumHandle.Handle().Select().Where(t => t.TableName == currentSelectObjModeName).OrderBy(t => t.ShowOrder).Go(); var odi = 1; foreach (var item in listcol) { item.ShowOrder = odi; AzMetaCustomCloumHandle.Handle().Update(item); odi += 1; } LoadMataColum(currentschemaFrom); }
private void tspCancelEdit_Click(object sender, System.EventArgs e) { if (GeneralHelpler.ConfirmQuestionOperate("确定取消当前修改吗?") == DialogResult.Cancel) { return; } var drow = azMetaCustomCloumListEntityBindingSource.Current; if (drow != null) { var row = ((DataRowView)drow).Row; var entity = row.ToObject <AzMetaCustomCloumEntity>(); var c = AzMetaCustomCloumHandle.Handle().Select().Where(t => t.Id == entity.Id).Go(); DataTable data = Translator.Translate <AzMetaProfile, AzMetaCustomCloumEntity>(c, "AtkMetaCustomCloum"); row.ItemArray = data.AsEnumerable().FirstOrDefault().ItemArray; row.AcceptChanges(); tspBtnSave.Enabled = DataChangeAskSave(); tspButtonSort.Enabled = !tspBtnSave.Enabled && tspBtnEdit.Enabled; } }
private void azCdgnDBSchema1_Atk_ReCreateDbData(object sender, EventArgs e) { if (GeneralHelpler.ConfirmQuestionOperate("确定重新导入?如果重新导入原设置将清除!") == DialogResult.Cancel) { return; } AzMetaCloumHandle.Handle().InitColumnSchema(metaTableEntity.SchemaName); var listcol = AzMetaCustomCloumHandle.Handle().Select().Where(t => t.TableName == metaTableEntity.SchemaName).Go(); foreach (var item in listcol) { var entitype = MetaDataTypeHandle.GetMetaDataType(item.FldType); if (entitype != null) { item.FldCodeType = entitype.CodeType; AzMetaCustomCloumHandle.Handle().Update(item); } } azCdgnDetail1.SetCurrentObject(metaTableEntity, 1); }
private void btnCancel_Click(object sender, EventArgs e) { if (GeneralHelpler.ConfirmQuestionOperate("确定取消当前修改吗?") == DialogResult.Cancel) { return; } var drow = bindingSource1.Current; if (drow != null) { var row = ((DataRowView)drow).Row; var entity = row.ToObjectSafe <AzMetaCustomCloumEntity>(); if (entity.Id == 0) { bindingSource1.RemoveCurrent(); return; } var c = AzMetaCustomCloumHandle.Handle().Select().Where(t => t.Id == entity.Id).Go(); DataTable data = Translator.Translate <AzMetaProfile, AzMetaCustomCloumEntity>(c, "AtkMetaCustomCloum"); row.ItemArray = data.AsEnumerable().FirstOrDefault().ItemArray; row.AcceptChanges(); } }