63 lines
2.2 KiB
C#
63 lines
2.2 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Data.OracleClient;
|
|
using WX.CRM.Common;
|
|
|
|
namespace WX.CRM.DAL.Wx
|
|
{
|
|
public class Wx_DbRead_DAL
|
|
{
|
|
/// <summary>
|
|
/// 读取日志
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataTable WxDbUploadLogRead()
|
|
{
|
|
DataTable ta = null;
|
|
try
|
|
{
|
|
var param1 = new List<OracleParameter>()
|
|
{
|
|
new OracleParameter(){ParameterName="v_data",OracleType=OracleType.Cursor,Direction = ParameterDirection.Output}
|
|
};
|
|
ta = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_WX_DB.WxDbUploadLogRead", param1.ToArray()).Tables[0];
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error("读取db上传日志出现错误WxDbUploadLogRead:" + ex.ToString());
|
|
}
|
|
return ta;
|
|
}
|
|
/// <summary>
|
|
/// 修改装填
|
|
/// </summary>
|
|
/// <param name="pkid">主键</param>
|
|
/// <param name="status">状态</param>
|
|
/// <param name="content">内容</param>
|
|
/// <returns></returns>
|
|
public bool UpdataStatus(decimal pkid, decimal status, string content)
|
|
{
|
|
|
|
bool isSucced = true;
|
|
try
|
|
{
|
|
var param1 = new List<OracleParameter>()
|
|
{
|
|
new OracleParameter() { ParameterName = "v_pkid", OracleType = OracleType.Number, Value =pkid },
|
|
new OracleParameter() { ParameterName = "v_status", OracleType = OracleType.Number, Value =status },
|
|
new OracleParameter() { ParameterName = "v_content", OracleType = OracleType.VarChar, Value =content }
|
|
};
|
|
OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_WX_DB.WxDbUpStatus", param1.ToArray());
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
isSucced = false;
|
|
LogHelper.Error("修改db上传日志出现错误:" + ex.ToString());
|
|
}
|
|
return isSucced;
|
|
}
|
|
}
|
|
}
|