/// <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; } }