operation.cs

随着社会经济的不断发展

        #endregion

        #region  系统登录

        public DataSet LoginSystem(string userName,string pwd)
        {
            return data.RunProcReturn("select * from tb_user where userName='" + userName + "'and userpwd='" + pwd + "'","tb_user");
        }

        #endregion

        #region  数据库备份与恢复--系统设置
        /// <summary>
        /// 数据库备份
        /// </summary>
        /// <param name="bakUpName">备份路径</param>
        /// <param name="format">是否格式化</param>
        public void BackUp(string bakUpName,bool format)
        {
            if(format)
                data.RunProc("BACKUP DATABASE db_EquipmentMS TO DISK ='" + bakUpName + "' with format");
            else
                data.RunProc("BACKUP DATABASE db_EquipmentMS TO DISK ='" + bakUpName + "' with noformat");
        }
        /// <summary>
        /// 恢复数据库
        /// </summary>
        /// <param name="reStoreName">指定恢复数据库路径</param>
        /// <param name="bakFile">指定恢复文件</param>
        public void ReStore(string reStoreName,int  bakFile)
        {
            data.RunProc("use master RESTORE DATABASE db_EquipmentMS from disk='" + reStoreName + "'WITH file = " + bakFile + "");
        }
        /// <summary>
        /// 获得备份数据日志
        /// </summary>
        /// <param name="strPath">指定备份文件路径</param>
        /// <returns></returns>
        public DataSet GetBakUp(string strPath)
        {
            return data.RunProcReturn("restore headeronly from disk='" + strPath + "'", "headeronly");
        }
        #endregion
    }

    #region　固定资产实体类
    public class cZcMain
    {
        private string bh="";
        private string mc="";
        private string xh="";
        private string zclb="";
        private string xxpz = "";
        private string gjbh = "";
        private string sccj = "";
        private DateTime ccrq = DateTime.Now;
        private string zjfs = "";
        private string sybm = "";
        private string syqk = "";
        private string cfdd = "";
        private string bgry = "";
        private DateTime rzrq = DateTime.Now;
        private int sl = 0;
        private string dw = "";
        private float dj = 0;
        private float yz = 0;
        private float ljzj = 0;
        private float jz = 0;
        private float jczl = 0;
        private string zjff = "";
        private int nx = 0;
        private DateTime login = DateTime.Now;
        private string loginer = "";
        /// <summary>
        /// ID
        /// </summary>
        public string BH
        {
            get { return bh; }
            set { bh = value; }
        }
        /// <summary>
        /// 用户名称
        /// </summary>
        public string MC
        {
            get { return mc; }
            set { mc = value; }
        }
        /// <summary>
        /// 型号
        /// </summary>
        public string XH
        {
            get { return xh; }
            set { xh = value; }
        }
        /// <summary>
        /// 资产列表
        /// </summary>
        public string Zclb
        {
            get { return zclb; }
            set { zclb = value; }
        }
        /// <summary>
        /// 详细配置
        /// </summary>
        public string Xxpz
        {
            get { return xxpz; }
            set { xxpz = value; }
        }
        /// <summary>
        /// 国际编号
        /// </summary>
        public string Gjbh
        {
            get { return gjbh; }
            set { gjbh = value; }
        }
        /// <summary>
        /// 出厂日期
        /// </summary>
        public DateTime Ccrq
        {
            get { return ccrq; }
            set { ccrq = value; }
        }
        /// <summary>
        /// 生产厂家
        /// </summary>
        public string Sccj
        {
            get { return sccj; }
            set { sccj = value; }
        }
        /// <summary>
        /// 增加方式
        /// </summary>
        public string Zjfs
        {
            get { return zjfs; }
            set { zjfs = value; }
        }
        /// <summary>
        /// 使用部门
        /// </summary>
        public string Sybm
        {
            get { return sybm; }
            set { sybm = value; }
        }
        /// <summary>
        /// 使用情况
        /// </summary>
        public string Syqk
        {
            get { return syqk; }
            set { syqk = value; }
        }
        /// <summary>
        /// 存放地点
        /// </summary>
        public string Cfdd
        {
            get { return cfdd; }
            set { cfdd = value; }
        }
        /// <summary>
        /// 保管人员
        /// </summary>
        public string Bgry
        {
            get { return bgry; }
            set { bgry = value; }
        }
        /// <summary>
        /// 入账日期
        /// </summary>
        public DateTime Rzrq
        {
            get { return rzrq; }
            set { rzrq = value; }
        }
        /// <summary>
        /// 数量
        /// </summary>
        public int SL
        {
            get { return sl; }
            set { sl = value; }
        }
        /// <summary>
        /// 单位
        /// </summary>
        public string DW
        {
            get { return dw; }
            set { dw = value; }
        }
        /// <summary>
        /// 单价
        /// </summary>
        public float DJ
        {
            get { return dj; }
            set { dj = value; }
        }
        /// <summary>
        /// 原值
        /// </summary>
        public float YZ
        {
            get { return yz; }
            set { yz = value; }
        }
        /// <summary>
        /// 累计折旧
        /// </summary>
        public float Ljzj
        {
            get { return ljzj; }
            set { ljzj = value; }
        }
        /// <summary>
        /// 净值
        /// </summary>
        public float JZ
        {
            get { return jz; }
            set { jz = value; }
        }
        /// <summary>
        /// 净残值率
        /// </summary>
        public float Jczl
        {
            get { return jczl; }
            set { jczl = value; }
        }
        /// <summary>
        /// 折旧方法
        /// </summary>
        public string Zjff
        {
            get { return zjff; }
            set { zjff = value; }
        }
        /// <summary>
        /// 使用年限
        /// </summary>
        public int Nx
        {
            get { return nx; }
            set { nx = value; }
        }
        /// <summary>
        /// 登记日期
        /// </summary>
        public DateTime Login
        {
            get { return login; }
            set { login = value; }
        }
        /// <summary>
        /// 登记人
        /// </summary>
        public string Loginer
        {
            get { return loginer; }
            set { loginer = value; }
        }
        private string qlr = "";
        private string qlfs = "";
        private DateTime qlrq = DateTime.Now;
        private string memo = "";
        private string pzr = "";
        /// <summary>
        /// 清理人
        /// </summary>
        public string Qlr
        {
            get { return qlr; }
            set { qlr = value; }
        }
        /// <summary>
        /// 清理方式
        /// </summary>
        public string Qlfs
        {
            get { return qlfs; }
            set { qlfs = value; }
        }
        /// <summary>
        /// 清理日期
        /// </summary>
        public DateTime Qlrq
        {
            get { return qlrq; }
            set { qlrq = value; }
        }
        /// <summary>
        /// 批准人
        /// </summary>
        public string Pzr
        {
            get { return pzr; }
            set { pzr = value; }
        }
        /// <summary>
        /// 备注
        /// </summary>
        public string Memo
        {
            get { return memo; }
            set { memo = value; }
        }
    }
    #endregion
}