private void btnSave_Click(object sender, EventArgs e)
{
btnAddRow.Enabled = false;
btnDelRow.Enabled = false;
btnSave.Enabled = false;
btnCommit.Enabled = true;
btnRollback.Enabled = true;
foreach (DataGridViewRow row in treeListProperty.Rows)
{
SYS_METADATADETAIL obj = null;
if (null == row.Cells[0].Value && null != row.Cells[1].Value) // 新增的行
{
obj = new SYS_METADATADETAIL();
obj.ID = ValueOperator.CreatePk("SYS_METADATADETAIL");
obj.REF_METADATA_ID = CurrMetaData.ID;
}
else // 旧行
{
obj = row.Cells[0].Value as SYS_METADATADETAIL;
}
if (null != obj)
{
if (null != row.Cells[1].Value)
{
obj.NAME = row.Cells[1].Value.ToString();
}
if (null != row.Cells[2].Value)
{
obj.DESCRIPTION = row.Cells[2].Value.ToString();
}
if (null != row.Cells[3].Value)
{
obj.DATATYPE = row.Cells[3].Value.ToString();
}
if (null != row.Cells[4].Value)
{
obj.LENGTH = Convert.ToInt32(row.Cells[4].Value.ToString());
}
obj.NULLABLE = 1;
if (null != row.Cells[5].Value && false == Convert.ToBoolean(row.Cells[5].Value))
{
obj.NULLABLE = 0;
}
if (null != row.Cells[6].Value)
{
obj.DEFAULTVAL = row.Cells[6].Value.ToString();
}
BusinessServcie.SaveMetaDataDetail(obj);
}
}
}
public SYS_BUSINESSROLE SaveBusinessRole(SYS_BUSINESSROLE role)
{
if (0 == role.ID)
{
role.ID = ValueOperator.CreatePk("SYS_BUSINESSROLE");
}
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(role);
return(role);
}
}
public SYS_SYSTEMCONFIG SaveConfig(SYS_SYSTEMCONFIG config)
{
if (0 == config.ID)
{
config.ID = ValueOperator.CreatePk("SYS_SYSTEMCONFIG");
}
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(config);
return(config);
}
}
public SYS_BUSINESSPROCESS SaveBusinessProcess(SYS_BUSINESSPROCESS process)
{
if (0 == process.ID)
{
process.ID = ValueOperator.CreatePk("SYS_BUSINESSPROCESS");
}
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(process);
return(process);
}
}
public SYS_BUSINESS SaveBusiness(SYS_BUSINESS business)
{
if (0 == business.ID)
{
business.ID = ValueOperator.CreatePk("SYS_BUSINESS");
}
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(business);
}
return(business);
}
public SYS_BUSINESSMATERIAL SaveBusinessMaterial(SYS_BUSINESSMATERIAL material)
{
if (0 == material.ID)
{
material.ID = ValueOperator.CreatePk("SYS_BUSINESSMATERIAL");
}
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(material);
return(material);
}
}
public SYS_BUSINESSFORM SaveBusinessForm(SYS_BUSINESSFORM form)
{
if (0 == form.ID)
{
form.ID = ValueOperator.CreatePk("SYS_BUSINESSFORM");
}
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(form);
return(form);
}
}
public ORUP_USER SaveUser(ORUP_USER user)
{
if (0 == user.ID)
{
user.ID = ValueOperator.CreatePk("ORUP_USER");
}
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(user);
return(user);
}
}
public ORUP_ORGANIZATION SaveOrg(ORUP_ORGANIZATION org)
{
if (0 == org.ID)
{
org.ID = ValueOperator.CreatePk("ORUP_ROLE");
}
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(org);
return(org);
}
}
public ORUP_ROLE SaveRole(ORUP_ROLE role)
{
if (0 == role.ID)
{
role.ID = ValueOperator.CreatePk("ORUP_ROLE");
}
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(role);
return(role);
}
}
public SYS_BUSINESSDATA AddBusinessData(string Name, string Description)
{
SYS_BUSINESSDATA result = new SYS_BUSINESSDATA();
result.ID = ValueOperator.CreatePk("SYS_BUSINESSDATA");
result.NAME = Name;
result.DESCRIPTION = Description;
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(result);
}
return(result);
}
public ORUP_USERORGANIZATION SaveUserOrg(int UserId, int OrgId)
{
ORUP_USERORGANIZATION uo = new ORUP_USERORGANIZATION();
uo.ID = ValueOperator.CreatePk("ORUP_USERORGANIZATION");
uo.USERID = UserId;
uo.ORGANIZATIONID = OrgId;
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(uo);
return(uo);
}
}
public ORUP_USERROLE SaveUserRole(int UserId, int RoleId)
{
ORUP_USERROLE ur = new ORUP_USERROLE();
ur.ID = ValueOperator.CreatePk("ORUP_USERROLE");
ur.UserID = UserId;
ur.RoleID = RoleId;
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(ur);
return(ur);
}
}
public SYS_BUSINESSDATADETAIL AddBusinessDataDetail(int REF_BUSINESSDATA_ID, int REF_METADATA_ID, int PARENTID)
{
SYS_BUSINESSDATADETAIL result = new SYS_BUSINESSDATADETAIL();
result.ID = ValueOperator.CreatePk("SYS_BUSINESSDATADETAIL");
result.REF_BUSINESSDATA_ID = REF_BUSINESSDATA_ID;
result.REF_METADATA_ID = REF_METADATA_ID;
result.PARENTID = PARENTID;
using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler)
{
orm.Save(result);
}
return(result);
}