dalcontractesub.cs

登陆界面

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using System.Data.SqlClient;

/// <summary>
///DALContracteSub 的摘要说明
/// </summary>
/// 
namespace corInfMan.DAL
{
    public class DALContracteSub
    {
        public DALContracteSub()
        {
            //
            //TODO: 在此处添加构造函数逻辑
            //
        }
        //提交申请
        public void submitApply(string ctname, DateTime ctdatetime, int ctcash, string ctclientname, string ctburdenman,string ctstyle, string ctresume,string username,int iscertified,int times)
        {
            string sqlStr = "insert into aspnet_Contracte (CtName,CtDatetime,CtCash,CtClientName,CtBurdenMan,CtStyle,CtResume,CtUserName,IsCertified) values(@ctname,@ctdatetime,@ctcash,@ctclientname,@ctburdenman,@ctstyle,@ctresume,@username,@iscertified)";
            SqlParameter[] parm = { new SqlParameter("@ctname", SqlDbType.NVarChar), new SqlParameter("@ctdatetime", SqlDbType.DateTime), new SqlParameter("@ctcash", SqlDbType.Int),
                                    new SqlParameter("@ctclientname", SqlDbType.NVarChar),new SqlParameter("@ctburdenman",SqlDbType.NVarChar),new SqlParameter("@ctstyle",SqlDbType.NVarChar), new SqlParameter("@ctresume",SqlDbType.NVarChar),
                                    new SqlParameter("@username",SqlDbType.NVarChar), new SqlParameter("@IsCertified", SqlDbType.Int),new SqlParameter("@CtCashTimes",SqlDbType.Int)
                                    };
            parm[0].Value = ctname;
            parm[1].Value = ctdatetime;
            parm[2].Value = ctcash;
            parm[3].Value = ctclientname;
            parm[4].Value = ctburdenman;
            parm[5].Value = ctstyle;
            parm[6].Value = ctresume;
            parm[7].Value = username;
            parm[8].Value = iscertified;
            parm[9].Value = times;


            corInfMan.Utility.SQLHelper.ExecuteSql(sqlStr, parm);
        }

        /// <summary>
        /// 返回是否有合同，是否得到确认
        /// </summary>
        /// <param name="username">查询用户名</param>
        /// <returns>0没审核通过；1审核通过；2通过并已读；3没有任何出差记录</returns>
        public int isCertified(string username)
        {
            string strSql = "select IsCertified from aspnet_Contracte where UserName=@username";
            SqlParameter[] parm = { new SqlParameter("@username", SqlDbType.NChar) };
            parm[0].Value = username;
            int check;
            if (corInfMan.Utility.SQLHelper.Exists(strSql, parm))
            {
                check = int.Parse(corInfMan.Utility.SQLHelper.GetSingle(strSql, parm).ToString());
            }
            else
            {
                check = 3;
            }
            return check;
        }
        /// <summary>
        /// 通过审核的申请
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public DataSet contracteOverTable(string username)
        {
            string sqlStr = "select CtName,CtDatetime, CtCash,CtClientName,CtBurdenMan,CtResume,CtStyle,CtUserName,IsCertified,CtCashTimes  from aspnet_Contracte where CtUserName=@username and IsCertified=1 or IsCertified=2";
            SqlParameter[] parm = { new SqlParameter("@username", SqlDbType.NVarChar) };
            parm[0].Value = username;
            return corInfMan.Utility.SQLHelper.Query(sqlStr, parm);
        }
        /// <summary>
        /// 未通过审核的申请
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public DataSet contracteTable(string username)
        {
            string sqlStr = "select CtName,CtDatetime, CtCash,CtClientName,CtBurdenMan,CtResume,CtStyle ,CtUserName,IsCertified,CtCashTimes from aspnet_Contracte where CtUserName=@username and IsCertified=0 or IsCertified=3";
            SqlParameter[] parm = { new SqlParameter("@username", SqlDbType.NVarChar) };
            parm[0].Value = username;
            return corInfMan.Utility.SQLHelper.Query(sqlStr, parm);
        }

        /// <summary>
        /// 部门经理进行审核
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public void isCertified(string ctname,int cb)
        {

            string sqlStr = "update aspnet_Contracte set IsCertified=@cb where CtName=@ctname";
            SqlParameter[] parm = { new SqlParameter("@cb",SqlDbType.Int),new SqlParameter("@ctname",SqlDbType.NChar)};
            parm[0].Value = cb;
            parm[1].Value = ctname;
            corInfMan.Utility.SQLHelper.Query(sqlStr, parm);
 
        }
        public DataSet inContracteTable(string username)
        {
            string sqlStr = "select CtName,CtDatetime,CtBurdenMan,CtStyle,CtCash,CtResume from aspnet_Contracte where  IsCertified=0 or IsCertified=3";
            SqlParameter[] parm = { new SqlParameter("@username", SqlDbType.NVarChar) };
            parm[0].Value = username;
            return corInfMan.Utility.SQLHelper.Query(sqlStr, parm);
 
        }
    }
}