/// <summary>
/// 校验提成工资项是否被使用
/// </summary>
/// <param name="itemNo">提成工资项编号</param>
/// <param name="companyCD">公司代码</param>
/// <returns></returns>
public static bool IsUsedItem(string itemNo, string companyCD)
{
//校验SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" COUNT(*) AS UsedCount ");
searchSql.AppendLine(" FROM ");
searchSql.AppendLine(" officedba.SalaryStandard ");
searchSql.AppendLine(" WHERE ");
searchSql.AppendLine(" CompanyCD=@CompanyCD and ItemNo = @ItemNo ");
SqlCommand cmd = new SqlCommand();
//设置SQL语句
cmd.CommandText = searchSql.ToString();
//工资项编号
cmd.Parameters.Add(SqlHelper.GetParameterFromString("@ItemNo", itemNo));
cmd.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", companyCD));
//执行查询
DataTable dtCount = SqlHelper.ExecuteSearch(cmd);
//获取记录数
int count = GetSafeData.ValidateDataRow_Int(dtCount.Rows[0], "UsedCount");
//返回结果
return(count > 0 ? true : false);
}
/// <summary>
/// 根据ID获取分类信息
/// </summary>
/// <returns></returns>
public static CodeEquipmentTypeModel GetCodeBigTypeById(int id, string TableName)
{
CodeEquipmentTypeModel model = new CodeEquipmentTypeModel();
string sql = "select * from " + TableName + " where id=@id ";
SqlParameter[] param = new SqlParameter[1];
param[0] = SqlHelper.GetParameter("@id", id);
DataTable dt = SqlHelper.ExecuteSql(sql, param);
DataRow data = dt.Rows[0];
if (dt.Rows.Count > 0)
{
model.SupperID = GetSafeData.ValidateDataRow_Int(data, "SupperID");
model.ModifiedDate = GetSafeData.ValidateDataRow_DateTime(data, "ModifiedDate");
model.UsedStatus = GetSafeData.ValidateDataRow_String(data, "UsedStatus");
model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID");
model.CodeName = GetSafeData.ValidateDataRow_String(data, "CodeName");
model.CompanyCD = GetSafeData.ValidateDataRow_String(data, "CompanyCD");
model.Description = GetSafeData.ValidateDataRow_String(data, "Description");
if (TableName == "officedba.CodeCompanyType")// 往来单位
{
model.BigType = GetSafeData.ValidateDataRow_String(data, "BigType");
}
else if (TableName == "officedba.CodeProductType")
{
model.BigType = GetSafeData.ValidateDataRow_String(data, "TypeFlag");
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 根据ID获取文档信息
/// </summary>
/// <returns></returns>
public static CodeEquipmentTypeModel GetodeDocType(int id)
{
CodeEquipmentTypeModel model = new CodeEquipmentTypeModel();
string sql = "select * from officedba.CodeDocType where id=@id ";
SqlParameter[] param = new SqlParameter[1];
param[0] = SqlHelper.GetParameter("@id", id);
DataTable dt = SqlHelper.ExecuteSql(sql, param);
DataRow data = dt.Rows[0];
if (dt.Rows.Count > 0)
{
model.SupperID = GetSafeData.ValidateDataRow_Int(data, "SupperID");
model.ModifiedDate = GetSafeData.ValidateDataRow_DateTime(data, "ModifiedDate");
model.UsedStatus = GetSafeData.ValidateDataRow_String(data, "UsedStatus");
model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID");
model.CodeName = GetSafeData.ValidateDataRow_String(data, "CodeName");
model.CompanyCD = GetSafeData.ValidateDataRow_String(data, "CompanyCD");
model.Description = GetSafeData.ValidateDataRow_String(data, "Description");
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 查询公司是否有销售模块
/// </summary>
/// <param name="companyCD">公司代码</param>
/// <returns></returns>
public static bool IsHaveSellInfo(string companyCD)
{
#region 查询语句
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" COUNT(ModuleID) AS ModuleCount ");
searchSql.AppendLine(" FROM ");
searchSql.AppendLine(" pubdba.CompanyModule ");
searchSql.AppendLine(" WHERE ");
searchSql.AppendLine(" CompanyCD = @CompanyCD ");
searchSql.AppendLine(" AND CONVERT(VARCHAR, ModuleID) LIKE '203%'");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", companyCD));
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
DataTable dtModuleInfo = SqlHelper.ExecuteSearch(comm);
int rowCount = 0;
if (dtModuleInfo != null && dtModuleInfo.Rows.Count > 0)
{
rowCount = GetSafeData.ValidateDataRow_Int(dtModuleInfo.Rows[0], "ModuleCount");
}
return(rowCount > 0 ? true : false);
}
private static OtherCorpInfoModel ChangeOtherCorpInfoModel(DataRow data)
{
//定义返回的 EmployeeInfoModel
OtherCorpInfoModel model = new OtherCorpInfoModel();
//人员信息存在时，转化为model形式的数据
if (data != null)
{
model.ID = GetSafeData.ValidateDataRow_Int(data, "ID");
model.CompanyCD = GetSafeData.ValidateDataRow_String(data, "CompanyCD");
model.BigType = GetSafeData.ValidateDataRow_String(data, "BigType");
model.CustNo = GetSafeData.ValidateDataRow_String(data, "CustNo");
model.CustName = GetSafeData.ValidateDataRow_String(data, "CustName");
model.CorpNam = GetSafeData.ValidateDataRow_String(data, "CorpNam");
model.PYShort = GetSafeData.ValidateDataRow_String(data, "PYShort");
model.CustNote = GetSafeData.ValidateDataRow_String(data, "CustNote");
model.AreaID = GetSafeData.GetStringFromInt(data, "AreaID");
model.CompanyType = GetSafeData.ValidateDataRow_String(data, "CompanyType");
model.StaffCount = GetSafeData.GetStringFromInt(data, "StaffCount");
model.SetupDate = GetSafeData.ValidateDataRow_String(data, "SetupDate");
model.ArtiPerson = GetSafeData.ValidateDataRow_String(data, "ArtiPerson");
model.SetupMoney = GetSafeData.GetStringFromDecimal(data, "SetupMoney");
model.SetupAddress = GetSafeData.ValidateDataRow_String(data, "SetupAddress");
model.CapitalScale = GetSafeData.GetStringFromDecimal(data, "CapitalScale");
model.SaleroomY = GetSafeData.GetStringFromDecimal(data, "SaleroomY");
model.ProfitY = GetSafeData.GetStringFromDecimal(data, "ProfitY");
model.TaxCD = GetSafeData.ValidateDataRow_String(data, "TaxCD");
model.BusiNumber = GetSafeData.ValidateDataRow_String(data, "BusiNumber");
model.isTax = GetSafeData.ValidateDataRow_String(data, "isTax");
model.SellArea = GetSafeData.ValidateDataRow_String(data, "SellArea");
model.CountryID = GetSafeData.GetStringFromInt(data, "CountryID");
model.Province = GetSafeData.ValidateDataRow_String(data, "Province");
model.City = GetSafeData.ValidateDataRow_String(data, "City");
model.Post = GetSafeData.ValidateDataRow_String(data, "Post");
model.ContactName = GetSafeData.ValidateDataRow_String(data, "ContactName");
model.Tel = GetSafeData.ValidateDataRow_String(data, "Tel");
model.Fax = GetSafeData.ValidateDataRow_String(data, "Fax");
model.Mobile = GetSafeData.ValidateDataRow_String(data, "Mobile");
model.email = GetSafeData.ValidateDataRow_String(data, "email");
model.Addr = GetSafeData.ValidateDataRow_String(data, "Addr");
model.BillType = GetSafeData.ValidateDataRow_String(data, "BillType");
model.PayType = GetSafeData.GetStringFromInt(data, "PayType");
model.MoneyType = GetSafeData.GetStringFromInt(data, "MoneyType");
model.CurrencyType = GetSafeData.GetStringFromInt(data, "CurrencyType");
model.Remark = GetSafeData.ValidateDataRow_String(data, "Remark");
model.UsedStatus = GetSafeData.ValidateDataRow_String(data, "UsedStatus");
model.Creator = GetSafeData.GetStringFromInt(data, "Creator");
model.CreateDate = GetSafeData.GetStringFromDateTime(data, "CreateDate", "yyyy-MM-dd");
model.ModifiedDate = GetSafeData.GetStringFromDateTime(data, "ModifiedDate", "yyyy-MM-dd");
model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID");
model.EmployeeName = GetSafeData.ValidateDataRow_String(data, "EmployeeName");
}
return(model);
}
/// <summary>
/// 根据编码规则获取单据编号
/// </summary>
/// <param name="codeID">编码规则ID</param>
/// <returns></returns>
public static string GetCodeValue(string codeID)
{
//上次生成的最大流水号
//int lastpreNo =-1;
//定义返回的值
string codeValue = "";
//获取编码规则详细设置内容
DataTable ruleData = ItemCodingRuleDBHelper.GetCodingRuleInfoWithID(codeID);
//数据存在时进行Code生成操作
if (ruleData != null && ruleData.Rows.Count > 0)
{
//获取编码示例
string ruleExample = GetSafeData.ValidateDataRow_String(ruleData.Rows[0], "RuleExample");
//编码示例长度小于4时，进行设置
if (!string.IsNullOrEmpty(ruleExample) && ruleExample.Length > 4)
{
//获取流水号类型
int start = ruleExample.LastIndexOf(ConstUtil.RULE_EXAMPLE_START);
string ruleNoType = ruleExample.Substring(start);
//获取当前流水号最大值
string lastNo = GetSafeData.ValidateDataRow_Int(ruleData.Rows[0], "LastNo").ToString();
//编码流水号长度
int ruleNoLen = GetSafeData.ValidateDataRow_Int(ruleData.Rows[0], "RuleNoLen");
//长度不够时左边添加0
lastNo = lastNo.PadLeft(ruleNoLen, ConstUtil.RULE_EXAMPLE_ZERO);
//替换流水号
codeValue = ruleExample.Replace(ruleNoType, lastNo);
//获取编码类型
string codingType = GetSafeData.ValidateDataRow_String(ruleData.Rows[0], "CodingType");
//编码类型为单据时，替换日期设置
if (!ConstUtil.CODING_RULE_TYPE_ZERO.Equals(codingType))
{
//获取流水号类型
start = ruleExample.IndexOf(ConstUtil.RULE_EXAMPLE_START);
int end = ruleExample.IndexOf(ConstUtil.RULE_EXAMPLE_END);
string dateType = ruleExample.Substring(start, end - start + 1);
//获取当前日期值
string dateTypeValue = DateTime.Now.ToString(dateType.Substring(1, dateType.Length - 2));
//替换日期类型
codeValue = codeValue.Replace(dateType, dateTypeValue);
}
}
}
//返回生成的单据编号
return(codeValue);
}
/// <summary>
/// 根据编码类型以及单据代码或基础数据代码获取编码规则信息
/// </summary>
private void BindCodingRule()
{
string strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;//"C1002";
//分类标识未设置时，不进行绑定
if (string.IsNullOrEmpty(this.CodingType) || string.IsNullOrEmpty(this.ItemTypeID))
{
return;
}
//查询分类标识信息
DataTable dt = BatchNoRuleSetBus.GetBatchRuleInfoForDrp(strCompanyCD);//ItemCodingRuleBus.GetCodingRuleInfoForDrp(this.CodingType, this.ItemTypeID);
//分类标识存在时绑定数据
if (dt != null && dt.Rows.Count > 0)
{
//设置列表项的文本内容的数据源字段
ddlBatchRule.DataTextField = "RuleName";
//设置列表项的提供值的数据源字段。
ddlBatchRule.DataValueField = "ID";
//设置列表项的数据源
ddlBatchRule.DataSource = dt;
//绑定列表的数据源
ddlBatchRule.DataBind();
//获取默认编码规则
DataRow[] drDefault = dt.Select("IsDefault = '" + ConstUtil.CODING_RULE_DEFAULT_TRUE + "'");
//存在默认编码规则时，设定默认编码规则为选中项
if (drDefault.Length > 0)
{
//获取默认编码规则的ID
string selectID = GetSafeData.ValidateDataRow_Int(drDefault[0], "ID").ToString();
//设置为选中项
ddlBatchRule.SelectedValue = selectID;
//设置提示信息
txtBatch.Text = ConstUtil.CODING_RULE_DISPLAY_TEXT;
//设置为不可编辑
txtBatch.Enabled = false;
}
}
//添加一请选择选项
ListItem Item = new ListItem(ConstUtil.CODING_RULE_INSERT_TEXT, ConstUtil.CODING_RULE_INSERT_VALUE);
ddlBatchRule.Items.Insert(0, Item);
}
/// <summary>
/// 校验面试评测要素是否被引用
/// </summary>
/// <param name="elemID">要素ID</param>
/// <returns></returns>
public static bool IsRectCheckElemUsed(string elemID, string CompanyCD)
{
//校验SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" COUNT(*) AS UsedCount ");
searchSql.AppendLine(" FROM ");
searchSql.AppendLine(" officedba.RectCheckTemplateElem ");
searchSql.AppendLine(" WHERE CompanyCD='" + CompanyCD + "'and ");
searchSql.AppendLine("CheckElemID in (" + elemID + ")");
//执行查询
DataTable dtCount = SqlHelper.ExecuteSql(searchSql.ToString());
//获取记录数
int count = GetSafeData.ValidateDataRow_Int(dtCount.Rows[0], "UsedCount");
//返回结果
return(count > 0 ? true : false);
}
public static bool IsExist(string TemplateNo, string CompanyCD)
{
//校验SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" COUNT(*) AS UsedCount ");
searchSql.AppendLine(" FROM ");
searchSql.AppendLine(" officedba.PerformanceTemplate ");
searchSql.AppendLine(" WHERE CompanyCD='" + CompanyCD + "' ");
searchSql.AppendLine("and TemplateNo='" + TemplateNo + "'");
//执行查询
DataTable dtCount = SqlHelper.ExecuteSql(searchSql.ToString());
//获取记录数
int count = GetSafeData.ValidateDataRow_Int(dtCount.Rows[0], "UsedCount");
//返回结果
return(count > 0 ? true : false);
}
/// <summary>
/// 根据编码规则ID获取编码规则数据
/// </summary>
/// <param name="codeID">编码规则ID</param>
/// <returns></returns>
public static DataTable GetCodingRuleInfoWithID(string codeID)
{
//定义查询SQL变量
StringBuilder searchSql = new StringBuilder();
//定义查询语句
searchSql.AppendLine(" SELECT ID ");
searchSql.AppendLine(" ,CompanyCD ");
searchSql.AppendLine(" ,CodingType ");
searchSql.AppendLine(" ,ItemTypeID ");
searchSql.AppendLine(" ,RuleName ");
searchSql.AppendLine(" ,RulePrefix ");
searchSql.AppendLine(" ,RuleDateType ");
searchSql.AppendLine(" ,RuleNoLen ");
searchSql.AppendLine(" ,LastNo ");
searchSql.AppendLine(" ,RuleExample ");
searchSql.AppendLine(" ,IsDefault ");
searchSql.AppendLine(" ,Remark ");
searchSql.AppendLine(" ,UsedStatus ");
searchSql.AppendLine(" ,ModifiedDate ");
searchSql.AppendLine(" ,ModifiedUserID");
searchSql.AppendLine(" FROM ");
searchSql.AppendLine(" officedba.ItemCodingRule ");
searchSql.AppendLine("WHERE ");
searchSql.AppendLine(" ID = @CodeID ");
//设置参数
SqlParameter[] param = new SqlParameter[1];
//编码规则ID
param[0] = SqlHelper.GetParameter("@CodeID", codeID);
//执行查询并返回的查询到的分类信息
DataTable data = SqlHelper.ExecuteSql(searchSql.ToString(), param);
//数据存在时，更新当前流水号最大值
bool updateFlag = false; //更新成功标识
if (data.Rows.Count > 0)
{
//编码流水号长度
int ruleNoLen = GetSafeData.ValidateDataRow_Int(data.Rows[0], "RuleNoLen");
//定义最大流水号
string maxNo = string.Empty;
//最大流水号
for (int i = 0; i < ruleNoLen; i++)
{
maxNo += "9";
}
//获取当前流水号最大值
int lastNo = GetSafeData.ValidateDataRow_Int(data.Rows[0], "LastNo");
//当前最大流水号+1
int updateNo = lastNo + 1;
//当前最大流水号+1 大于 最大流水号时，从1开始记数
if (updateNo > int.Parse(maxNo))
{
return(null);
//updateNo = 1;
}
//重新设置最大流水号，生成编号不用重复计算
data.Rows[0]["LastNo"] = updateNo;
//更新操作
StringBuilder updateSql = new StringBuilder();
updateSql.AppendLine(" UPDATE officedba.ItemCodingRule ");
updateSql.AppendLine(" SET ");
updateSql.AppendLine(" LastNo = @LastNo ");
updateSql.AppendLine(" WHERE ID = @CodeID ");
//设置参数
SqlParameter[] updatePram = new SqlParameter[2];
//编码规则ID
updatePram[0] = SqlHelper.GetParameter("@CodeID", codeID);
//最大流水号
updatePram[1] = SqlHelper.GetParameter("@LastNo", updateNo);
//执行更新
updateFlag = SqlHelper.ExecuteTransSql(updateSql.ToString(), updatePram) > 0 ? true:false;
}
//返回获取的数据
if (updateFlag)
{
return(data);
}
return(null);
}
/// <summary>
/// 获取岗位信息树
/// </summary>
/// <param name="dtDeptQuarterInfo">岗位信息</param>
/// <returns></returns>
private static string GetQuarterTreeInfo(DataTable dtDeptQuarterInfo)
{
//定义变量
StringBuilder sbDeptQuarterInfo = new StringBuilder();
//数据存在时
if (dtDeptQuarterInfo != null && dtDeptQuarterInfo.Rows.Count > 0)
{
//获取记录数
int deptQuarterCount = dtDeptQuarterInfo.Rows.Count;
//遍历所有机构岗位，以显示数据
for (int i = 0; i < dtDeptQuarterInfo.Rows.Count; i++)
{
//获取岗位ID
string quarterID = GetSafeData.GetStringFromInt(dtDeptQuarterInfo.Rows[i], "ID");
//获取岗位名称
string quarterName = GetSafeData.ValidateDataRow_String(dtDeptQuarterInfo.Rows[i], "QuarterName");
//获取父岗位
string superQuarterID = GetSafeData.GetStringFromInt(dtDeptQuarterInfo.Rows[i], "SuperQuarterID");
//获取所属机构
string deptID = GetSafeData.GetStringFromInt(dtDeptQuarterInfo.Rows[i], "DeptID");
//获取是否有子岗位
int subCount = GetSafeData.ValidateDataRow_Int(dtDeptQuarterInfo.Rows[i], "SubCount");
//样式名称
string className = "file";
//Javascript事件名
string jsAction = "";
//样式表名称
string showClass = "list";
//有子结点时
if (subCount > 0)
{
//最后一个结点
if (i == deptQuarterCount - 1)
{
className = "folder_close_end";
showClass = "list_last";
}
else
{
className = "folder_close";
}
jsAction = "onclick=\"ShowDeptQuarterTree('" + quarterID + "');\"";
}
else if (i == deptQuarterCount - 1)
{
className = "file_end";
}
//生成子树代码
sbDeptQuarterInfo.Append("<table border='0' cellpadding='0' cellspacing='0'>");
sbDeptQuarterInfo.Append("<tr><td><div id='divQSuper_" + quarterID + "' class='" + className + "' " + jsAction
+ " alt='" + quarterName + "'><a href='#' onclick=\"SetSelectValue('"
+ quarterID + "','" + quarterName + "','" + superQuarterID + "','"
+ deptID + "');\"><div id='divQuarterName_" + quarterID
+ "'>" + " " + quarterName + "</div></a></div>");
sbDeptQuarterInfo.Append("<div id='divQSub_" + quarterID + "' style='display:none;' class='" + showClass + "'></div></td></tr>");
sbDeptQuarterInfo.Append("</table>");
}
}
//返回
return(sbDeptQuarterInfo.ToString());
}
/// <summary>
/// 获取人员信息
/// </summary>
/// <returns></returns>
//public static DataTable GetDeptQuarterEmployeeInfo()
//{
// //获取登陆用户信息
// UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
// //获取公司代码
// string companyCD = userInfo.CompanyCD;
// //执行查询
// return DeptQuarterEmployeeDBHelper.GetEmployeeInfoWithCompanyCD(companyCD);
//}
public static string GetDeptQuarterEmployeeInfo()
{
//定义变量
StringBuilder sbReturnInfo = new StringBuilder("<span style=\"font-size:15px; height:auto \">" + ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyName + " 组织机构图：</span> <br /> <br />");
//获取公司代码
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//获取机构信息
DataTable dtDeptInfo = DeptQuarterEmployeeDBHelper.GetDeptInfoWithCompanyCD(companyCD);
//获取人员信息
DataTable dtEmployeeInfo = DeptQuarterEmployeeDBHelper.GetEmployeeInfoWithCompanyCD(companyCD);
//信息存在
if (dtDeptInfo != null && dtDeptInfo.Rows.Count > 0)
{
//获取第一级信息
DataRow[] drSuper = dtDeptInfo.Select("SuperID IS NULL");
//遍历第一级
for (int i = 0; i < drSuper.Length; i++)
{
DataRow drFirst = (DataRow)drSuper[i];
//获取机构ID
int id = GetSafeData.ValidateDataRow_Int(drFirst, "ID");
//获取机构名
string deptName = GetSafeData.ValidateDataRow_String(drFirst, "DisplayName");
//设置样式表单
string style = "T";
//生成子树代码
//sbReturnInfo.Append("<table border='0' cellpadding='0' cellspacing='0'><tr><td>");
//获取机构的人员
DataRow[] drDeptEmpl = dtEmployeeInfo.Select("DeptID = " + id);
if (drDeptEmpl != null && drDeptEmpl.Length > 0)
{
//sbReturnInfo.Append("<div class=\"I\">");
for (int j = 0; j < drDeptEmpl.Length; j++)
{
//获取人员岗位
string quarterName = GetSafeData.ValidateDataRow_String(drDeptEmpl[j], "QuarterName");
//获取人员姓名
string emplName = GetSafeData.ValidateDataRow_String(drDeptEmpl[j], "EmployeeName");
//判断是否是最后一个
if (i == drSuper.Length - 1 && j == drDeptEmpl.Length - 1)
{
style = "L";
}
sbReturnInfo.Append("<div class=\"" + style + "\">");
sbReturnInfo.Append(deptName + "：" + quarterName + " " + emplName);
sbReturnInfo.Append("</div>");
}
//sbReturnInfo.Append("</div>");
}
else
{
//判断是否是最后一个
if (i == drSuper.Length - 1)
{
style = "L";
}
sbReturnInfo.Append("<div class=\"" + style + "\">");
sbReturnInfo.Append(deptName);
sbReturnInfo.Append("</div>");
}
//设置子信息
sbReturnInfo.Append(InitDeptSubInfo(dtDeptInfo, id, dtEmployeeInfo));
//sbReturnInfo.Append("</td></tr></table>");
}
}
//返回
return(sbReturnInfo.ToString());
}
/// <summary>
/// 设置子机构信息
/// </summary>
/// <param name="dtDeptInfo">机构信息</param>
/// <param name="id">机构ID</param>
/// <param name="dtEmployeeInfo">人员信息</param>
/// <returns></returns>
private static string InitDeptSubInfo(DataTable dtDeptInfo, int id, DataTable dtEmployeeInfo)
{
StringBuilder sbSubInfo = new StringBuilder();
//获取子信息
DataRow[] drSub = dtDeptInfo.Select("SuperID = " + id);
//
if (drSub != null && drSub.Length > 0)
{
//sbSubInfo.Append("<div class=\"I\">");
//生成子树代码
//sbSubInfo.Append("<table border='0' cellpadding='0' cellspacing='0'><tr><td>");
//遍历所有子信息
for (int i = 0; i < drSub.Length; i++)
{
//获取机构ID
int subId = GetSafeData.ValidateDataRow_Int(drSub[i], "ID");
//获取机构名
string subName = GetSafeData.ValidateDataRow_String(drSub[i], "DisplayName");
//设置样式表单
string style = "T";
//获取机构的人员
DataRow[] drDeptEmpl = dtEmployeeInfo.Select("DeptID = " + subId);
if (drDeptEmpl != null && drDeptEmpl.Length > 0)
{
sbSubInfo.Append("<div class=\"I\">");
for (int j = 0; j < drDeptEmpl.Length; j++)
{
//获取人员岗位
string quarterName = GetSafeData.ValidateDataRow_String(drDeptEmpl[j], "QuarterName");
//获取人员姓名
string emplName = GetSafeData.ValidateDataRow_String(drDeptEmpl[j], "EmployeeName");
//判断是否是最后一个
if (i == drSub.Length - 1 && j == drDeptEmpl.Length - 1)
{
style = "L";
}
sbSubInfo.Append("<div class=\"" + style + "\">");
sbSubInfo.Append(subName + "：" + quarterName + " " + emplName);
sbSubInfo.Append("</div>");
}
sbSubInfo.Append("</div>");
}
else
{
//判断是否是最后一个
if (i == drSub.Length - 1)
{
style = "L";
}
sbSubInfo.Append("<div class=\"" + style + "\">");
sbSubInfo.Append(subName);
sbSubInfo.Append("</div>");
}
//设置子信息
sbSubInfo.Append(InitDeptSubInfo(dtDeptInfo, subId, dtEmployeeInfo));
}
//sbSubInfo.Append("</td></tr></table>");
//sbSubInfo.Append("</div>");
}
return(sbSubInfo.ToString());
}
/// <summary>
/// 设置工资内容
/// </summary>
private string InitSalaryDetailInfo(string DeptID)
{
//定义变量
StringBuilder sbSalaryInfo = new StringBuilder();
//获取数据
DataTable dtSalaryInfo = SalaryCompanyRoyaltySetBus.GetInfoTable(DeptID);
//数据存在时
if (dtSalaryInfo != null && dtSalaryInfo.Rows.Count > 0)
{
//遍历显示所有数据
for (int i = 0; i < dtSalaryInfo.Rows.Count; i++)
{
//插入行开始标识
sbSalaryInfo.AppendLine("<tr>");
//选择框
if (i == dtSalaryInfo.Rows.Count - 1)
{
//选择
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtSalaryID_" + (i + 1).ToString() + "' value='"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ID")
+ "' /><input type='hidden' id='txtEditFlag_" + (i + 1).ToString() + "' value='1' />"
+ "<input type='checkbox' onclick='SetCheckAll(this);' id='chkSelect_" + (i + 1).ToString() + "' /></td>");
//公司名称
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' onclick=\"getsubcompany(this.id,'Hid'+this.id);\" readonly=\"readonly\" style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "DeptName")
+ "' class='tdinput' id='txtDept_" + (i + 1).ToString() + "' />"
+ "<input type='hidden' id='HidtxtDept_" + (i + 1).ToString() + "' value='" + GetSafeData.ValidateDataRow_Int(dtSalaryInfo.Rows[i], "DeptID") + "'></td>");
//业绩上限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' onkeydown='Numeric_OnKeyDown();' onchange='Number_round(this,\"0\");' readonly=\"readonly\" style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MiniMoney")
+ "' class='tdinput' id='txtMiniMoney_" + (i + 1).ToString() + "' /></td>");
//业绩下限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' onkeydown='Numeric_OnKeyDown();' onchange='Number_round(this,\"0\");' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MaxMoney")
+ "' class='tdinput' id='txtMaxMoney_" + (i + 1).ToString() + "' /></td>");
//提成率
sbSalaryInfo.AppendLine("<td class='tdColInput'>"
+ "<input type='text' maxlength = '3' style='width:98%;' onkeydown='Numeric_OnKeyDown();' onchange='Number_round(this,\"2\");' onblur='CalculateTotalSalary(this,\"" + (i + 1).ToString() + "\");' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "TaxPercent")
+ "' class='tdinput' id='txtTaxPercent_" + (i + 1).ToString() + "' /></td>");
}
else
{
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtSalaryID_" + (i + 1).ToString() + "' value='"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ID")
+ "' /><input type='hidden' id='txtEditFlag_" + (i + 1).ToString() + "' value='1' />"
+ "<input type='checkbox' onclick='SetCheckAll(this);' id='chkSelect_" + (i + 1).ToString() + "' style=\"display:none \" /></td>");
//公司名称
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' onclick=\"getsubcompany(this.id,'Hid'+this.id);\" readonly=\"readonly\" style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "DeptName")
+ "' class='tdinput' id='txtDept_" + (i + 1).ToString() + "' /><input type='hidden' id='HidtxtDept_" + (i + 1).ToString() + "'></td>");
//业绩上限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' onkeydown='Numeric_OnKeyDown();' readonly=\"readonly\" onchange='Number_round(this,\"0\");' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MiniMoney")
+ "' class='tdinput' id='txtMiniMoney_" + (i + 1).ToString() + "' /></td>");
//业绩下限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' onkeydown='Numeric_OnKeyDown();' readonly=\"readonly\" onchange='Number_round(this,\"0\");' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MaxMoney")
+ "' class='tdinput' id='txtMaxMoney_" + (i + 1).ToString() + "' /></td>");
//提成率
sbSalaryInfo.AppendLine("<td class='tdColInput'>"
+ "<input type='text' maxlength = '3' style='width:98%;' onkeydown='Numeric_OnKeyDown();' onchange='Number_round(this,\"2\");' readonly=\"readonly\" onblur='CalculateTotalSalary(this,\"" + (i + 1).ToString() + "\");' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "TaxPercent")
+ "' class='tdinput' id='txtTaxPercent_" + (i + 1).ToString() + "' /></td>");
}
//插入行结束标识
sbSalaryInfo.AppendLine("</tr>");
}
}
//返回信息
return(sbSalaryInfo.ToString());
}
/// <summary>
/// 文件上传操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpload_Click(object sender, ImageClickEventArgs e)
{
string companyCD = string.Empty;
//获取公司代码
try
{
companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
}
catch
{
companyCD = "AAAAAA";
}
//获取公司文件相关信息
DataTable dtFileInfo = UploadFileBus.GetCompanyUploadFileInfo();
//
if (dtFileInfo == null || dtFileInfo.Rows.Count < 1)
{
}
//文件个数
int docNum = GetSafeData.ValidateDataRow_Int(dtFileInfo.Rows[0], "MaxDocNum");
//文件总大小
long totalSize = GetSafeData.ValidateDataRow_Long(dtFileInfo.Rows[0], "MaxDocSize");
//单个文件大小
long singleSize = GetSafeData.ValidateDataRow_Long(dtFileInfo.Rows[0], "SingleDocSize");
//文件保存路径
string savePath = GetSafeData.ValidateDataRow_String(dtFileInfo.Rows[0], "DocSavePath");
//获取控件上的文件对象
HttpPostedFile hpFile = flLocalFile.PostedFile;
//FileInfo1 file = new FileInfo1();
//file.FileBytes = flLocalFile.PostedFile;
//Session["File"] = file;
string docName = hpFile.FileName.Substring(hpFile.FileName.LastIndexOf("\\") + 1);
//校验文件大小
string checkResult = CheckCompanyFile(hpFile, savePath, totalSize, singleSize, docNum);
//大小超过允许范围时
if (!string.IsNullOrEmpty(checkResult))
{
ClientScript.RegisterStartupScript(this.GetType(), "UploadFaild", "<script language=javascript>popMsgObj.ShowMsg('" + checkResult + "');</script>");
return;
}
string IsExistFilePath = savePath + "\\" + docName;
if (File.Exists(IsExistFilePath))//文件已经存在提示
{
ClientScript.RegisterStartupScript(this.GetType(), "UploadFaild", "<script language=javascript>popMsgObj.ShowMsg('文件名有重复，请重命名文件在上传！');</script>");
}
else
{
//上传文件并获取文件相对路径
string fileName = HtmlInputFileControl.SaveUploadFile(hpFile, savePath);
//上传未成功
if (string.IsNullOrEmpty(fileName))
{
ClientScript.RegisterStartupScript(this.GetType(), "UploadFaild", "<script language=javascript>popMsgObj.ShowMsg('"
+ ConstUtil.UPLOAD_FILE_ERROR_TYPE + "');</script>");
return;
}
//隐藏域中写入文件相对路径
uploadFileUrl.Value = fileName;
//上传文件名
uploadDocName.Value = docName;
//执行返回函数
ClientScript.RegisterStartupScript(this.GetType(), "UploadSucc", "<script language=javascript>DoConfirm();</script>");
}
}
