private void BtnSave_Click(object sender, RoutedEventArgs e)
{
//保存
SysTableNOSetting tableNo = gbItem.DataContext as SysTableNOSetting;
if (tableNo == null)
{
return;
}
if (string.IsNullOrEmpty(tableNo.PKNO)) //新增
{
tableNo.PKNO = Guid.NewGuid().ToString("N");
tableNo.CREATION_DATE = DateTime.Now;
tableNo.CREATED_BY = CBaseData.LoginName;
tableNo.LAST_UPDATE_DATE = DateTime.Now;
ws.UseService(s => s.AddSysTableNOSetting(tableNo));
}
else //修改
{
tableNo.LAST_UPDATE_DATE = DateTime.Now;
tableNo.UPDATED_BY = CBaseData.LoginName;
ws.UseService(s => s.UpdateSysTableNOSetting(tableNo));
}
GetPage(); //重新加载
gbItem.IsCollapsed = true;
gbItem.Visibility = Visibility.Collapsed;
BindHelper.SetDictDataBindingGridItem(gbItem, gridItem);
}
/// <summary>
/// 根据关键字段的值获取记录
/// </summary>
/// <param name="Id">关键字段的值</param>
/// <returns>符合查询条件的记录</returns>
public SysTableNOSetting GetSysTableNOSettingById(string Id)
{
using (ISysTableNOSettingBLL SysTableNOSettingBLL = BLLContainer.Resolve <ISysTableNOSettingBLL>())
{
SysTableNOSetting model = SysTableNOSettingBLL.GetFirstOrDefault(Id);
return(model);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="mSysTableNOSetting">模型</param>
/// <returns>是否成功</returns>
public bool UpdateSysTableNOSetting(SysTableNOSetting mSysTableNOSetting)
{
if (mSysTableNOSetting == null)
{
return(false);
}
using (ISysTableNOSettingBLL SysTableNOSettingBLL = BLLContainer.Resolve <ISysTableNOSettingBLL>())
{
return(SysTableNOSettingBLL.Update(mSysTableNOSetting));
}
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Id">关键字段</param>
/// <returns>是否成功</returns>
public bool DelSysTableNOSetting(string Id)
{
using (ISysTableNOSettingBLL SysTableNOSettingBLL = BLLContainer.Resolve <ISysTableNOSettingBLL>())
{
try
{
SysTableNOSetting item = SysTableNOSettingBLL.GetFirstOrDefault(Id);
return(SysTableNOSettingBLL.Delete(item));
}
catch { return(false); }
}
}
private void BtnMod_Click(object sender, RoutedEventArgs e)
{
SysTableNOSetting m_SysTableNOSetting = gridItem.SelectedItem as SysTableNOSetting;
if (m_SysTableNOSetting == null)
{
return;
}
//修改
dictInfo.Header = "系统表格编号设置详细 【修改】";
gbItem.IsCollapsed = false;
gbItem.Visibility = Visibility.Visible;
}
private void gridItem_MouseDoubleClick(object sender, System.Windows.Input.MouseButtonEventArgs e)
{
SysTableNOSetting m_SysTableNOSetting = gridItem.SelectedItem as SysTableNOSetting;
if (m_SysTableNOSetting == null)
{
return;
}
//修改
dictInfo.Header = "系统表格编号设置详细 【修改】";
gbItem.IsCollapsed = false;
gbItem.Visibility = Visibility.Visible;
}
private void BtnAdd_Click(object sender, RoutedEventArgs e)
{
//新增
dictInfo.Header = "系统表格编号设置详细 【新增】";
gbItem.IsCollapsed = false;
gbItem.Visibility = Visibility.Visible;
SysTableNOSetting tableNo = new SysTableNOSetting()
{
COMPANY_CODE = "",
IDENTIFY_CODE = "",
DATE_FORMATE = "yyMMdd",
USE_FLAG = 1,
};
gbItem.DataContext = tableNo;
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Ids">关键字段数组</param>
/// <returns>是否成功</returns>
public bool DelSysTableNOSettings(string[] Ids)
{
using (ISysTableNOSettingBLL SysTableNOSettingBLL = BLLContainer.Resolve <ISysTableNOSettingBLL>())
{
try
{
List <SysTableNOSetting> entitys = new List <SysTableNOSetting>();
foreach (string id in Ids)
{
SysTableNOSetting item = SysTableNOSettingBLL.GetFirstOrDefault(id);
entitys.Add(item);
}
return(SysTableNOSettingBLL.Delete(entitys));
}
catch { return(false); }
}
}
private void BtnDel_Click(object sender, RoutedEventArgs e)
{
//删除
SysTableNOSetting m_SysTableNOSetting = gridItem.SelectedItem as SysTableNOSetting;
if (m_SysTableNOSetting == null)
{
return;
}
if (System.Windows.Forms.MessageBox.Show($"确定删除基础信息【{m_SysTableNOSetting.NO_INTROD}】吗？",
@"删除信息",
MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
m_SysTableNOSetting.USE_FLAG = -1;
ws.UseService(s => s.UpdateSysTableNOSetting(m_SysTableNOSetting));
//删除成功.
GetPage(); //重新加载
}
}
/// <summary>
/// 获取新的编号
/// </summary>
/// <param name="IdentifyCode">PmTaskLine.TASK_NO</param>
/// <param name="formate">格式 前缀符,日期格式,后缀符,开始编号,当前编号 没有,表示只有前缀符的标准格式 </param>
/// <returns></returns>
public static string GetNewNO(string IdentifyCode, string formate = "")
{
SysTableNOSetting tableNoSetting =
ws.UseService(s => s.GetSysTableNOSettings($"USE_FLAG = 1 AND IDENTIFY_CODE = '{IdentifyCode}'"))
.FirstOrDefault();
string sDate;
if (tableNoSetting == null) //自动初始化
{
string[] values = IdentifyCode.Split('.', '。');
if (values.Length <= 1)
{
return($"编号代码({IdentifyCode})未能初始化.");
}
string[] formates = formate.Split(',');
#region 自动添加编号
string sTableName = values[0];
string sFieldValue = values[1];
tableNoSetting = new SysTableNOSetting()
{
PKNO = CBaseData.NewGuid(),
COMPANY_CODE = "",
IDENTIFY_CODE = IdentifyCode,
TABLE_NAME = sTableName,
TABLE_INTROD = sTableName, //描述
FIELD_NAME = sFieldValue,
MAX_LENGTH = 50,
PREFIX_STR = (!string.IsNullOrEmpty(formate)) ? formates[0] : "N",
DATE_FORMATE = (formates.Length > 1) ? formates[1] : "yyMMdd",
POSTFIX_STR = (formates.Length > 2) ? formates[2] : "",
FIRST_NO = (formates.Length > 3) ? formates[3] : "001",
CUR_NO = (formates.Length > 4) ? formates[4] : "001",
NO_INTROD = "编号组成：{前缀符}+{服务器编号}+{格式化的日期}+{顺序号}+{后缀符}",
CREATION_DATE = DateTime.Now,
CREATED_BY = CBaseData.LoginName,
LAST_UPDATE_DATE = DateTime.Now, //最后修改日期
USE_FLAG = 1,
REMARK = "系统自动创建",
};
ws.UseService(s => s.AddSysTableNOSetting(tableNoSetting));
#endregion
sDate = "";
if (!string.IsNullOrEmpty(tableNoSetting.DATE_FORMATE))
{
sDate = DateTime.Now.ToString(tableNoSetting.DATE_FORMATE);
}
return(tableNoSetting.PREFIX_STR + sDate + tableNoSetting.FIRST_NO + tableNoSetting.POSTFIX_STR);
}
sDate = "";
string sCurIndex = tableNoSetting.FIRST_NO;
if (!string.IsNullOrEmpty(tableNoSetting.DATE_FORMATE))
{
sDate = DateTime.Now.ToString(tableNoSetting.DATE_FORMATE);
}
if (!string.IsNullOrEmpty(tableNoSetting.CUR_NO)) //有当前编号
{
sCurIndex = tableNoSetting.CUR_NO;
}
else //如果没有当前编号，从数据读取
{
//string sql = $" SELECT {tableNoSetting.FIELD_NAME} FROM {tableNoSetting.TABLE_NAME} " +
// $" WHERE {tableNoSetting.FIELD_NAME} LIKE '{tableNoSetting.PREFIX_STR}{sDate}%{tableNoSetting.POSTFIX_STR}'" +
// $" ORDER BY ";
sCurIndex = tableNoSetting.FIRST_NO;
}
string sNewIndex = sCurIndex;
#region 获取下一个顺序号
Int64 index = 0;
Int64.TryParse(sCurIndex, out index);
index++;
if (sCurIndex.Length < index.ToString().Length) //位数边长
{
sNewIndex = 1.ToString().PadLeft(sCurIndex.Length + 1, '0');
}
else
{
sNewIndex = index.ToString().PadLeft(sCurIndex.Length, '0');
}
#endregion
string sNewNO = tableNoSetting.PREFIX_STR + sDate + sNewIndex + tableNoSetting.POSTFIX_STR;
if (sNewNO.Length > tableNoSetting.MAX_LENGTH) //长度超过数据库的长度，重新编号，智能升级号码
{
tableNoSetting.PREFIX_STR += "N"; //新增长度
sNewIndex =
1.ToString()
.PadLeft(
tableNoSetting.MAX_LENGTH - tableNoSetting.PREFIX_STR.Length - sDate.Length -
tableNoSetting.POSTFIX_STR.Length, '0');
}
#region 反馈到数据库
tableNoSetting.CUR_NO = sNewIndex;
ws.UseService(s => s.UpdateSysTableNOSetting(tableNoSetting));
#endregion
return(sNewNO);
}
