public static bool DeleteTableInfo(string tablename, string columnname)
{
try
{
var q = (from PMSTableFieldInfo in PMSDBStructure.PMSCenterDataContext.s_TableFieldInfo
where PMSTableFieldInfo.TableGuid == MESCenterFunctions.fn_GetGuidFromTableName(tablename) &&
PMSTableFieldInfo.FieldName == columnname
select PMSTableFieldInfo);
if (q.Count() == 0)
{
return(true);
}
s_TableFieldInfo info = q.First();
PMSDBStructure.PMSCenterDataContext.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, info);
if (info != null)
{
PMSDBStructure.PMSCenterDataContext.DeleteObject(info);
PMSDBStructure.PMSCenterDataContext.SaveChanges();
}
}
catch (System.Exception e)
{
PMS.Libraries.ToolControls.PMSPublicInfo.Message.Error(PMS.Libraries.ToolControls.PMSPublicInfo.CurrentPrjInfo.CurrentLoginUserID, e.Message, true);
return(false);
}
return(true);
}
public static bool UploadTableFieldInfo(s_TableFieldInfo TableFieldInfo)
{
try
{
PMSDBStructure.PMSCenterDataContext.AddTos_TableFieldInfo(TableFieldInfo);
PMSDBStructure.PMSCenterDataContext.SaveChanges();
}
catch (System.Exception e)
{
PMS.Libraries.ToolControls.PMSPublicInfo.Message.Error(PMS.Libraries.ToolControls.PMSPublicInfo.CurrentPrjInfo.CurrentLoginUserID, e.Message, true);
return(false);
}
return(true);
}
public static bool UploadTableFieldInfo(PMS.Libraries.ToolControls.PMSPublicInfo.PMSDBFieldPropCollection fpc, Guid tableGuid)
{
try
{
foreach (PMS.Libraries.ToolControls.PMSPublicInfo.PMSDBFieldProp fp in fpc)
{
s_TableFieldInfo FieldInfo = new s_TableFieldInfo();
FieldInfo.FieldGuid = System.Guid.NewGuid();
FieldInfo.TableGuid = tableGuid;
FieldInfo.FieldID = fp.IFildID;
FieldInfo.FieldName = fp.StrFieldName;
FieldInfo.FieldType = fp.StrFieldType;
FieldInfo.FieldLength = fp.IFieldLength.ToString();
FieldInfo.FieldPrimaryKey = fp.BFieldPrimaryKey;
FieldInfo.FieldIdentity = fp.BFieldIdentity;
FieldInfo.FieldNullAble = fp.BFieldNullable;
FieldInfo.FieldIsSystem = fp.BFieldIsSystem;
FieldInfo.FieldDefault = fp.StrFieldDefault;
FieldInfo.FieldDescription = fp.StrFieldDescription;
if (fp.ExProps != null)
{
foreach (KeyValuePair <string, PMSDBExtendedProp> entry in fp.ExProps)
{
s_TableFieldProperty FieldProperty = new s_TableFieldProperty();
FieldProperty.PropertyGuid = System.Guid.NewGuid();
FieldProperty.FieldGuid = FieldInfo.FieldGuid;
FieldProperty.PropertyName = entry.Value.StrPropName;
FieldProperty.PropertyValue = entry.Value.StrPropValue;
PMSDBStructure.PMSCenterDataContext.AddTos_TableFieldProperty(FieldProperty);
}
}
PMSDBStructure.PMSCenterDataContext.AddTos_TableFieldInfo(FieldInfo);
}
PMSDBStructure.PMSCenterDataContext.SaveChanges();
}
catch (System.Exception e)
{
PMS.Libraries.ToolControls.PMSPublicInfo.Message.Error(PMS.Libraries.ToolControls.PMSPublicInfo.CurrentPrjInfo.CurrentLoginUserID, e.Message, true);
return(false);
}
return(true);
}