public Model.General.ReturnValueInfo Save(Model.IModel.IModelObject itemEntity, Common.DefineConstantValue.EditStateEnum EditMode)
{
Model.General.ReturnValueInfo returnValue = new Model.General.ReturnValueInfo();
ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info();
returnValue.messageText = "";
info = itemEntity as ListColumnsMaster_lcm_Info;
switch (EditMode)
{
case Common.DefineConstantValue.EditStateEnum.OE_Insert:
bool isExist = false;
isExist = _ListColumnsMasterDA.IsExistRecord(info);
if (!isExist)
{
returnValue.boolValue = _ListColumnsMasterDA.InsertRecord(info);
}
else
{
returnValue.boolValue = false;
returnValue.messageText = "数据重复！";
}
break;
case Common.DefineConstantValue.EditStateEnum.OE_Update:
returnValue.boolValue = _ListColumnsMasterDA.UpdateRecord(info);
break;
case Common.DefineConstantValue.EditStateEnum.OE_Delete:
returnValue.boolValue = _ListColumnsMasterDA.DeleteRecord(info);
break;
default:
break;
}
return returnValue;
}
public ListColumnsMaster_lcm_Info DisplayRecord(Model.IModel.IModelObject KeyObject)
{
ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info();
using (MainDBDataContext db = new MainDBDataContext())
{
ListColumnsMaster_lcm disTab = db.ListColumnsMaster_lcm.SingleOrDefault(t => t.lcm_iRecordID == ((KeyObject) as ListColumnsMaster_lcm_Info).lcm_iRecordID);
if (disTab != null)
{
info = Common.General.CopyObjectValue<ListColumnsMaster_lcm, ListColumnsMaster_lcm_Info>(disTab);
}
}
return info;
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
bool isSuccess = false;
ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info();
info = KeyObject as ListColumnsMaster_lcm_Info;
using (MainDBDataContext db = new MainDBDataContext())
{
ListColumnsMaster_lcm delTab = db.ListColumnsMaster_lcm.SingleOrDefault(t => t.lcm_iRecordID == info.lcm_iRecordID);
if (delTab != null)
{
db.ListColumnsMaster_lcm.DeleteOnSubmit(delTab);
db.SubmitChanges();
isSuccess = true;
}
}
return isSuccess;
}
public List<ListColumnsMaster_lcm_Info> FindRecord(ListColumnsMaster_lcm_Info info)
{
return SearchRecords(info);
}
public bool UpdateRecord(ListColumnsMaster_lcm_Info infoObject)
{
bool isSuccess = false;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
ListColumnsMaster_lcm query = db.ListColumnsMaster_lcm.SingleOrDefault(t => t.lcm_iRecordID == infoObject.lcm_iRecordID);
if (query != null)
{
query.lcm_cValueFormat = infoObject.lcm_cValueFormat;
query.lcm_cName = infoObject.lcm_cName;
query.lcm_iWidth = infoObject.lcm_iWidth;
query.lcm_iSeq = infoObject.lcm_iSeq;
query.lcm_lIsActive = infoObject.lcm_lIsActive;
query.lcm_cLastBy = infoObject.lcm_cLastBy;
query.lcm_dLastDate = infoObject.lcm_dLastDate;
db.SubmitChanges();
isSuccess = true;
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return isSuccess;
}
public List<ListColumnsMaster_lcm_Info> SearchRecords(Model.IModel.IModelObject searchCondition)
{
List<ListColumnsMaster_lcm_Info> list = new List<ListColumnsMaster_lcm_Info>();
ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info();
info = searchCondition as ListColumnsMaster_lcm_Info;
StringBuilder sqlString = new StringBuilder();
sqlString.AppendLine("SELECT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString());
sqlString.AppendLine("*");
sqlString.AppendLine("FROM dbo.ListColumnsMaster_lcm");
sqlString.AppendLine("WHERE 1=1");
if (info.lcm_cMainType != "")
{
sqlString.AppendLine("AND lcm_cMainType='" + info.lcm_cMainType + "'");
}
if (info.lcm_cSubType != "")
{
sqlString.AppendLine("AND lcm_cSubType='" + info.lcm_cSubType + "'");
}
if (info.lcm_cValue != "")
{
sqlString.AppendLine("AND lcm_cSubType='" + info.lcm_cValue + "'");
}
IEnumerable<ListColumnsMaster_lcm_Info> infos = null;
using (MainDBDataContext db = new MainDBDataContext())
{
infos = db.ExecuteQuery<ListColumnsMaster_lcm_Info>(sqlString.ToString(), new object[] { });
if (infos != null)
{
list = infos.ToList<ListColumnsMaster_lcm_Info>();
}
}
return list;
}
public bool IsExistRecord(object KeyObject)
{
ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info();
info = KeyObject as ListColumnsMaster_lcm_Info;
using (MainDBDataContext db = new MainDBDataContext())
{
ListColumnsMaster_lcm query = db.ListColumnsMaster_lcm.First();
if (query != null)
{
return true;
}
}
return false;
}
public bool InsertRecord(ListColumnsMaster_lcm_Info infoObject)
{
bool isSuccess = false;
ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info();
info = infoObject;
using (MainDBDataContext db = new MainDBDataContext())
{
ListColumnsMaster_lcm newTab = Common.General.CopyObjectValue<ListColumnsMaster_lcm_Info, ListColumnsMaster_lcm>(info);
db.ListColumnsMaster_lcm.InsertOnSubmit(newTab);
db.SubmitChanges();
isSuccess = true;
}
return isSuccess;
}
public List<ListColumnsMaster_lcm_Info> FindRecord(ListColumnsMaster_lcm_Info info)
{
return _ListColumnsMasterDA.FindRecord(info);
}
