/// <summary>
/// 根据faterid 获取组织机构树
/// </summary>
/// <returns></returns>
public DataSet GetORGTreeByID(Dbconn conn, String strType)
{
DataSet ds = new DataSet();
String strSQL = "";
//获取条件值
string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
DataSet dsXML = Common.Common.GetDSByExcelXML(strXML);
string strPage = dsXML.Tables["LIST"].Rows[0]["Page"].ToString();
string strNum = dsXML.Tables["LIST"].Rows[0]["Num"].ToString();
string strCons = dsXML.Tables["LIST"].Rows[0]["Cons"].ToString();
string strOrderBy = dsXML.Tables["LIST"].Rows[0]["OrderBy"].ToString();
string[] strParam = new string[] { };
strSQL = @" SELECT [OZ1_OrgCode], [OZ1_OrgName], [OZ1_FatherId]
, [OZ1_OrgType], [OZ1_ID], [OZ1_CONO], [OZ1_DIVI], [OZ1_FatherId] As [OZ1_FatherIdT]
, [OZ1_CostCenterCode], [OZ1_DepartmentManager]
, [OZ1_MDeptCode], [OZ1_ShopCode], [OZ1_OrgEnable]
, [OZ1_CostCenterEnable], [OZ1_BusdepartmentEnable]
, [OZ1_ShopEnable], [OZ1_State], [OZ1_ModelType], [OZ1_BMMoney]
, [OZ1_Brand], [OZ1_Com], [OZ1_CostCenterCode1], [OZ1_BMPer]
, OZ1_Com1, OZ1_ComCode1, OZ1_ISBranch, OZ1_CostCenterCode2
FROM [F01_CERT].[OZ1_Organization]
WHERE 1=1 AND OZ1_OrgType <> '业务线' " + strCons + strOrderBy;
ds = conn.GetDataSet(strSQL);
return ds;
}
/// <summary>
/// 编辑系统属性信息
/// </summary>
/// <returns></returns>
public bool Execute()
{
Dbconn conn = new Dbconn("MDM");
try
{
string strProperty_ID = m_request.Tables[0].Rows[0]["Property_ID"].ToString();
m_request.Tables[0].Columns.Remove("Property_ID");
ArrayList listTable = new ArrayList();
listTable.Add("MDM_System_Property");
conn.BeginTransaction();
conn.TableLock(listTable);
if (strProperty_ID == "")
{
conn.Insert("MDM_System_Property", m_request.Tables[0]);
}
else
{
string strWhere = " Property_ID=" + strProperty_ID;
conn.Update("MDM_System_Property", m_request.Tables[0], strWhere);
}
conn.CommitTransaction();
return true;
}
catch
{
conn.RollbackTransaction();
throw;
}
}
public DataSet GetData()
{
Dbconn conn = new Dbconn("MDM");
return conn.GetDataSet(@"
SELECT t1.WS_ID ,
WS_LogicName
FROM dbo.WS_Scheduling t1 WITH ( NOLOCK )
WHERE t1.Enabled = 1
AND ( t1.Last_Execute_Right_Time IS NULL
OR ( DATEDIFF(s, t1.Last_Execute_Right_Time, GETDATE()) > t1.Excute_cycle
AND ISNULL(t1.Error_Count, 0) < 5
AND ISNULL(Execute_type, 'cycle') = 'cycle'
)
--按日
OR ( ( t1.Last_Execute_Right_Time IS NULL
--取今天没有跑过的数据
OR t1.Last_Execute_Right_Time < CONVERT(VARCHAR(10), GETDATE(), 23)
+ ' ' + t1.Execute_StartTime
--取今天跑过了，但是到了下一次的执行时间
OR DATEDIFF(s, t1.Last_Execute_Right_Time, GETDATE()) > t1.Excute_cycle
)
AND ISNULL(t1.Error_Count, 0) < 5
AND CONVERT(VARCHAR(8), GETDATE(), 14) > Execute_StartTime
AND ISNULL(Execute_type, 'cycle') = 'day'
)
)
ORDER BY WS_ID ;
SELECT *
FROM WS_SchedulingParam
");
}
/// <summary>
/// VEX框架的主入口
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
ds = Common.Common.GetDSByExcelXML(strXML);
DataTable dt_OPTYPE = ds.Tables["OPTYPE"];
string strOPTYPE = dt_OPTYPE.Rows[0][0].ToString();
strComp = m_hzyMessage.Env_SN;
conn = new Dbconn(strComp);
switch (strOPTYPE) {
case "cmbGetSupplier": cmbGetSupplier(); break;
case "cmbGetPo": cmbGetPo(); break;
case "cmbGetFailure": cmbGetFailure(); break;
case "cmbGetAP": cmbGetAP(); break;
case "onExpandRow": onExpandRow(); break;
case "Search": Search(); break;
case "winGetDetailOld": winGetDetailOld(); break;
case "winGetDetailNew": winGetDetailNew(); break;
case "Insert": Insert(); break;
case "GetWH": GetWH(); break;
};
return dsReturn;
}
catch
{
conn.RollbackTransaction();
throw;
}
}
/// <summary>
/// VEX框架的主入口
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
//接收XML的内容
string strXML = "",
strOPTYPE = "";
strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
strComp = m_hzyMessage.Env_SN;
conn = new Dbconn(strComp);
m_RequestXML = Common.Common.GetDSByExcelXML(strXML);
DataTable dt_OPTYPE = m_RequestXML.Tables["OPTYPE"];
dt_DefList = m_RequestXML.Tables["List"];
strOPTYPE = dt_OPTYPE.Rows[0][0].ToString();
switch (strOPTYPE)
{
case "GET": Get(); break;
case "GetOnExpandRow": GetOnExpandRow(); break;
case "GetSearch": GetSearch(); break;
case "GetSKC": GetSKC(); break;
case "SetDefective": SetDefective(); break;
case "GetPrintSearch": GetPrintSearch(); break;
};
return m_ReturnData;
}
catch
{
conn.RollbackTransaction();
throw;
};
}
/// <summary>
/// 获取MDM人员信息
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
string strVexSSONewID = m_hzyMessage.VexSSONewID;
Dbconn conn = new Dbconn("VexSSO");
DataSet ds = conn.GetDataSet(@"
SELECT 0 [Employee_ID] ,
t2.[Name] ,
'' [Sex] ,
t2.Phone [Phone] ,
t1.VexSSOLoginUser [Moblie] ,
t1.VexSSOLoginUser [SSO_UserName] ,
NULL [In_Time] ,
NULL [Leave_Time] ,
NULL [Leave_Flag] ,
NULL [IsActived]
FROM B01_MDM.[VEXSSOUser] t1
LEFT JOIN B01_MDM.[VexSSOUserInfo] t2 ON t2.VexSSONewId = t1.VexSSONewID
WHERE t1.VexSSONewId=@param0
", new string[1] { strVexSSONewID });
return ds;
}
catch
{
throw;
}
}
/// <summary>
/// 获取某个Market的Entity的所有属性列表
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
DataSet ds = new DataSet();
DataSet dsRequest = new DataSet();
string strEntity = "";
string strMarketTableName = "";
strEntity = m_request.Tables[0].Rows[0]["Entity"].ToString();
strMarketTableName = m_request.Tables[0].Rows[0]["MarketTableName"].ToString();
//获取所有的列
Dbconn conn = new Dbconn("MDM_Master");
ds = conn.GetDataSet(@"
SELECT t1.MainEntity,t2.Porperty_Name,t2.Table_Property_Name FROM dbo.Lib_View_Table t1
LEFT JOIN dbo.Lib_View_TableColumn t2 ON t1.Table_ID = t2.Table_ID
WHERE Table_Name='" + strMarketTableName + @"'
AND Entity='" + strEntity + @"'
AND Table_Type='Market'
");
return ds;
}
catch
{
throw;
}
}
/// <summary>
/// 根据条件获取待办任务数据集 条件-分页-排序等
/// </summary>
/// <returns></returns>
public DataSet GetWorkFlowTaskList(Dbconn conn, String strType)
{
DataSet ds = new DataSet();
String strSQL = "";
//获取条件值
string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
DataSet dsXML = Common.Common.GetDSByExcelXML(strXML);
string strPage = dsXML.Tables["LIST"].Rows[0]["Page"].ToString();
string strNum = dsXML.Tables["LIST"].Rows[0]["Num"].ToString();
string strCons1 = dsXML.Tables["LIST"].Rows[0]["Cons1"].ToString();
string strCons2 = dsXML.Tables["LIST"].Rows[0]["Cons2"].ToString();
string strCons3 = dsXML.Tables["LIST"].Rows[0]["Cons3"].ToString();
string strOrderBy = dsXML.Tables["LIST"].Rows[0]["OrderBy"].ToString();
String strXMLC = "【操作类型,GET】【实体,任务查询】【CONO,】【DIVI,】"
+ "【《W》页码," + strPage + "】【《W》记录数," + strNum + "】"
+ "【《W》查询条件1," + strCons1 + "】"
+ "【《W》查询条件2," + strCons2 + "】"
+ "【《W》查询条件3," + strCons3 + "】"
+ "【排序方式," + strOrderBy + "】"
+ "【Type," + strType + "】"
+ "【返回内容, 任务列表】";
ds = conn.GetDataSetBySP("SRV_BPM.WorkFlowTask_APP", new string[4] { "@InputFormat", "@OutputFormat"
, "@OutputContentType", "@ConditionStr" }
, new string[4] { "AML", "DB", "RS", strXMLC });
return ds;
}
/// <summary>
/// VEX框架的主入口
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
string strXML = "";
string filter = "";
m_conn = new Dbconn(m_hzyMessage.Env_SN);
strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
ds = Common.Common.GetDSByExcelXML(strXML);
DataTable dt_OPTYPE = ds.Tables["OPTYPE"];
if (dt_OPTYPE.Rows[0][0].ToString().ToUpper() == "BrandInfo".ToUpper()) //品牌信息查询无分页带模糊查询
{
filter = m_request.Tables[0].Rows[0]["q"].ToString(); // 实时条件，用于下拉框查询数据
Get(filter);
}
if (dt_OPTYPE.Rows[0][0].ToString().ToUpper() == "BrandInfoForPageList".ToUpper()) //供应商信息查询有分页
{
BrandInfoForPageList();
}
else if (dt_OPTYPE.Rows[0][0].ToString().ToUpper() == "EDIT".ToUpper())//供应商新增修改操作
{
EDIT();
}
return ds_Return;
}
catch
{
m_conn.RollbackTransaction();
throw;
}
}
/// <summary>
/// 获取系统环境信息
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
string strWS_ID = m_request.Tables[0].Rows[0]["ws_id"].ToString();
Dbconn conn = new Dbconn("WSRR");
DataSet ds = conn.GetDataSet(@"
SELECT
Param_ID,
[Param_Index]
,[Param_Content]
,[Param_Name]
,[Param_Type]
,CASE ISNULL(Param_Must_Flag,0) WHEN 1 THEN '必须' WHEN '0' THEN '否' WHEN '2' THEN '系统默认' END AS Param_Must_Flag
,ISNULL(Param_Must_Flag,0) as Param_Must_Flagint
,[Default_Value]
FROM [WSRR].[dbo].[WS_Param]
WHERE WS_ID='" + strWS_ID + "' ");
return ds;
}
catch
{
throw;
}
}
public DataSet GetData()
{
try
{
if (m_request == null || m_request.Tables.Count == 0 || m_request.Tables[0].Rows.Count == 0)
{
return null;
}
string strUser_id = m_request.Tables[0].Rows[0]["user_id"].ToString();
Dbconn conn = new Dbconn("MDM");
DataSet ds = conn.GetDataSet(@"
SELECT
t1.AM_S_dept_ID ,
t2.AM_Dept_NAME ,
t2.AM_Dept_NAME_all
FROM dbo.AM_User_Dept t1 WITH ( NOLOCK )
LEFT JOIN dbo.AM_Dept t2 WITH ( NOLOCK ) ON t1.am_S_dept_ID = t2.am_S_dept_ID
WHERE t1.AM_User_ID = "+strUser_id+@"
");
return ds;
}
catch
{
throw ;
}
}
public DataSet GetData()
{
string strEnv_ID = m_request.Tables[0].Rows[0]["Env_ID"].ToString();
string strAuthorization_ID = m_request.Tables[0].Rows[0]["Authorization_ID"].ToString();
Dbconn conn = new Dbconn("MDM");
string strSQL = @"
SELECT t1.Menu_Id ,
t1.Menu_Code +' ' + t1.Menu_Name Menu_Name,
t1.Menu_Father_ID ,
ISNULL(t2.HavaFlag, 0) HavaFlag
FROM MDM_System_Menu t1 WITH ( NOLOCK )
LEFT JOIN dbo.MDM_System_Menu_AUZ t2 WITH ( NOLOCK ) ON t1.Menu_Id = t2.Menu_ID
AND Authorization_ID=@param0
WHERE t1.env_id = @param1
";
DataSet ds = conn.GetDataSet(strSQL, new string[2] { strAuthorization_ID,strEnv_ID });
//添加根目录行
ds.Tables[0].Rows.Add(new object[] { "0", "根目录", "-1", "0" });
return ds;
}
/// <summary>
/// 获取系统用户信息
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
string strUser_ID = m_hzyMessage.User_ID;
Dbconn conn = new Dbconn("VexSSO");
DataSet ds = conn.GetDataSet(@"
SELECT
[App_UserID]
,[App_UserName]
,[App_UserName_CN]
,[Chang_Password_Time]
FROM [dbo].[MDM_System_User]
WHERE App_UserID=@param0
", new string[1]{strUser_ID});
return ds;
}
catch
{
throw;
}
}
public DataSet GetData()
{
try
{
string strSQL = "";
string strwhere = m_request.Tables[0].Rows[0]["where"].ToString();
//if (strwhere == "")
//{
// strwhere = " 1=1 ";
//}ERP_TEST
Dbconn conn = new Dbconn("ERP_PROD");
strSQL = @"SELECT rtrim(CTSTKY) CTSTKY,rtrim(CTTX40) CTTX40 FROM CSYTAB WHERE CTSTKY like 'N2%' and CTSTKY not in ('N207','N209','N211') and CTSTCO= '" + strwhere + "'";
DataSet ds = conn.GetDataSet(strSQL);
return ds;
}
catch
{
throw;
}
}
public DataSet GetData()
{
try
{
string strType = m_request.Tables[0].Rows[0]["type"].ToString();
Dbconn conn = new Dbconn("PE_OA");
DataSet ds = new DataSet();
if (strType == "New" || strType == "Upd")
{
ds = SetPOApply(conn, strType);
}
else if (strType == "GetHs" || strType == "GetDs")
{
ds = GetPOApplyList(conn, strType);
}
else if (strType == "FlowOut")
{
ds = ActFlowOut(conn, strType);
}
else if (strType == "LinkCCAS")
{
ds = LinkCCAS(conn, strType);
}
else if (strType == "GetYSInfo")
{
ds = GetYSInfo(conn, strType);
}
return ds;
}
catch
{
throw;
}
}
/// <summary>
/// 根据Entity的编号获取MDM中Entity列的配置
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
DataSet ds = new DataSet();
DataSet dsRequest = new DataSet();
string strMainEntity = "";
strMainEntity = m_request.Tables[0].Rows[0]["Entity"].ToString();
//获取所有的列
Dbconn conn = new Dbconn("MDM_Master");
ds = conn.GetDataSet(@"
SELECT Property_Name FROM dbo.Lib_ExdPropertyList
WHERE Class_Name='" + strMainEntity + @"'
Order BY ColumnIndex
");
return ds;
}
catch
{
throw;
}
}
public DataSet GetData()
{
string strVexSSONewID = m_hzyMessage.VexSSONewID;
string strApp_UserID = m_hzyMessage.User_ID;
string strEnv_ID = m_hzyMessage.Env_ID;
if (string.IsNullOrEmpty(strVexSSONewID))
{
strVexSSONewID = "00000000-0000-0000-0000-000000000000";
}
if (strApp_UserID == "0")
{
strApp_UserID = "-1";
}
Dbconn conn = new Dbconn("VexSSO");
string strSQL = @"
SELECT t1.Authorization_ID ,
t1.Authorization_Name
FROM dbo.MDM_System_Authorization t1 WITH ( NOLOCK )
JOIN dbo.MDM_System_User_Authorization t2 WITH ( NOLOCK ) ON t1.Authorization_ID = t2.Authorization_ID
WHERE Env_ID = @param1
AND (VexSSONewID = @param0 OR App_UserID=@param2)
AND ISNULL(HavaFlag, 0)=1
";
DataSet ds = conn.GetDataSet(strSQL, new string[3] { strVexSSONewID, strEnv_ID ,strApp_UserID});
return ds;
}
/// <summary>
/// 根据权限和Market表名，获取Filter信息
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
string strAUZ = m_request.Tables[0].Rows[0]["AUZ"].ToString();
string strMarketTableName = m_request.Tables[0].Rows[0]["MarketTableName"].ToString();
Dbconn conn = new Dbconn("MDM_Master");
DataSet returnDs = conn.GetDataSet(@"
SELECT Main_Entity ,
t3.Table_Property_Name + ' ' + t1.Fittler AS Filter
FROM dbo.Lib_AUZ_Fittler t1 WITH ( NOLOCK )
FULL JOIN dbo.Lib_View_TableColumn t3 WITH ( NOLOCK ) ON t3.Porperty_ID = t1.property_ID
LEFT JOIN [dbo].[Lib_View_Table] t4 WITH ( NOLOCK ) ON t4.Table_ID = t3.Table_ID
LEFT JOIN dbo.Lib_ExdPropertyList t2 WITH ( NOLOCK ) ON t1.property_ID = t2.Property_ID
WHERE Table_Name = '" + strMarketTableName + @"'
AND AUZ LIKE '%【" + strAUZ + @"】%'
");
return returnDs;
}
catch
{
throw;
}
}
private void FindFatherMenu(DataSet ds, Dbconn conn)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string strMenuFatherID = ds.Tables[0].Rows[i]["MenuFatherID"].ToString();
if (strMenuFatherID == "")
{
continue;
}
DataRow[] dr = ds.Tables[0].Select("MenuID='" + strMenuFatherID+"'"); //找到是否已经存在父节点
if (dr.Length > 0)
{
continue;
}
DataTable dt = conn.GetDataTable(@"
SELECT MenuID ,
MenuName ,
MenuFatherID ,
ActionURL
FROM F01_Cert.Menu
WHERE MenuID='" + strMenuFatherID + @"'
", new string[0]);
if (dt.Rows.Count > 0)
{
ds.Tables[0].ImportRow(dt.Rows[0]);
}
}
}
public DataSet GetData()
{
DataSet ds = null;
Dbconn conn = new Dbconn("MDM");
string strSQL = @" SELECT t1.WS_ID ,
TASK_ID,
WS_LogicName,
WS_Name,
URL,
Execute_type,
Execute_StartTime,
Execute_EndTime,
Execute_cycle,
Execute_DayStartTime,
Execute_DayEndTime,
Execute_WeekTime,
Execute_MonthTime,
Enabled
FROM dbo.WS_Scheduling t1 WITH ( NOLOCK )
WHERE
ISNULL(t1.Error_Count, 0) < 5";
if (m_request.Tables[0].Rows.Count >0 && m_request.Tables[0].Rows[0][0] != null)
{
strSQL += " AND UpdateTime > '" + Convert.ToDateTime(m_request.Tables[0].Rows[0][0]).ToString("yyyy-MM-dd HH:mm:ss") + "' ";
}
strSQL += "; SELECT * FROM WS_SchedulingParam;";
ds = conn.GetDataSet(strSQL);
return ds;
}
/// <summary>
/// 删除系统权限信息
/// </summary>
/// <returns></returns>
public bool Execute()
{
Dbconn conn = new Dbconn("MDM");
try
{
string strAuthorization_ID = m_request.Tables[0].Rows[0]["Authorization_ID"].ToString();
m_request.Tables[0].Columns.Remove("Authorization_ID");
ArrayList listTable = new ArrayList();
listTable.Add("MDM_System_Authorization");
listTable.Add("MDM_System_Menu_AUZ");
conn.BeginTransaction();
conn.TableLock(listTable);
if (strAuthorization_ID != "")
{
string strWhere = " Authorization_ID=" + strAuthorization_ID;
conn.Delete("MDM_System_Authorization", strWhere);
conn.Delete("MDM_System_Menu_AUZ", strWhere);
}
conn.CommitTransaction();
return true;
}
catch
{
conn.RollbackTransaction();
throw;
}
}
/// <summary>
/// 获取公司信息
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
Dbconn conn = new Dbconn("MDM");
DataSet ds = conn.GetDataSet(@"
SELECT
[Company_ID]
,[Company_Name]
,[Company_sn]
,[Company_Address]
,[Fax]
,[Tax_ID]
,[Bank_Name]
,[Bank_ID]
,[Createtime]
,[Updatetime]
,Convert(bigint,t1.[Timestamps]) Timestamps
FROM [MDM].[dbo].[MDM_Company] t1 WITH(NOLOCK)
");
return ds;
}
catch
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
con = new Dbconn();
conn = new SqlConnection(con.conn.ToString());
conn.Open();
custid = Session["custid"].ToString();
pno = Session["pno"].ToString();
name = Session["name"].ToString();
if (custid == "")
{
// Panel1.Visible = "false";
}
if (name == "")
{
da = new SqlDataAdapter("select * from supplprod_tb where pno='" + pno + "'and Status='Avaliable' ", conn);
da.Fill(ds, "sp");
GridView1.DataSource = ds.Tables["sp"];
GridView1.DataBind();
}
else
{
da = new SqlDataAdapter("select * from supplprod_tb where pno='" + pno + "' and pname like '" + name + "'+'%' and Status='Avaliable' ", conn);
da.Fill(ds, "sp1");
GridView1.DataSource = ds.Tables["sp1"];
GridView1.DataBind();
}
}
/// <summary>
/// 获取执行任务参数信息
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
string strXML = string.Empty;
strXML = m_request.Tables[0].Rows[0]["XML"].ToString(); //获取参数XML
DataSet dsRequest = Common.Common.GetDSByExcelXML(strXML); //转换XML到DataSet
string strTaskID = dsRequest.Tables[1].Rows[0]["task_id"].ToString(); //获取参数TaskID
if (string.IsNullOrEmpty(m_hzyPageInfo.Sort))
{
m_hzyPageInfo.Sort = "CreateTime";
m_hzyPageInfo.Order = "desc ";
}
Dbconn conn = new Dbconn("WSRR"); //创建连接类
string strSQL = @"SELECT
[Auto_ID]
,[TASK_ID]
,[Execute_StartTime]
,[Execute_EndTime]
,[Execute_Result]
,[Execute_Message]
,[CreateTime]
FROM [dbo].[WS_Scheduling_Execute_log]
WHERE TASK_ID='" + strTaskID + "' ";
DataSet ds = conn.GetDataSetForPageList(strSQL, new string[0], m_hzyPageInfo); //调用方法，获取分页数据
return ds;
}
catch
{
throw;
}
}
/// <summary>
/// 新建或修改申购单
/// </summary>
/// <returns></returns>
public DataSet SetPOApply(Dbconn conn, String strType)
{
DataSet ds = new DataSet();
string strActor = m_request.Tables[0].Rows[0]["actor"].ToString();
string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
string strXML1 = m_request.Tables[0].Rows[0]["XML1"].ToString();
//获取申购单主表数据
DataSet dsXML = Common.Common.GetDSByExcelXML(strXML);
String strOPType = dsXML.Tables["OPTYPE"].Rows[0][0].ToString().ToUpper();
String strID = dsXML.Tables["LIST"].Rows[0]["ID"].ToString();
String strTaskID = dsXML.Tables["LIST"].Rows[0]["TaskID"].ToString();
String strCONO = dsXML.Tables["LIST"].Rows[0]["CONO"].ToString();
String strDIVI = dsXML.Tables["LIST"].Rows[0]["DIVI"].ToString();
String strXMLC = "【操作类型,SAVE】【实体,单据保存】"
+ "【CONO," + strCONO + "】【DIVI," + strDIVI + "】"
+ "【TableXML," + strXML + "】"
+ "【TableXMLsub," + strXML1 + "】"
+ "【Type," + strType + "】【Actor," + strActor + "】【ID," + strID + "】"
+ "【TaskID," + strTaskID + "】"
+ "【返回内容, id,单据号,流程id】";
ds = conn.GetDataSetBySP("API_LV.POApply", new string[4] { "@InputFormat", "@OutputFormat"
, "@OutputContentType", "@ConditionStr" }
, new string[4] { "AML", "DB", "RS", strXMLC });
return ds;
}
/// <summary>
/// 编辑WS信息
/// </summary>
/// <returns></returns>
public bool Execute()
{
Dbconn conn = new Dbconn("WSRR");
try
{
if(m_request == null
|| m_request.Tables.Count==0
|| m_request.Tables[0].Rows.Count == 0)
{
return true;
}
string strParam_ID = m_request.Tables[0].Rows[0]["Param_ID"].ToString();
ArrayList listTable = new ArrayList();
listTable.Add("WS_Param");
conn.BeginTransaction();
conn.TableLock(listTable);
string strWhere = " Param_ID = '" + strParam_ID + "'";
conn.Delete("WS_Param", strWhere);
conn.CommitTransaction();
return true;
}
catch
{
conn.RollbackTransaction();
throw;
}
}
public DataSet GetData()
{
try
{
string strType = m_request.Tables[0].Rows[0]["type"].ToString();
Dbconn conn = new Dbconn("PE_OA");
DataSet ds = new DataSet();
if (strType == "GetHs" || strType == "GetDs"
|| strType == "GetAs" || strType == "GetAc" || strType == "GetPerRecord"
|| strType == "GetPerTurnRecord" || strType == "GetPerDimissRecord"
|| strType == "GetSYSConfig")
{
ds = GetRows(conn, strType);
}
else if (strType == "SaveH")
{
ds = SaveRows(conn, strType);
}
else if (strType == "SaveD")
{
ds = SaveRows1(conn, strType);
}
else if (strType == "SaveA")
{
ds = SaveRows3(conn, strType);
}
else if (strType == "SavePer")
{
ds = SaveRows4(conn, strType);
}
else if (strType == "SavePerTurn")
{
ds = SaveRows5(conn, strType);
}
else if (strType == "SavePerDimiss")
{
ds = SaveRows6(conn, strType);
}
else if (strType == "setPhotToSave")
{
ds = setPhotToSave(conn, strType);
}
else if (strType == "UpdSysCfg") // 大区经理配置调整
{
ds = UpdSysCfg(conn, strType);
}
else if (strType == "GetOTHZInfo") // 加班申请汇总
{
ds = GetOTHZInfo(conn, strType);
}
return ds;
}
catch
{
throw;
}
}
/// <summary>
/// 获取系统用户信息
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
string strEnv_SN = "";
string strApp_UserName = "";
if (m_request != null && m_request.Tables[0].Rows.Count > 0)
{
if (m_request.Tables[0].Columns.Contains("Env_SN"))
{
strEnv_SN = m_request.Tables[0].Rows[0]["Env_SN"].ToString();
}
if (m_request.Tables[0].Columns.Contains("App_UserName"))
{
strApp_UserName = m_request.Tables[0].Rows[0]["App_UserName"].ToString();
if (strApp_UserName != "")
{
strApp_UserName = "******" + strApp_UserName.Replace("'", "''").Replace(",", "','") + "'";
}
}
}
if (strApp_UserName == "")
{
throw new Exception("请输入用户名");
}
if (strEnv_SN == "")
{
throw new Exception("请输入环境简称");
}
Dbconn conn = new Dbconn("VexSSO");
DataSet ds = conn.GetDataSet(@"
SELECT
[App_UserID]
,[App_UserName]
,[App_UserName_CN]
,[Chang_Password_Time]
FROM [dbo].[MDM_System_User] with(nolock)
WHERE App_UserName in (" + strApp_UserName + @")
AND EXISTS(SELECT 1 FROM dbo.MDM_System_Env with(nolock)
WHERE Env_SN=@Param0
AND MDM_System_User.Env_ID=MDM_System_Env.Env_ID
)
", new string[1] { strEnv_SN });
return ds;
}
catch
{
throw;
}
}
public DataSet GetData()
{
DataSet ds = new DataSet();
DataSet ds_Return = new DataSet();
string strXML = "";
strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
ds = Common.Common.GetDSByExcelXML(strXML);
Dbconn conn = new Dbconn("WSRR");
DataTable dtOptype = ds.Tables["OPTYPE"];
DataTable dtList = ds.Tables["LIST"];
if (dtOptype.Rows[0][0].ToString().ToUpper() == "GET")
{
string strKeyWord = dtList.Rows[0]["KeyWord"].ToString();
string strSQL = @"
SELECT
WS_Applay_ID ,
WS_Name ,
CONVERT(VARCHAR(10),Applay_Time,21) Applay_Time ,
Appliay_User ,
Function_Name ,
state ,
WS_Content ,
Input_Format ,
Return_Format ,
WS_DeployServer ,
WS_SPName ,
Logic_Content ,
Code ,
Service_Path ,
WS_SP_Server
FROM [dbo].[WS_Applay] WITH ( NOLOCK )
WHERE FREETEXT ( WS_Name, @Param0 )
OR FREETEXT ( WS_Name, @Param0 )
OR FREETEXT ( Appliay_User, @Param0 )
OR FREETEXT ( state, @Param0 )
OR FREETEXT ( WS_Content, @Param0 )
OR FREETEXT ( Input_Format, @Param0 )
OR FREETEXT ( Return_Format, @Param0 )
OR FREETEXT ( WS_DeployServer, @Param0 )
OR FREETEXT ( WS_SPName, @Param0 )
OR FREETEXT ( Logic_Content, @Param0 )
OR FREETEXT ( Code, @Param0 )
OR FREETEXT ( Service_Path, @Param0 )
OR FREETEXT ( Function_Name, @Param0 )
OR FREETEXT ( WS_SP_Server, @Param0 )
";
ds_Return = conn.GetDataSetForPageList(strSQL, new string[1] { strKeyWord }, m_hzyPageInfo);
}
return ds_Return;
}
/// <summary>
/// 根据XML内容询店铺查询
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
try
{
DataSet ds = new DataSet();
DataSet ds_Return = new DataSet();
DataSet dsRequest = new DataSet();
Dbconn conn = new Dbconn();
ArrayList listAMSendList = new ArrayList();
string strXML = "";
string strSQL = "";
strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
//XML是前台传入
ds = Common.Common.GetDSByExcelXML(strXML);
if (ds.Tables["OPTYPE"].Rows[0][0].ToString().ToUpper() == "GET")
//读取ROWS到/ROWS 中的参数
{
conn = new Dbconn("MDM");
//if (ds.Tables["LIST"].Rows[0]["CONO"].ToString().Trim() == "YL")
//{
// conn = new Dbconn("YL_F22");
//}
string strWHERE = " and 1=1";
if (ds.Tables["LIST"].Columns.Contains("Condition"))
{
if (ds.Tables["LIST"].Rows[0]["Condition"].ToString().Trim() != "")
//读取LIST之间参数
{
strWHERE += " AND (" + ds.Tables["LIST"].Rows[0]["Condition"].ToString().Trim() + ")";
}
}
strSQL = @" SELECT
DEPOT.J_DQ,
DEPOT.J_DEPOTID,
SUBSTRING(POSUSER.J_NOTES,3,LEN(POSUSER.J_NOTES)) AS J_NOTES
FROM POSUSER,DEPOT
WHERE POSUSER.J_DEPOTID=DEPOT.J_DEPOTID " + strWHERE;
ds_Return = conn.GetDataSet(strSQL);
}
return ds_Return;
}
catch
{
throw;
}
}
/// <summary>
/// 根据MDM洲信息来编辑Entity
/// </summary>
/// <returns></returns>
public DataSet GetData()
{
Dbconn conn = new Dbconn("MDM_Master");
try
{
string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
string strStoreEntityCode = "0011";
string strMarketTableName = "Continent_For_FM";
DataSet ds = Common.Common.GetDSByExcelXML(strXML);
//获取洲的所有属性
MDM_Entity_Market_PropertyList clsPropertyList = new MDM_Entity_Market_PropertyList();
clsPropertyList.Request = Common.Common.GetRequestDataSet(new string[2] { "Entity", "MarketTableName" }, new string[2] { strStoreEntityCode, strMarketTableName });
DataTable dt_PropertyList = clsPropertyList.GetData().Tables[0];
//修改洲数据
string strUpdateXML = "<table Entity=\"" + strStoreEntityCode + "\" Expression=\"CN\">";
for (int i = 0; i < ds.Tables["LIST"].Rows.Count; i++)
{
strUpdateXML += "<row>";
strUpdateXML += "<body_ID>" + ds.Tables["LIST"].Rows[i]["body_ID"].ToString() + "</body_ID>";
for (int j = 0; j < ds.Tables["LIST"].Columns.Count; j++)
{
string strColumnName = ds.Tables["LIST"].Columns[j].ColumnName;
//如果修改的列是属于洲信息的话,要对洲的Entity进行修改
DataRow[] drList = dt_PropertyList.Select("Table_Property_Name = '" + strColumnName + "'");
if (drList.Length > 0)
{
string strPorpertyname = drList[0]["Porperty_Name"].ToString();
strUpdateXML += "<" + strPorpertyname + ">" + ds.Tables["LIST"].Rows[i][j].ToString() + "</" + strPorpertyname + ">";
}
}
strUpdateXML += "</row>";
}
strUpdateXML += "</table>";
MDM_Entity_Edit cls_Entity_Edit = new MDM_Entity_Edit();
cls_Entity_Edit.Request = Common.Common.GetRequestDataSet(new string[1] { "XML" }, new string[1] { strUpdateXML });
cls_Entity_Edit.Execute();
return Common.Common.GetRequestDataSet(new string[1] { "result" }, new string[1] { "true" });
}
catch
{
throw;
}
}
protected void GetData()
{
//Dbconn conn = new Dbconn("ConnectionString_CUSSMS");
string strConnstr = ConfigurationManager.AppSettings["ConnectionString_CUSSMS"];
Dbconn conn = new Dbconn(strConnstr, true);
string strMessage = "";
string strPhone = this.txtPhone.Text;
if (strPhone.Trim() != "")
{
DataTable dt = conn.GetDataTable(@"SELECT [VM1_CONO]
,[VM1_DIVI]
,[VM1_Ticketid]
,[VM1_Mobtel]
,[VM1_Rgdt]
,[VM1_LMDT]
FROM [CUSSMS].[B01_MDM].[VM1_VipticktMotelRecord]
WHERE VM1_Mobtel=@Param0
AND VM1_CONO=100
AND VM1_DIVI='D01'", new string[1] {
strPhone
});
if (dt.Rows.Count > 0)
{
strMessage = "<div>查询结果<p>";
strMessage += "手 机 号：" + dt.Rows[0]["VM1_Mobtel"].ToString() + "<p>";
strMessage += "券 号：" + dt.Rows[0]["VM1_Ticketid"].ToString() + "<p>";
strMessage += "申请时间：" + dt.Rows[0]["VM1_LMDT"].ToString() + "<p></div>";
}
else
{
strMessage = "<font color='red'>没有查询到手机号为" + strPhone + "的相关信息，请重试</font>";
}
}
else
{
strMessage = "<font color='red'>手机号不能为空</font>";
}
this.lblMessage.Text = strMessage;
}
private void Getdata()
{
string strConnstr = ConfigurationManager.AppSettings["ConnectionString_POS"];
Dbconn conn = new Dbconn(strConnstr, true);
string strPhone = this.txtPhone.Text;
if (strPhone.Trim() != "")
{
string strName = conn.GetDataTableFirstValue(@"SELECT vipname as 姓名, mobtel as 手机号, vipcode as 卡号 FROM vip_user WHERE mobtel=@Param0 OR vipcode=@Param0", new string[] { strPhone }).ToString();
this.lblName.Text = strName;
DataSet ds = conn.GetDataSet(@"SELECT b.ticketid AS 券号 ,
a.sums AS 面值 ,
CASE ISNULL(b.getsure,0)WHEN 0 THEN '否' ELSE '是' END AS 是否使用 ,
b.crdate AS 创建日期 ,
b.verifycode AS 验证码,a.mobtel, a.vipcode, a.vipid
FROM vip_user a
INNER JOIN vip_ticket b ON a.vipid = b.vipid
WHERE b.tictypeid = '31'
AND (a.mobtel=@param0 OR a.vipcode=@param0)
ORDER BY b.crdate DESC
", new string[] { strPhone });
RpList.DataSource = ds.Tables[0];
RpList.DataBind();
if (ds.Tables[0].Rows.Count == 0)
{
this.lblMessage.Text = "<font color='red'>没有查询到手机号/卡号为" + strPhone + "的相关信息，请重试</font>";
}
else
{
this.lblMessage.Text = "";
}
}
else
{
this.lblMessage.Text = "";
RpList.DataSource = new DataTable();
RpList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
con = new Dbconn();
conn = new SqlConnection(con.conn.ToString());
conn.Open();
if (this.IsPostBack == false)
{
prod();
}
if (!string.IsNullOrEmpty(Convert.ToString(Session["CustName"])))
{
LinkButton7.Visible = false;
lblOr.Visible = false;
LinkButton8.Visible = false;
lblName.Text = Convert.ToString(Session["CustName"]);
}
else
{
LinkButton7.Visible = true;
lblOr.Visible = true;
LinkButton8.Visible = true;
lblName.Text = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
con = new Dbconn();
conn = new SqlConnection(con.conn.ToString());
conn.Open();
}
private void Resend()
{
string strName = Request["Name"];
string strOldPhone = Request["oldphone"];
string strNewPhone = Request["newphone"];
string strcrdate = Request["crdate"].ToString();
string strsums = Request["sums"].ToString();
string strticketid = Request["ticketid"].ToString();
string strverifycode = Request["verifycode"].ToString();
string strVipID = Request["vipid"].ToString();
string strUid = Request["uid"].ToString();
if (string.IsNullOrEmpty(strOldPhone) ||
string.IsNullOrEmpty(strcrdate) ||
string.IsNullOrEmpty(strsums) ||
string.IsNullOrEmpty(strticketid) ||
string.IsNullOrEmpty(strVipID) ||
string.IsNullOrEmpty(strUid)
)
{
Response.Write("{'Message':'非法提交'}");
return;
}
else
{
if (strNewPhone == null)
{
strNewPhone = "";
}
string strPhone = strNewPhone;
if (strPhone == "")
{
strPhone = strOldPhone;
}
string strMessage = "尊敬的" + strName;
strMessage += "贵宾,您已通过EP雅莹店铺" + strcrdate.ToString() + "成功以";
strMessage += Convert.ToDecimal(strsums) * 25;
strMessage += "分兑换面额为" + strsums + "的券，券号" + strticketid;
strMessage += "，使用即使验证码：" + strverifycode;
strMessage += "。生活之美，EP雅莹愿与您一同缔造。";
AMSendWS.MsgCenter cls = new AMSendWS.MsgCenter();
string strResult = cls.SendSubjectMsgImmediately("SMS", "ep_actualtime", "积分兑换券验证码", strPhone, "信息部服务中心", strMessage, DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm:ss"), "1");
if (strResult == "0")
{
Response.Write("{'Message':'发送成功'}");
}
else
{
Response.Write("{'Message':'发送失败，原因：" + strResult.Remove('\n') + "'}");
}
//写日志
DataTable dt = new DataTable();
dt.Columns.Add("Account_Id");
dt.Columns.Add("Phone_Old");
dt.Columns.Add("Phone_New");
dt.Columns.Add("Ticket_Id");
dt.Columns.Add("Create_UserId");
dt.Columns.Add("Create_Time");
DataRow dr = dt.NewRow();
dr["Account_Id"] = strVipID;
dr["Phone_Old"] = strOldPhone;
dr["Phone_New"] = strNewPhone;
dr["Ticket_Id"] = strticketid;
dr["Create_UserId"] = strUid;
dr["Create_Time"] = DateTime.Now;
dt.Rows.Add(dr);
string strConnstr = ConfigurationManager.AppSettings["ConnectionString_CRMCUS"];
Dbconn conn = new Dbconn(strConnstr, true);
conn.BeginTransaction();
conn.Insert("Log_PhoneChange", dt);
conn.CommitTransaction();
return;
}
}
