//更新车间信息
public static int UpdateSingleOrgan(int _ID, int _OrganType, string[] FieldValues)
{
string sSqlText = "";
if (_ID > 0)
{
sSqlText = "begin UPDATE SysOrgan_Info SET OrganType=" + _OrganType.ToString() + ",POrganID=" + FieldValues.GetValue(0) + ", OrganNo='" + FieldValues.GetValue(1)
+ "',OrganName='" + FieldValues.GetValue(2) + "',Description='" + FieldValues.GetValue(3) + "'";
sSqlText = sSqlText + ",SortID=" + FieldValues.GetValue(4) + " WHERE ID=" + _ID + "" + ";";
string sLogText = "更新 人员管理>机构部门：" + FieldValues.GetValue(2) + "记录。";
sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;";
}
else
{
sSqlText = "begin Insert Into SysOrgan_Info (SystemID, OrganType, POrganID, OrganNo, OrganName, Description, SortID) Values(" + SysParams.GetPurviewSystemID().ToString() + ","
+ _OrganType.ToString() + "," + FieldValues.GetValue(0) + ",'" + FieldValues.GetValue(1) + "','"
+ FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "'," + FieldValues.GetValue(4) + ")" + ";";
string sLogText = "新增 人员管理>机构部门：" + FieldValues.GetValue(2) + "记录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
}
//Del by lk 20151214 start
//sSqlText += "Insert Into ToolStock_Info (OrganID, ToolID)"
// + " select "
// + " a.ID As OrganID, b.ID As ToolID from SysOrgan_Info a, Tool_Info b "
// + " Where a.OrganType in (0, 1) and a.OrganNo='" + FieldValues.GetValue(1) + "' and a.OrganType in (" + OrganType_Value.ToString() + "," + WorkshopType_Value.ToString() + ")"
// + " And Convert(varchar(10),a.ID) + '-' + Convert(varchar(10),b.ID) not in ("
// + " Select Convert(varchar(10),a.OrganID) + '-' + Convert(varchar(10),a.ToolID) From ToolStock_Info a, SysOrgan_Info b "
// + " where a.OrganID=b.ID and b.OrganNo='" + FieldValues.GetValue(1) + "')";
//Del by lk 20151214 end
return(DataCommon.QueryData(sSqlText));
}
public static int UpdateSinglePrefixCode(int ID, string[] FieldValues)
{
string sSqlText = "";
if (ID > 0)
{
sSqlText = "begin update SysPrefixCode_Info set CodeName='" + FieldValues.GetValue(0)
+ "',TableName='" + FieldValues[1] + ""
+ "',PrefixCode='" + FieldValues[2] + ""
+ "',Description='" + FieldValues[3] + "'"
+ " WHERE ID =" + ID + ";";
string sLogText = "更新 系统管理>单号前缀管理:单号前缀列表：" + FieldValues.GetValue(0) + "记录。";
sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;";
}
else
{
sSqlText = "begin Insert Into SysPrefixCode_Info(SystemID, CodeName, TableName, PrefixCode, Description)Values("
+ SysParams.GetPurviewSystemID().ToString() + ",'"
+ FieldValues.GetValue(0) + "','" + FieldValues.GetValue(1) + "','" + FieldValues.GetValue(2)
+ "','" + FieldValues.GetValue(3) + "')" + ";";
string sLogText = "新增 系统管理>单号前缀管理:单号前缀列表：" + FieldValues.GetValue(0) + "记录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
}
return(DataCommon.QueryData(sSqlText));
}
//更新添加无线电台档案信息
public static int UpdateSingleTools(int _ID, string[] FieldValues)
{
string sSqlText = "";
if (_ID > 0)
{
sSqlText = "begin UPDATE Tool_Info SET ToolNo='" + FieldValues.GetValue(0)
+ "',ToolName='" + FieldValues.GetValue(1) + "',Specification='" + FieldValues.GetValue(2)
+ "',MaterialCode='" + FieldValues.GetValue(3) + "',Unit='" + FieldValues.GetValue(4)
+ "',AliasesName='" + FieldValues.GetValue(5)
+ "',Description='" + FieldValues.GetValue(6) + "'";
sSqlText = sSqlText + ",SystemID=" + FieldValues.GetValue(7) + " WHERE ID=" + _ID + "" + ";";
string sLogText = "更新 人员管理>机构部门：" + FieldValues.GetValue(2) + "记录。";
sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;";
}
else
{
sSqlText = "begin Insert Into Tool_Info ( ToolNo, ToolName, AliasesName, Specification,MaterialCode,Unit,Description,SystemID) Values('"
+ FieldValues.GetValue(0) + "','" + FieldValues.GetValue(1) + "','"
+ FieldValues.GetValue(5) + "','" + FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "','" + FieldValues.GetValue(4) + "','" + FieldValues.GetValue(6) + "'," + FieldValues.GetValue(7) + ")" + ";";
string sLogText = "新增 人员管理>机构部门：" + FieldValues.GetValue(2) + "记录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
}
return(DataCommon.QueryData(sSqlText));
}
public static int DeleteRoleUser(int _ID)//===
{
string sSQL = "begin Delete from SysRole_Info Where Status =0 And ID=" + _ID.ToString() + "; ";
string sLogText = "删除 系统管理>角色下属人员:" + _ID.ToString() + "的记录。";
sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSQL));
}
//锁定用户登录
public static int StopUserByUser(int UserID)
{
string sSqlText = "begin UPDATE SysUser_Info SET IsCanLogin=0 WHERE ID=" + UserID + "; ";
string sLogText = "系统管理>权限管理> 锁定用户: " + UserID.ToString() + " 登录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSqlText));
}
//锁定用户登录
public static int StopCustomByCustom(int CustomID)
{
string sSqlText = "begin UPDATE SysCustomField_Info SET IsCanLogin=0 WHERE ID=" + CustomID + "; ";
string sLogText = "系统管理>权限管理> 锁定用户: " + CustomID.ToString() + " 登录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSqlText));
}
public static int DeleteMainDictionaries(int _ID)
{
string sSQL = "begin Delete from SysBaseDetail_Info Where Status=0 And ID=" + _ID.ToString() + "; ";
string sLogText = "删除 系统管理>人员管理 机构部门：ID:" + _ID.ToString() + "的记录。";
sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSQL));
}
public static int DeleteSingleCustom(int _ID)//===
{
string sSQL = "begin Delete from SysCustomField_Info Where Status =0 And ID=" + _ID.ToString() + "; ";
string sLogText = "删除 系统管理>人员管理:" + _ID.ToString() + "的记录。";
sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSQL));
}
//获取单个车间信息
public static int DeleteSingleToolsNotice(int _ID)
{
string sSQL = "begin Delete from Notice_Info Where Status=0 And ID=" + _ID.ToString() + "; ";
string sLogText = "删除 系统管理>人员管理 机构部门：ID:" + _ID.ToString() + "的记录。";
sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSQL));
}
//更新用户密码
public static int UpdateCustomPassword(int CustomID, string Password)
{
string sSqlText = "begin UPDATE SysCustomField_Info SET Password='******' WHERE ID=" + CustomID + "; ";
string sLogText = "修改登录密码。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSqlText));
}
public static int DeleteSinglePrefixCode(int _ID)
{
string sSQL = "begin delete from SysPrefixCode_Info where Status =0 And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + " and ID=" + _ID.ToString() + "; ";
string sLogText = "删除 系统管理>单号前缀管理：单号前缀列表:" + _ID.ToString() + "的记录。";
sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSQL));
}
//获取单个车间信息
public static int DeleteSinglePackTools(int _IDs)
{
string sSQL = "begin Delete from Tool_Info Where Status=0 And ID in (" + _IDs.ToString() + "); ";
sSQL = sSQL + " Delete from ToolMember_Info Where Status=0 And PackToolID in (" + _IDs.ToString() + ");";
sSQL += " Delete From ToolStock_Info Where ToolID in (" + _IDs.ToString() + ");";
string sLogText = "删除 系统管理>人员管理 机构部门：ID:" + _IDs.ToString() + "的记录。";
sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSQL));
}
//删除部门
public static int DeleteSingleOrgan(string _IDs)
{
string sSQL = "begin Delete from SysOrgan_Info Where Status=0 "//And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString()
+ " And ID in (" + _IDs.ToString() + "); ";
//Del by lk 20151214 start
//sSQL += " Delete From ToolStock_Info Where OrganID in (" + _IDs.ToString() + ")";
//Del by lk 20151214 end
string sLogText = "删除 系统管理>人员管理 机构部门：ID:" + _IDs.ToString() + "的记录。";
sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSQL));
}
//系统登录
public static bool UserLogin(string sOpCode, string sPassword, System.Web.SessionState.HttpSessionState hsSession)
{
bool bSuccess = false;
SqlDataReader sda = GetUserLogin(sOpCode, sPassword);
if (sda.Read())
{
UserInfo info = new UserInfo();
info.UserID = int.Parse(sda["ID"].ToString());
info.OpGuid = sda["Guid"].ToString();
info.OpCode = sda["OpCode"].ToString();
info.OpName = sda["OpName"].ToString();
//权限移到选择系统界面
//info.UserRolePurview = GetPurviewByUserID(info.UserID);
info.Purview = info.UserRolePurview;
info.UserRoles = sda["UserRoles"].ToString();
info.IsAdmin = sda["IsAdmin"].ToString() == "1";
if (sda["LastDate"].ToString().Length > 0)
{
info.LastDate = DateTime.Parse(sda["LastDate"].ToString()).ToString("yyyy年MM月dd日 HH:mm:ss");
}
//info.PurviewSystemID = 0;
info.LastIp = sda["LastIP"].ToString();
info.LastComputerName = sda["LastComputerName"].ToString();
if (sda["OrganID"].ToString().Length > 0)
{
info.OrganID = SysClass.SysOrgan.GetWorkShopByOrganID(int.Parse(sda["OrganID"].ToString()));
}
else
{
info.OrganID = SysClass.SysOrgan.GetTopOrganID(0);
}
CyxPack.UserCommonOperation.UserCommonOperation.StoreUserInfo(info);
// string IP = HttpContext.Current.Request.UserHostAddress;//获取客户端电脑IP
string IP = "";
System.Net.IPAddress[] addressList = Dns.GetHostByName(Dns.GetHostName()).AddressList;
IP = addressList[0].ToString();
string ComputerName;
ComputerName = System.Net.Dns.GetHostName(); //获取本地计算机的主机名
SysLogs.CreateUserLogin(info.UserID, info.OpCode, info.OpName, "用户登录系统。", IP, ComputerName);
SysClass.SysGlobal.CurrentUserOrganID = SysGlobal.GetCurrentUserOrganID();
bSuccess = true;
}
sda.Close();
return(bSuccess);
}
////更新用户信息
//public static int UpdateSingleUser(int UserID, string[] FieldValues)
//{
// string sSqlText = "";
// if (UserID > 0)
// {
// sSqlText = "UPDATE SysUser_Info SET OpName='"
// + FieldValues.GetValue(0) + "',OpCode='"
// + FieldValues.GetValue(1) + "',RoleID="
// + FieldValues.GetValue(2) + ",Comment='"
// + FieldValues[3] + "' WHERE ID=" + UserID;
// }
// else
// {
// sSqlText = "Insert Into SysUser_Info (OpName,OpCode,RoleID,Comment,Status, Password) Values('"
// + FieldValues.GetValue(0) + "','" + FieldValues.GetValue(1) + "','"
// + FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "',"
// + "0,'111111' )";
// }
// return DataCommon.QueryData(sSqlText);
//}
//更新用户信息
public static int UpdateSingleUserPurview(int UserID, string UserPurview)
{
string sSqlText = "";
sSqlText = "begin ";
sSqlText = sSqlText + " if not Exists(Select 1 From User_Purview Where Status=0 And UserID=" + UserID.ToString() + ")";
sSqlText = sSqlText + " Insert into User_Purview (SystemID, UserID, Purview, SortID, Status) Values(" + SysParams.GetPurviewSystemID().ToString() + "," + UserID.ToString() + ",'" + UserPurview + "',0,0" + ");";
sSqlText = sSqlText + " else ";
sSqlText = sSqlText + " Update User_Purview Set Purview='" + UserPurview + "' Where Status=0 and UserID=" + UserID.ToString() + "; ";
string sLogText = " 更新 系统管理>权限管理： " + UserID.ToString() + " 记录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
return(DataCommon.QueryData(sSqlText));
}
public static int UpdateSingleUser(int ID, string[] FieldValues)
{
string sSqlText = "begin ";
if (ID > 0)
{
sSqlText = sSqlText + "begin UPDATE SysUser_Info SET OpCode = '" + FieldValues.GetValue(0)
+ "',OpName='" + FieldValues.GetValue(1)
+ "',OrganID='" + FieldValues.GetValue(2)
+ "',Position='" + FieldValues.GetValue(3)
+ "',Place='" + FieldValues.GetValue(4)
+ "',Sex='" + FieldValues.GetValue(5)
+ "',Phone='" + FieldValues.GetValue(6)
+ "',TelNo='" + FieldValues.GetValue(7)
+ "',Address='" + FieldValues.GetValue(8)
+ "',UserDesc='" + FieldValues.GetValue(9)
+ "',IDNumber='" + FieldValues.GetValue(10)
+ "',ZipCode='" + FieldValues.GetValue(12)
+ "',IsCanLogin='******'";
sSqlText = sSqlText + " WHERE ID =" + ID + ";";
string sLogText = "更新 系统管理>人员管理 ：" + FieldValues.GetValue(0) + "|" + FieldValues.GetValue(1) + " 记录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
}
else
{
sSqlText = sSqlText + "begin Insert Into SysUser_Info(SystemID, Guid, OpCode, OpName,"
+ " OrganID,Position,Place,Sex,Phone,TelNo,Address,UserDesc,IDNumber,Password,ZipCode, IsCanLogin, Status) "
+ " Values(" + SysParams.GetPurviewSystemID().ToString() + ",'" + FieldValues.GetValue(13) + "','"
+ FieldValues.GetValue(0) + "','" + FieldValues.GetValue(1) + "','"
+ FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "','"
+ FieldValues.GetValue(4) + "','" + FieldValues.GetValue(5) + "','"
+ FieldValues.GetValue(6) + "','" + FieldValues.GetValue(7) + "','"
+ FieldValues.GetValue(8) + "','" + FieldValues.GetValue(9) + "','"
+ FieldValues.GetValue(10) + "','" + FieldValues.GetValue(11) + "','"
+ FieldValues.GetValue(12) + "'," + FieldValues.GetValue(14);
sSqlText = sSqlText + ",0 ); ";
string sLogText = "新增 系统管理>人员管理 ： " + FieldValues.GetValue(0) + "|" + FieldValues.GetValue(1) + " 记录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
}
sSqlText = sSqlText + " end";
return(DataCommon.QueryData(sSqlText));
}
//更新添加工具档案信息
public static int UpdateSingleBaseDate(int _ID, string[] FieldValues)
{
string sSqlText = "";
if (_ID > 0)
{
sSqlText = "begin UPDATE SysBaseDetail_Info SET MainNo=" + FieldValues.GetValue(0) + ", DetailNo='" + FieldValues.GetValue(1)
+ "',DetailName='" + FieldValues.GetValue(2) + "',Description='" + FieldValues.GetValue(3) + "'";
sSqlText = sSqlText + ",SortID=" + FieldValues.GetValue(4) + " WHERE ID=" + _ID + "" + ";";
string sLogText = "更新 人员管理>机构部门：" + FieldValues.GetValue(2) + "记录。";
sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;";
}
else
{
sSqlText = "begin Insert Into SysBaseDetail_Info ( MainNo, DetailNo, DetailName, Description,SortID) Values("
+ FieldValues.GetValue(0) + ",'" + FieldValues.GetValue(1) + "','"
+ FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "'," + FieldValues.GetValue(4) + ")" + ";";
string sLogText = "新增 人员管理>机构部门：" + FieldValues.GetValue(2) + "记录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
}
return(DataCommon.QueryData(sSqlText));
}
public static int UpdateSingleRole(int ID, string[] FieldValues)
{
string sSqlText = "";
if (ID > 0)
{
sSqlText = "begin update SysRole_Info set RoleName='" + FieldValues.GetValue(0)
+ "',Description='" + FieldValues[1] + ""
+ "',Purview='" + FieldValues[2] + "'"
+ " WHERE ID =" + ID + ";";
string sLogText = "更新 系统管理>角色管理:角色列表：" + FieldValues.GetValue(0) + "记录。";
sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;";
}
else
{
sSqlText = "begin Insert Into SysRole_Info(SystemID, RoleName,Description, Purview,Status) Values(" + SysParams.GetPurviewSystemID().ToString() + ",'"
+ FieldValues.GetValue(0) + "','" + FieldValues.GetValue(1) + "','" + FieldValues.GetValue(2) + "',0 )" + ";";
string sLogText = "新增 系统管理>角色管理:角色列表：" + FieldValues.GetValue(0) + "记录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
}
return(DataCommon.QueryData(sSqlText));
}
//更新添加工具档案信息
public static int UpdateSingleTools(int _ID, string[] FieldValues)
{
string sSqlText = "";
if (_ID > 0)
{
sSqlText = "begin UPDATE Tool_Info SET CategoryID=" + FieldValues.GetValue(0) + ", ToolNo='" + FieldValues.GetValue(1)
+ "',ToolName='" + FieldValues.GetValue(2) + "',AliasesName='" + FieldValues.GetValue(3)
+ "',Specification='" + FieldValues.GetValue(4) + "',MaterialCode='"
+ FieldValues.GetValue(5) + "',Unit='" + FieldValues.GetValue(6)
+ "',PurchasePrice=" + FieldValues.GetValue(7) + ",SalesPrice=" + FieldValues.GetValue(8)
+ ",IsCode=" + FieldValues.GetValue(9)
+ ",Description='" + FieldValues.GetValue(10) + "'";
sSqlText = sSqlText + " WHERE ID=" + _ID + "" + ";";
string sLogText = "更新 人员管理>机构部门：" + FieldValues.GetValue(2) + "记录。";
sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;";
}
else
{
sSqlText = "begin Insert Into Tool_Info ( CategoryID, ToolNo, ToolName, AliasesName, Specification,MaterialCode,Unit,PurchasePrice,SalesPrice,IsCode, Description) Values("
+ FieldValues.GetValue(0) + ",'" + FieldValues.GetValue(1) + "','"
+ FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "','" + FieldValues.GetValue(4) + "','" + FieldValues.GetValue(5) + "','" + FieldValues.GetValue(6) + "'," + FieldValues.GetValue(7) + "," + FieldValues.GetValue(8) + "," + FieldValues.GetValue(9) + ",'" + FieldValues.GetValue(10) + "')" + ";";
string sLogText = "新增 人员管理>机构部门：" + FieldValues.GetValue(2) + "记录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
}
sSqlText += "Insert Into ToolStock_Info (OrganID, ToolID)"
+ " select "
+ " a.ID As OrganID, b.ID As ToolID from SysOrgan_Info a, Tool_Info b "
+ " Where a.OrganType in (0, 1) and b.ToolNo='" + FieldValues.GetValue(1) + "'"
+ " And Convert(varchar(10),a.ID) + '-' + Convert(varchar(10),b.ID) not in ("
+ " Select Convert(varchar(10),a.OrganID) + '-' + Convert(varchar(10),a.ToolID) From ToolStock_Info a, Tool_Info b "
+ " where a.ToolID=b.ID and b.ToolNo='" + FieldValues.GetValue(1) + "')";
return(DataCommon.QueryData(sSqlText));
}
//更新添加工具档案信息
public static int UpdateSinglePurchaseCredit(int _ID, string[] FieldValues)
{
string sSqlText = "";
if (_ID > 0)
{
sSqlText = "begin UPDATE PurchaseCredit_Info SET OrganID=" + FieldValues.GetValue(0) + ", PurchaseYear=" + FieldValues.GetValue(1)
+ ",TotalCredit=" + FieldValues.GetValue(2) + ",Credit1=" + FieldValues.GetValue(3)
+ ",Credit2=" + FieldValues.GetValue(4) + ",Credit3=" + FieldValues.GetValue(5)
+ ",Credit4=" + FieldValues.GetValue(6) + ",Credit5=" + FieldValues.GetValue(7)
+ ",Credit6=" + FieldValues.GetValue(8) + ",Credit7=" + FieldValues.GetValue(9)
+ ",Credit8=" + FieldValues.GetValue(10) + ",Credit9=" + FieldValues.GetValue(11)
+ ",Credit10=" + FieldValues.GetValue(12) + ",Credit11=" + FieldValues.GetValue(13)
+ ",Credit12=" + FieldValues.GetValue(14) + ",Description='" + FieldValues.GetValue(15) + "'";
sSqlText = sSqlText + ",SortID=" + FieldValues.GetValue(10) + " WHERE ID=" + _ID + "" + ";";
string sLogText = "更新 人员管理>机构部门：" + FieldValues.GetValue(2) + "记录。";
sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;";
}
else
{
sSqlText = "begin Insert Into PurchaseCredit_Info ( OrganID, PurchaseYear, TotalCredit, Credit1, Credit2, Credit3, Credit4,"
+ " Credit5, Credit6, Credit7, Credit8, Credit9, Credit10, Credit11, Credit12, Description) Values("
+ FieldValues.GetValue(0) + "," + FieldValues.GetValue(1) + ","
+ FieldValues.GetValue(2) + "," + FieldValues.GetValue(3) + ","
+ FieldValues.GetValue(4) + "," + FieldValues.GetValue(5) + ","
+ FieldValues.GetValue(6) + "," + FieldValues.GetValue(7) + ","
+ FieldValues.GetValue(8) + "," + FieldValues.GetValue(9) + ","
+ FieldValues.GetValue(10) + "," + FieldValues.GetValue(11) + ","
+ FieldValues.GetValue(12) + "," + FieldValues.GetValue(13) + ","
+ FieldValues.GetValue(14) + ",'" + FieldValues.GetValue(15) + "')" + ";";
string sLogText = "新增 人员管理>机构部门：" + FieldValues.GetValue(2) + "记录。";
sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;";
}
return(DataCommon.QueryData(sSqlText));
}
