/// <summary>
/// 根据关键字生成字典编码
/// </summary>
/// <param name="key"></param>
/// <param name="order">该字典顺序号</param>
/// <returns></returns>
public string GenerateDictCode(string key, bool IsChildNode, string pCode, ref int order)
{
//Dictionary<string, int> dic = new Dictionary<string, int>();
int maxNum = TypeConverter.ObjectToInt(instance.GetMax("Dict_ID", key)) + 1;
//DataTable dt = instance.idb.RunProcReturnDatatable("qx_find_dictkeycode", new List<SqlParameter>() { new SqlParameter("sTable", key) }.ToArray());
//Modify By QB
string code = string.Empty;
if (pCode == "root" || pCode == "")
{
pCode = "";
}
code = Bll_Comm.GetTableKey("", key, pCode, code);
return(code);
}
/// <summary>
/// 审核单据
/// </summary>
/// <param name="VerfiyKey">模块名称</param>
/// <param name="KeyCode">编码字段名称</param>
/// <param name="RecordId">编码单据号</param>
/// <param name="AuditSuggest">备注</param>
/// <param name="UserId">用户ID</param>
/// <param name="NextAuditNode">下一审核节点</param>
/// <param name="IsLastAuditNode">是否为最后一个节点</param>
/// <returns></returns>
public bool Audit(string VerfiyKey,
string RecordId,
string AuditSuggest,
string UserId,
string Agree,
string VerfiyNodeCode, out string _ProResult
)
{
bool result = false;
string ProResult = "";
_ProResult = "";
//审核单据，判断是否终审
VerifyProcess_Records Records = new VerifyProcess_Records()
{
Module_Code = VerfiyKey.ToString(), //模块编码
VRecord_Code = Bll_Comm.GetTableKey("VerifyProcess_Records"),
Record_ID = RecordId, //单据ID
VRecord_Opinion = AuditSuggest, //审理意见
VRecord_VCode = VerfiyNodeCode, //审核阶段编码
VRecord_Flag = Agree,
VRecord_Owner = UserId,
Stat = 2
};
int Temp_result = AuditProcessRecordsInstance.Add(Records);
if (Temp_result > 0)
{
SqlParameter x1 = new SqlParameter("@auditCode", SqlDbType.VarChar, 50);
x1.Value = Records.VRecord_Code;
SqlParameter[] param = new SqlParameter[] { x1 };
IDbDataParameter[] parames = param as IDbDataParameter[];
DataTable dt = AuditProcessRecordsInstance.idb.RunProcReturnDatatable("qx_sp_audit", parames);
ProResult = dt.Rows[0][0].ToString();
if (!string.IsNullOrEmpty(ProResult))
{
result = true;
_ProResult = ProResult;
}
}
return(result);
}
public string CreateDictNode(Bse_Dict Node, bool IsChildNode, ref int order)
{
//获取关键字
string codeKey = Node.Dict_Key;
//获取父编码
string parentCode = Node.Dict_Code;
if (codeKey == parentCode)//如果是最顶级，即其父编码为空
{
parentCode = "";
}
//throw new NotImplementedException();
//var dict = GetModelByCode(parentCode,);
order = 0;
//var newCode = GenerateDictCode(dict.Dict_Key,IsChildNode, ref order);
string Code = "";
var newCode = Bll_Comm.GetTableKey("", codeKey, parentCode, Code);
return(newCode);
}
public string GenerateTemplateConfigCode()
{
return(Bll_Comm.GetTableKey("Verify_TemplateConfig"));
}
// private Bll_HR_Department deptInstance = new Bll_HR_Department();
/// <summary>
/// 同步公司物料类别
/// </summary>
/// <param name="itype"></param>
/// <param name="companycode"></param>
/// <param name="deptCode"></param>
/// <returns></returns>
public bool SyncMaterialTypeFromDict(string itype, string companyCode)
{
bool result = false;
List <WH_MaterialType> list = new List <WH_MaterialType>();
List <Bse_Dict> dictList = new List <Bse_Dict>();
List <string> Union = new List <string>();
List <string> InterSect = new List <string>();
if (!string.IsNullOrEmpty(companyCode) && !string.IsNullOrEmpty(itype))
{
try
{
//dictList = dictInstance.GetListByCode(" AND Dict_Key!=Dict_Code AND Dict_PCode='" + itype + "'");
// Modify BY QB
// Modify:同步字典中所有子类别
// Modify Date:2011-3-22
dictList = dictInstance.GetListByCode(" AND Dict_Key!=Dict_Code AND Dict_Key='" + itype + "'");
list = instance.GetListByCode(" AND MT_CompanyCode='" + companyCode + "' ");
IEnumerable <string> listStrList = list.Select(o => o.MT_TCode);
IEnumerable <string> dictStrList = dictList.Select(o => o.Dict_Code);
//取Dict与MaterialType中的并集，并比对Maertitype中是否存在，不存在则插入数据，
Union = dictStrList.Union(listStrList).ToList <string>();
//取交集
InterSect = dictStrList.Intersect(listStrList).ToList <string>();
//逻辑删除关系类别
foreach (var listItem in listStrList)
{
if (!InterSect.Contains(listItem))
{
var typeModel = list.Where(o => o.MT_TCode == listItem);
if (typeModel.Count() > 0)
{
typeModel.First().Stat = 1;
instance.Update(typeModel.First());
}
}
}
//更新和插入Type
foreach (var item in Union)
{
var typeModel = list.Where(o => o.MT_TCode == item);
var dictModel = dictList.Where(o => o.Dict_Code == item);
if (typeModel.Count() > 0)
{
//更新
if (dictModel.First().Dict_Name != typeModel.First().MT_TName)
{
typeModel.First().MT_TName = dictModel.First().Dict_Name;
typeModel.First().MT_TPCode = dictModel.First().Dict_PCode;
typeModel.First().MT_Order = dictModel.First().Dict_Order;
instance.Update(typeModel.First());
}
}
else
{
//插入
WH_MaterialType model = new WH_MaterialType();
model.MT_Code = Bll_Comm.GetTableKey("WH_MaterialType");
model.MT_TCode = dictModel.First().Dict_Code;
if (!string.IsNullOrEmpty(dictModel.First().Dict_PCode) && dictModel.First().Dict_PCode != itype)
{
model.MT_TPCode = dictModel.First().Dict_PCode;
}
model.MT_TName = dictModel.First().Dict_Name;
model.MT_Order = dictModel.First().Dict_Order;
model.MT_CompanyCode = companyCode;
var deptModel = deptInstance.GetModel(" AND Dept_Code='" + companyCode + "' ");
model.MT_Company = deptModel != null ? deptModel.Dept_Name : "";
instance.Insert(model);
}
}
result = true;
}
catch (System.Exception e)
{
throw;
}
}
return(result);
}
public string GetDeptCode(string DeptPCode)
{
return(Bll_Comm.GetTableKey("", "HR_Department", DeptPCode, ""));
}