📄 cw_publics.cs
字号:
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 查询会计期间
/// </summary>
/// <param name="JGDM"></param>
/// <param name="KJND"></param>
/// <param name="sql"></param>
/// <returns></returns>
/// *****************************************************************************
public CwInfo GetKJQJ(string JGDM, string KJND, 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);
cmd.Parameters.Add ("@KJND",KJND);
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;
}
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// *****************************************************************************
/// BEIGIN
/// <summary>
/// 检查某机构的某个会计年度账套是否已经启用
/// </summary>
/// <param name="JGDM"></param>
/// <param name="KJND"></param>
/// <returns></returns>
/// *****************************************************************************
public bool CheckStatus(string JGDM, string KJND)
{
string sql = "Select Count(*) From CW_KJQJ Where ZTQYBJ='1' And JGDM='" + JGDM + "' And KJND='" + KJND + "'";
if(int.Parse(CommonService.ExecQuery(sql, 3).ToString()) < 1)
{
return false;
}
else
{
return true;
}
}
/// *****************************************************************************
/// END
/// *****************************************************************************
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 在下拉列表框中列出所有的会计年度，并根据当前时间进行会计年度的定位
/// </summary>
/// <param name="theDDL">显示数据的下拉列表框</param>
/// <param name="JGDM">机构代码</param>
/// **************************************************************************
public void LocateKJND(DropDownList theDDL, string JGDM)
{
try
{
string sql = "Select KJND From CW_KJND Order By KJND";
CommonService.BindDropDownList(theDDL, sql, "KJND", "KJND");
theDDL.Items.Insert(0,"-- 会计年度 --");
CommonService.LocateDropDownList(theDDL, new CwInfo(JGDM, DateTime.Now).CurrentKJND);
}
catch
{
//当前时间可能还找不到所在的会计期间
}
}
/// **************************************************************************
/// END
/// **************************************************************************
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 根据会计年度和会计科目编码取得会计科目的名称
/// </summary>
/// <param name="KJND">会计年度</param>
/// <param name="KMBM">科目编码</param>
/// <returns>科目名称</returns>
/// **************************************************************************
public string FindKJKM(string KJND, string KMBM)
{
//定义SqlConnection对象和SqlCommand对象
SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
string sql = "Select KMMC From CW_KJKM Where KJND = @KJND And KMBM = @KMBM";
SqlCommand cmd = Connection.CreateCommand();
cmd.CommandText = sql;
cmd.Parameters.Add("@KJND", KJND);
cmd.Parameters.Add("@KMBM", KMBM);
//打开数据库连接
Connection.Open();
//定义并取得返回值
string KJKM = cmd.ExecuteScalar().ToString();
//关闭数据库连接
Connection.Close();
//返回值
return KJKM;
}
/// **************************************************************************
/// END
/// **************************************************************************
//
//
//
//
//
// /// **************************************************************************
// /// BEIGIN
// /// <summary>
// /// 根据机构代码和科目编码找出当前会计年度中对应的科目名称
// /// </summary>
// /// <param name="KMBM">科目编码</param>
// /// <returns>当前会计年度中设置的科目编码对应的科目名称</returns>
// /// **************************************************************************
// public string FindKJKM(string KMBM)
// {
// return FindKJKM(CurrentKJND, KMBM);
// }
// /// **************************************************************************
// /// END
// /// **************************************************************************
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 绑定费用会计科目
/// </summary>
/// <param name="theDDL">被绑定的下拉列表框控件对象</param>
/// <param name="sJgdm">机构代码</param>
/// <param name="bValue">bValue=true其参数取机构代码，否则是会计年度</param>
/// <returns>布尔型返回值，成功执行时返回true，产生错误时返回false</returns>
/// **************************************************************************
public static bool ListFykm(System.Web.UI.WebControls.DropDownList theDDL,string sJgdmKjnd,bool bValue)
{
System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
System.Data.SqlClient.SqlDataReader SqlDR ;
string sql = "";
string sFykm ="";
try
{
Connection.Open();
//取当前年度下的费用总编码
sql = "select A.XMZ from cw_cwxtsz A,cw_kjqj B where B.dqqjbj='1' AND A.KJND=B.KJND AND A.xmbh='6'";
cmd.CommandText = sql;
SqlDR = cmd.ExecuteReader();
if(SqlDR.Read())
sFykm = SqlDR[0].ToString();
SqlDR.Close();
if(sFykm!=null && sFykm.Trim()!="")
{
//取会计科目
if(bValue)
sql = "select A.kmbm,A.kmbm+'-'+A.kmmc kmbmMc from cw_kjkm A,CW_KJQJ B where A.kmbm like '"+sFykm+"%' and A.kmbm<>'"+sFykm+"'AND A.KJND=B.KJND AND B.dqqjbj='1' and A.TYBJ='0' and B.JGDM='"+sJgdmKjnd+"'";
else
sql = "select kmbm,kmbm+'-'+kmmc kmbmMc from cw_kjkm where kmbm like '"+sFykm+"%' and kmbm<>'"+sFykm+"' and kjnd='"+sJgdmKjnd+"' and TYBJ='0'";
cmd.CommandText = sql;
SqlDR = cmd.ExecuteReader();
//将查询结果集与下拉列表框控件进行绑定
theDDL.DataSource = SqlDR;
theDDL.DataValueField = "kmbm";
theDDL.DataTextField = "kmbmMc";
theDDL.DataBind();
//关闭数据库连接对象
SqlDR.Close();
}
Connection.Close();
ListItem listDepart = new ListItem();
listDepart.Value="";
listDepart.Text ="-- 请选择 --";
theDDL.Items.Insert(0,listDepart);
return true;
}
catch(Exception e)
{
Connection.Close();
LogService.Write ("ListFykm(System.Web.UI.WebControls.DropDownList theDDL,string sJgdm)");
LogService.Write ("在费用会计科目时发生错误。");
LogService.Write (e.Message);
return false;
}
}
/// **************************************************************************
/// END
/// **************************************************************************
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 绑定费用会计科目
/// </summary>
/// <param name="theDDL">被绑定的下拉列表框控件对象</param>
/// <returns>布尔型返回值，成功执行时返回true，产生错误时返回false</returns>
/// **************************************************************************
public static bool ListFykmAll(System.Web.UI.WebControls.DropDownList theDDL,string sKjnd)
{
System.Data.SqlClient.SqlConnection Connection = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
System.Data.SqlClient.SqlCommand cmd = Connection.CreateCommand();
System.Data.SqlClient.SqlDataReader SqlDR ;
string sql = "";
string sFykm ="";
try
{
Connection.Open();
//取当前年度下的费用总编码
sql = "select A.XMZ from cw_cwxtsz A,cw_kjqj B where B.dqqjbj='1' AND A.KJND=B.KJND AND A.xmbh='6'";
cmd.CommandText = sql;
SqlDR = cmd.ExecuteReader();
if(SqlDR.Read())
sFykm = SqlDR[0].ToString();
SqlDR.Close();
if(sFykm!=null && sFykm.Trim()!="")
{
//取会计科目
sql = "select kmbm,kmbm+'-'+kmmc kmbmMc from cw_kjkm where kmbm like '"+sFykm+"%' and kmbm<>'"+sFykm+"' and kjnd='"+sKjnd+"'";
cmd.CommandText = sql;
SqlDR = cmd.ExecuteReader();
//将查询结果集与下拉列表框控件进行绑定
theDDL.DataSource = SqlDR;
theDDL.DataValueField = "kmbm";
theDDL.DataTextField = "kmbmMc";
theDDL.DataBind();
//关闭数据库连接对象
SqlDR.Close();
}
Connection.Close();
ListItem listDepart = new ListItem();
listDepart.Value="";
listDepart.Text ="-- 请选择 --";
theDDL.Items.Insert(0,listDepart);
return true;
}
catch(Exception e)
{
Connection.Close();
LogService.Write ("ListFykm(System.Web.UI.WebControls.DropDownList theDDL,string sKjnd)");
LogService.Write ("在绑定费用会计科目时发生错误。");
LogService.Write (e.Message);
return false;
}
}
/// **************************************************************************
/// END
/// **************************************************************************
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -