public int CreateDic(DicModel dicType)
{
using (var connection = DataBase.GetOpenConnection(GetConnectionString))
{
var count = connection.Insert <DicModel>(dicType);
return((int)count);
}
}
public int UpdateDic(DicModel dic)
{
using (var connection = DataBase.GetOpenConnection(GetConnectionString))
{
var count = connection.Update <DicModel>(dic);
return(count);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public MessageModel InsertDicData(DicModel model)
{
Func <IEntityContext, string> opera = delegate(IEntityContext context)
{
context.Dic.Add(model);
context.SaveChanges();
return(string.Empty);
};
return(base.DbOperationInTransaction(opera));
}
internal bool IsParameter(DicModel item)
{
switch (item.Action)
{
case ActionEnum.Insert:
//case ActionEnum.Set:
//case ActionEnum.Change:
case ActionEnum.Update:
case ActionEnum.Where:
case ActionEnum.And:
case ActionEnum.Or:
return(true);
}
return(false);
}
private string InStrHandle(DicModel dic)
{
var paras = DC.Conditions.Where(it =>
{
if (!string.IsNullOrWhiteSpace(it.ParamRaw))
{
return(it.ParamRaw.Equals(dic.ParamRaw, StringComparison.OrdinalIgnoreCase));
}
else
{
return(false);
}
}).ToList();
return($" {string.Join(",", paras.Select(it => $" @{it.Param} "))} ");
}
public bool SaveDic(DicModel dicModel)
{
if (string.IsNullOrWhiteSpace(dicModel.DicCode))
{
dicModel.DicCode = Guid.NewGuid().ToString();
return(_dicRepository.CreateDic(dicModel) > 0);
}
else
{
var model = _dicRepository.GetDicByCode(dicModel.DicCode);
model.DicName = dicModel.DicName;
model.Sort = dicModel.Sort;
model.ModifyDate = dicModel.ModifyDate;
model.ModifyDisplayName = dicModel.ModifyDisplayName;
model.ModifyUserName = dicModel.ModifyUserName;
return(_dicRepository.UpdateDic(model) > 0);
}
}
public ParamInfo BoolParamHandle(DicModel item)
{
if (!string.IsNullOrWhiteSpace(item.ColumnType) &&
item.ColumnType.Equals("bit", StringComparison.OrdinalIgnoreCase))
{
if (item.CsValue.ToBool())
{
item.DbValue = 1.ToString();
return(GetDefault(item.Param, 1, DbType.UInt16));
}
else
{
item.DbValue = 0.ToString();
return(GetDefault(item.Param, 0, DbType.UInt16));
}
}
else
{
item.DbValue = item.CsValue.ToBool().ToString();
return(GetDefault(item.Param, item.CsValue.ToBool(), DbType.Boolean));
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult SaveDic(DicModel model)
{
var result = new ResultJson();
try
{
if (model.DicID == 0)
{
_dicService.InsertDicData(model);
}
else
{
_dicService.UpdateDicData(model);
}
result.IsSuccess = true;
}
catch (Exception)
{
throw;
}
return(Json(result));
}
/****************************************************************************************************************/
private string LikeStrHandle(DicModel dic)
{
var name = dic.Param;
var value = dic.CsValue;
if (!value.Contains("%") &&
!value.Contains("_"))
{
return($"CONCAT('%',@{name},'%')");
}
else if ((value.Contains("%") || value.Contains("_")) &&
!value.Contains("/%") &&
!value.Contains("/_"))
{
return($"@{name}");
}
else if (value.Contains("/%") ||
value.Contains("/_"))
{
return($"@{name} escape '/' ");
}
throw new Exception(value);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public MessageModel UpdateDicData(DicModel model)
{
Func <IEntityContext, string> opera = delegate(IEntityContext context)
{
var dicroot = context.Dic.Find(model.DicID);
if (dicroot != null)
{
dicroot.Code = model.Code;
dicroot.RootID = model.RootID;
dicroot.Name = model.Name;
dicroot.Description = model.Description;
dicroot.SortID = model.SortID;
dicroot.IsLocked = model.IsLocked;
dicroot.ModifyID = UserManagement.CurrentUser.UserID;
dicroot.ModifyTime = DateTime.Now;
dicroot.ModifyName = UserManagement.CurrentUser.UserName;
context.UpdateAndSave(dicroot);
}
return(string.Empty);
};
return(base.DbOperationInTransaction(opera));
}
public static AddedView AddedModel(DicModel model)
{
var cbFabricator = new ComboBox()
{
Margin = new Thickness(10, 0, 10, 10), ItemsSource = SQL.GetFabricator().Select(s => s.Fabricator)
};
var lblF = new Label()
{
Content = "Необходимо заполнить Производителя", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var tbModel = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var lblM = new Label()
{
Content = "Необходимо заполнить Модель", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var a = new AddedView
{
Controls = new List <Control>
{
new Label()
{
Content = "Производитель", Margin = new Thickness(10, 0, 10, 0)
},
cbFabricator,
lblF,
new Label()
{
Content = "Модель", Margin = new Thickness(10, 0, 10, 0)
},
tbModel,
lblM
}
};
if (model == null)
{
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(cbFabricator.Text.Trim()) || (string.IsNullOrEmpty(tbModel.Text.Trim())))
{
lblF.Visibility = (string.IsNullOrEmpty(cbFabricator.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
lblM.Visibility = (string.IsNullOrEmpty(tbModel.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
return;
}
SQL.Add(new DicModel()
{
IdFabricator = SQL.GetIdFabricator(cbFabricator.SelectedItem.ToString()),
Model = tbModel.Text
});
a.Close();
});
}
else
{
tbModel.Text = model.Model;
cbFabricator.SelectedValue = SQL.GetFabricator(model.IdFabricator);
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(cbFabricator.Text.Trim()) || (string.IsNullOrEmpty(tbModel.Text.Trim())))
{
lblF.Visibility = (string.IsNullOrEmpty(cbFabricator.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
lblM.Visibility = (string.IsNullOrEmpty(tbModel.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
return;
}
SQL.Update(new DicModel()
{
IdModel = model.IdModel,
IdFabricator = SQL.GetIdFabricator(cbFabricator.SelectedItem.ToString()),
Model = tbModel.Text
});
a.Close();
});
}
a.Init();
mainWindow.ShowAddedWindow(a);
return(a);
}
internal void AddConditions(DicModel dic)
{
if (!string.IsNullOrWhiteSpace(dic.CsValue) &&
dic.CsValue.Contains(",") &&
dic.Option == OptionEnum.In)
{
var vals = dic.CsValue.Split(',').Select(it => it);
var i = 0;
foreach (var val in vals)
{
//
i++;
var op = OptionEnum.None;
if (i == 1)
{
op = OptionEnum.In;
}
else
{
op = OptionEnum.InHelper;
}
//
var dicx = new DicModel
{
TableOne = dic.TableOne,
ClassFullName = dic.ClassFullName,
ColumnOne = dic.ColumnOne,
TableAliasOne = dic.TableAliasOne,
TableTwo = dic.TableTwo,
KeyTwo = dic.KeyTwo,
AliasTwo = dic.AliasTwo,
Param = dic.Param,
ParamRaw = dic.ParamRaw,
CsValue = val,
ValueType = dic.ValueType,
ColumnType = dic.ColumnType,
Option = op,
Action = dic.Action,
Crud = dic.Crud,
Compare = dic.Compare,
TvpIndex = dic.TvpIndex
};
AddConditions(dicx);
}
Conditions.Remove(dic);
}
else if (!string.IsNullOrWhiteSpace(dic.Param) &&
Conditions.Any(it => dic.Param.Equals(it.Param, StringComparison.OrdinalIgnoreCase)))
{
if (dic.Param.Contains("__"))
{
var arr = dic.Param.Split(new string[] { "__" }, StringSplitOptions.RemoveEmptyEntries);
var val = Convert.ToInt32(arr[arr.Length - 1]);
val++;
dic.Param = dic.ParamRaw + "__" + val.ToString();
}
else
{
dic.Param += "__1";
}
AddConditions(dic);
}
else
{
Conditions.Add(dic);
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public MessageModel UpdateDicData(DicModel model)
{
return(_dicAccess.UpdateDicData(model));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public MessageModel InsertDicData(DicModel model)
{
return(_dicAccess.InsertDicData(model));
}
