?? cw_publics.cs
字號(hào):
using System;
using System.Data.SqlClient;
using com.unicafe.common;
using System.Web.UI.WebControls;
using com.ascs.plp.publics;
using com.unicafe.ui;
namespace Com.Ascs.Plp.Cw.Publics
{
/// <summary>
/// Com.Ascs.Plp.Cw.Publics 的摘要說(shuō)明。
/// </summary>
public class CwInfo
{
public string JGDM; //機(jī)構(gòu)代碼
public string CurrentKJND; //會(huì)計(jì)年度
public string CurrentKJQJ; //會(huì)計(jì)期間
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 財(cái)務(wù)信息對(duì)象構(gòu)造函數(shù)
/// </summary>
/// **************************************************************************
public CwInfo()
{
}
/// **************************************************************************
/// END
/// **************************************************************************
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 根據(jù)機(jī)構(gòu)代碼和時(shí)間執(zhí)行財(cái)務(wù)信息對(duì)象構(gòu)造函數(shù)
/// </summary>
/// <param name="sJGDM">機(jī)構(gòu)代碼</param>
/// <param name="TIME">時(shí)間</param>
/// **************************************************************************
public CwInfo(string sJGDM, DateTime TIME)
{
//定義SqlConnection對(duì)象、SqlCommand對(duì)象和SqlDataReader對(duì)象
SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
string sql = "Select KJND, KJQJBH From CW_KJQJ Where JGDM = '" + sJGDM + "' And KSRQ =(Select Max(KSRQ) from CW_KJQJ Where KSRQ <= @DQRQ And JSRQ >= @DQRQ And JGDM=@JGDM)";
SqlCommand cmd = Connection.CreateCommand();
cmd.Parameters.Add("@DQRQ", TIME.ToString("yyyy-MM-dd hh:mm:ss"));
cmd.Parameters.Add("@JGDM", sJGDM);
cmd.CommandText = sql;
SqlDataReader dr;
//打開(kāi)數(shù)據(jù)庫(kù)連接
Connection.Open();
//給當(dāng)前會(huì)計(jì)年度和會(huì)計(jì)期間賦值
dr = cmd.ExecuteReader();
while (dr.Read())
{
JGDM = sJGDM;
CurrentKJND = dr[0].ToString();
CurrentKJQJ = dr[1].ToString();
}
//關(guān)閉數(shù)據(jù)庫(kù)連接
Connection.Close();
}
/// **************************************************************************
/// END
/// **************************************************************************
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 財(cái)務(wù)信息對(duì)象構(gòu)造函數(shù)，同調(diào)用CwInfo(sJGDM, DateTime.Now)
/// </summary>
/// <param name="JGDM">機(jī)構(gòu)代碼</param>
/// **************************************************************************
public CwInfo(string sJGDM)
{
//定義SqlConnection對(duì)象、SqlCommand對(duì)象和SqlDataReader對(duì)象
SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
string sql = "Select KJND, KJQJBH From CW_KJQJ Where JGDM=@JGDM And KSRQ=(Select Max(KSRQ) from CW_KJQJ Where KSRQ <= @DQRQ And JSRQ >= @DQRQ And JGDM=@JGDM)";
SqlCommand cmd = Connection.CreateCommand();
cmd.Parameters.Add("@DQRQ", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
cmd.Parameters.Add("@JGDM", sJGDM);
cmd.CommandText = sql;
SqlDataReader dr;
//打開(kāi)數(shù)據(jù)庫(kù)連接
Connection.Open();
//給當(dāng)前會(huì)計(jì)年度和會(huì)計(jì)期間賦值
dr = cmd.ExecuteReader();
while (dr.Read())
{
JGDM = sJGDM;
CurrentKJND = dr[0].ToString();
CurrentKJQJ = dr[1].ToString();
}
//關(guān)閉數(shù)據(jù)庫(kù)連接
Connection.Close();
}
/// **************************************************************************
/// END
/// **************************************************************************
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 財(cái)務(wù)信息對(duì)象構(gòu)造函數(shù)，同調(diào)用CwInfo(thePage.CurrentJGXX.JGDM, DateTime.Now)
/// </summary>
/// <param name="thePage">調(diào)用此方法的頁(yè)面對(duì)象,調(diào)用前需要執(zhí)行它的VerifyPage()方法，否則無(wú)法取得當(dāng)前登錄人所在機(jī)構(gòu)的機(jī)構(gòu)代碼</param>
/// **************************************************************************
public CwInfo(com.unicafe.ui.UnicafePage thePage)
{
string sJGDM = thePage.CurrentJGXX.JGDM;
//定義SqlConnection對(duì)象、SqlCommand對(duì)象和SqlDataReader對(duì)象
SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
string sql = "Select KJND, KJQJBH From CW_KJQJ Where JGDM = '" + sJGDM + "' And KSRQ =(Select Max(KSRQ) from CW_KJQJ Where KSRQ <= @DQRQ And JSRQ >= @DQRQ And JGDM=@JGDM)";
SqlCommand cmd = Connection.CreateCommand();
cmd.Parameters.Add("@DQRQ", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
cmd.Parameters.Add("@JGDM", sJGDM);
cmd.CommandText = sql;
SqlDataReader dr;
//打開(kāi)數(shù)據(jù)庫(kù)連接
Connection.Open();
//給當(dāng)前會(huì)計(jì)年度和會(huì)計(jì)期間賦值
dr = cmd.ExecuteReader();
while (dr.Read())
{
JGDM = sJGDM;
CurrentKJND = dr[0].ToString();
CurrentKJQJ = dr[1].ToString();
}
//關(guān)閉數(shù)據(jù)庫(kù)連接
Connection.Close();
}
/// **************************************************************************
/// END
/// **************************************************************************
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 檢查是否能夠取得當(dāng)前時(shí)間所在的會(huì)計(jì)年度和會(huì)計(jì)期間
/// </summary>
/// <returns>成功取得會(huì)計(jì)期間返回true，失敗返回false</returns>
/// **************************************************************************
public bool KJQJ_Verify()
{
if (CurrentKJQJ != "")
{
return true;
}
else
{
return false;
}
}
/// **************************************************************************
/// END
/// **************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 查詢當(dāng)前會(huì)計(jì)期間的上一個(gè)會(huì)計(jì)期間
/// </summary>
/// <param name="JGDM"></param>
/// <returns></returns>
/// *****************************************************************************
public CwInfo GetPreviousKJQJ(string JGDM)
{
string sql = "SELECT JGDM, KJND, KJQJBH FROM CW_KJQJ WHERE JGDM=@JGDM And KSRQ = (SELECT MAX(KSRQ) FROM CW_KJQJ WHERE JGDM=@JGDM AND KSRQ < (SELECT KSRQ FROM CW_KJQJ WHERE DQQJBJ = 1 AND JGDM=@JGDM))";
return GetKJQJ(JGDM, sql);
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 查詢當(dāng)前會(huì)計(jì)期間
/// </summary>
/// <param name="JGDM"></param>
/// <returns></returns>
/// *****************************************************************************
public CwInfo GetThisKJQJ(string JGDM)
{
string sql = "Select JGDM, KJND, KJQJBH From CW_KJQJ Where JGDM=@JGDM And DQQJBJ='1'";
return GetKJQJ(JGDM, sql);
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 查詢當(dāng)前會(huì)計(jì)期間的下一個(gè)會(huì)計(jì)期間
/// </summary>
/// <param name="JGDM"></param>
/// <returns></returns>
/// *****************************************************************************
public CwInfo GetNextKJQJ(string JGDM)
{
string sql = "";
sql += "declare @KSRQ datetime;\n";
sql += "declare @KJND char(4);\n";
sql += "Select @KSRQ = (Select Min(KSRQ) From CW_KJQJ Where JGDM=@JGDM And KSRQ > (Select KSRQ From CW_KJQJ Where JGDM=@JGDM And DQQJBJ='1'));\n";
sql += "Select @KJND = (Select KJND From CW_KJQJ Where KSRQ=@KSRQ And JGDM=@JGDM);\n";
sql += "Select JGDM, KJND, KJQJBH From CW_KJQJ Where KSRQ=@KSRQ And JGDM=@JGDM And Exists (Select * From CW_KJQJ Where ZTQYBJ='1' And JGDM=@JGDM And KJND=@KJND);";
//string sql = "SELECT JGDM, KJND, KJQJBH FROM CW_KJQJ WHERE JGDM=@JGDM And Exists (Select * From CW_KJQJ Where ZTQYBJ='1' And KJND=@KJND) And KSRQ = (SELECT MIN(KSRQ) FROM CW_KJQJ WHERE JGDM=@JGDM AND KSRQ > (SELECT KSRQ FROM CW_KJQJ WHERE DQQJBJ = 1 AND JGDM=@JGDM))";
return GetKJQJ(JGDM, sql);
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 查詢某年度的第一個(gè)會(huì)計(jì)期間
/// </summary>
/// <param name="JGDM">機(jī)構(gòu)代碼</param>
/// <param name="KJND">會(huì)計(jì)年度</param>
/// <returns>該機(jī)構(gòu)的該會(huì)計(jì)年度中的第一個(gè)會(huì)計(jì)期間</returns>
/// *****************************************************************************
public CwInfo GetFirstKJQJ(string JGDM, string KJND)
{
string sql = "SELECT JGDM, KJND, KJQJBH FROM CW_KJQJ WHERE JGDM=@JGDM And Exists (Select * From CW_KJQJ Where ZTQYBJ='1' And KJND=@KJND And JGDM=@JGDM) And KSRQ = (SELECT MIN(KSRQ) FROM CW_KJQJ WHERE JGDM=@JGDM AND KJND=@KJND))";
return GetKJQJ(JGDM, KJND, sql);
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 查詢某年度的最后一個(gè)會(huì)計(jì)期間
/// </summary>
/// <param name="JGDM">機(jī)構(gòu)代碼</param>
/// <param name="KJND">會(huì)計(jì)年度</param>
/// <returns>該機(jī)構(gòu)的該會(huì)計(jì)年度中的最后一個(gè)會(huì)計(jì)期間</returns>
/// *****************************************************************************
public CwInfo GetLastKJQJ(string JGDM, string KJND)
{
string sql = "SELECT JGDM, KJND, KJQJBH FROM CW_KJQJ WHERE JGDM=@JGDM And Exists (Select * From CW_KJQJ Where ZTQYBJ='1' And KJND=@KJND And JGDM=@JGDM) And KSRQ = (SELECT MAX(KSRQ) FROM CW_KJQJ WHERE JGDM=@JGDM AND KJND=@KJND))";
return GetKJQJ(JGDM, KJND, sql);
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 查詢會(huì)計(jì)期間
/// </summary>
/// <param name="JGDM"></param>
/// <param name="sql"></param>
/// <returns></returns>
/// *****************************************************************************
public CwInfo GetKJQJ(string JGDM, string sql)
{
try
{
CwInfo result = null;
SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
cn.Open();
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.Add ("@JGDM",JGDM);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = new CwInfo();
if (dr["JGDM"] != null)
if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
result.JGDM = (string)dr["JGDM"];
if (dr["KJND"] != null)
if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
result.CurrentKJND = (string)dr["KJND"];
if (dr["KJQJBH"] != null)
if (!System.DBNull.Equals(dr["KJQJBH"], System.DBNull.Value))
result.CurrentKJQJ = (string)dr["KJQJBH"];
}
dr.Close();
cn.Close();
return result;
}
catch(Exception e)
{
LogService.Write ("GetKJQJ(string JGDM, string sql)");
LogService.Write (e.Message);
return null;
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -