public static bool ModifyBaseData(BaseDataEntity baseDataEntity)
{
int result = 0;
if (baseDataEntity != null)
{
BaseDataRepository mr = new BaseDataRepository();
BaseDataInfo baseDataInfo = TranslateBaseDataInfo(baseDataEntity);
if (baseDataEntity.ID > 0)
{
result = mr.ModifyData(baseDataInfo);
}
else
{
baseDataInfo.CreateDate = DateTime.Now;
result = mr.CreateNew(baseDataInfo);
}
List <BaseDataInfo> miList = mr.GetAllData();//刷新缓存
Cache.Add("BaseDataALL", miList);
}
return(result > 0);
}
public static BaseDataEntity GetBaseDataById(int id)
{
BaseDataEntity result = new BaseDataEntity();
BaseDataRepository mr = new BaseDataRepository();
BaseDataInfo info = mr.GetBaseDataByKey(id);
result = TranslateBaseDataEntity(info);
return(result);
}
public BaseDataInfo GetBaseDataByKey(int id)
{
BaseDataInfo result = new BaseDataInfo();
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(BaseDataStatement.GetBaseDataByKey, "Text"));
command.AddInputParameter("@ID", DbType.Int32, id);
result = command.ExecuteEntity <BaseDataInfo>();
return(result);
}
private List <BaseDataInfo> GetStatsicLines(List <BaseDataInfo> dataInfos)
{
NestDirectory dir = DataProvider.GetNestDirectory(null);
List <BaseDataInfo> statsicInfos = new List <BaseDataInfo>();
foreach (var item in dir.Children)
{
BaseDataInfo line = DataProcess.CreateStatsicLine(dataInfos, item.Name, item.Children.Select(x => x.Name).ToList());
statsicInfos.Add(line);
}
return(statsicInfos);
}
public int ModifyData(BaseDataInfo data)
{
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(BaseDataStatement.ModifyBaseData, "Text"));
command.AddInputParameter("@ID", DbType.Int32, data.ID);
command.AddInputParameter("@TypeCode", DbType.String, data.TypeCode);
command.AddInputParameter("@PCode", DbType.String, data.PCode);
command.AddInputParameter("@ValueInfo", DbType.String, data.ValueInfo);
command.AddInputParameter("@Description", DbType.String, data.Description);
command.AddInputParameter("@Status", DbType.Int32, data.Status);
return(command.ExecuteNonQuery());
}
private static BaseDataEntity TranslateBaseDataEntity(BaseDataInfo baseDataInfo)
{
BaseDataEntity baseDataEntity = new BaseDataEntity();
if (baseDataInfo != null)
{
baseDataEntity.ID = baseDataInfo.ID;
baseDataEntity.TypeCode = baseDataInfo.TypeCode;
baseDataEntity.PCode = baseDataInfo.PCode;
baseDataEntity.ValueInfo = baseDataInfo.ValueInfo;
baseDataEntity.Description = baseDataInfo.Description;
baseDataEntity.Status = baseDataInfo.Status;
}
return(baseDataEntity);
}
private static BaseDataInfo TranslateBaseDataInfo(BaseDataEntity baseDataEntity)
{
BaseDataInfo baseDataInfo = new BaseDataInfo();
if (baseDataEntity != null)
{
baseDataInfo.ID = baseDataEntity.ID;
baseDataInfo.TypeCode = baseDataEntity.TypeCode ?? "";
baseDataInfo.PCode = baseDataEntity.PCode ?? "";
baseDataInfo.ValueInfo = baseDataEntity.ValueInfo ?? "";
baseDataInfo.Description = baseDataEntity.Description ?? "";
baseDataInfo.Status = baseDataEntity.Status;
}
return(baseDataInfo);
}
static void Main(string[] args)
{
//Console.Title = "HandlerConsole";
/////
//string flowCode = "Receive";
//string taskTypeCode = "ScanReceiveOrderHandler";
//ITaskHandler handler = null;
//IMessage msgHandler = new MessageHandler();
//TaskContext context = null;
//while (true)
//{
// handler = TaskHandler.CreateHandler(taskTypeCode);
// ///
// context = handler.CreateTask(taskTypeCode, flowCode, context);
// ///
// context.userInputContext = msgHandler.AlertMessage(context);
// ///
// taskTypeCode = handler.TaskHandle(ref context);
// ///
// msgHandler.AlertMessage(context);
// ///
// if (string.IsNullOrEmpty(taskTypeCode)) break;
//}
string jsonstr = "{ 'Import':{ 'orderno':'A201805150008'},'Export':{ },'Tables':{ },'ErrCode':'','Msg':'','Token':'58b97fa71f254573af67deb29c3c6e80','Language':'cn-ch','LoginUser':'******','RoleFid':'f04a3b27-b674-4a5e-bd4f-b2e2889318e4','UserFid':'731f7d72-0884-4c13-a73f-5f1c1aec8660','Result':false,'DataServiceUrl':null}";
//"{ 'Import':{ 'cardnos':\"['BF00000284','BF00000285']\",'opUser':'******'},'Export':{ },'Tables':{ },'ErrCode':'','Msg':'','Token':'58b97fa71f254573af67deb29c3c6e80','Language':'cn-ch','LoginUser':'******','RoleFid':'f04a3b27-b674-4a5e-bd4f-b2e2889318e4','UserFid':'731f7d72-0884-4c13-a73f-5f1c1aec8660','Result':false,'DataServiceUrl':null}";
BaseDataInfo baseinfo = JsonConvert.DeserializeObject <BaseDataInfo>(jsonstr);
//BaseDataInfo baseinfo = new BaseDataInfo();
//baseinfo.Import.Add("cardnos", "'BF00000284','BF00000285'");
BaseDataInfo ys = new BaseService().GetReceiveAndOutOrder(baseinfo);
//string jsonData = JsonConvert.SerializeObject(model);
//BaseDataInfo baseinfo = new BaseDataInfo();
//baseinfo.Export.Add("Info", jsonData);
//string jsonDataStr = JsonConvert.SerializeObject(baseinfo);
//KanbanCardBLL temp = new KanbanCardBLL();
//temp.SelectInfoByCardNo("A0001");
///ZheliYang 20180502
//DataSet dataSet = CommonDAL.ExecuteDataSetBySql("select * from [LES].[TM_MPM_KANBAN_CARD] with(nolock)");
//List<string> files = new PrintConfigBLL().CreatePrintFiles("KANBAN_CARD", dataSet, @"D:\PROJECTS\JXINFO\LES\CODE\UI.WEB\");
///
}
