Example #1
0
        //查询状态
        public static DataTable AgreeMent5(Entity.AgreeMent AgreeMent5)
        {
            string    sqlstr = "select * from AgreeMent where AMState='" + AgreeMent5.amState + "'";
            DataTable dt     = DBHelper.GetDT(sqlstr);

            return(dt);
        }
Example #2
0
        //查询乙方
        public static DataTable AgreeMent4(Entity.AgreeMent AgreeMent4)
        {
            string    sqlstr = "select * from AgreeMent where PID like '%" + AgreeMent4.pID + "%'";
            DataTable dt     = DBHelper.GetDT(sqlstr);

            return(dt);
        }
Example #3
0
        //查询
        public static DataTable AgreeMent2(Entity.AgreeMent AgreeMent2)
        {
            string    sqlstr = "select * from AgreeMent";
            DataTable dt     = DBHelper.GetDT(sqlstr);

            return(dt);
        }
Example #4
0
        //修改合同
        public static bool AgreeMent6(Entity.AgreeMent AgreeMent6)
        {
            string sqlstr = "update AgreeMent set PID='" + AgreeMent6.pID + "', AMStop='" + AgreeMent6.amStop + "', AMBase=" + AgreeMent6.amBase + ",AMState='" + AgreeMent6.amState + "' where AMID='" + AgreeMent6.amID + "'";
            int    i      = DBHelper.GetLine(sqlstr);

            if (i > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Example #5
0
        //添加合同
        public static bool AgreeMent(Entity.AgreeMent AgreeMent1)
        {
            string sqlstr = "insert into AgreeMent values('" + AgreeMent1.pID + "','" + AgreeMent1.amStart + "','" + AgreeMent1.amStop + "','" + AgreeMent1.AMText + "'," + AgreeMent1.amBase + ",'" + AgreeMent1.amState + "')";

            int i = DBHelper.GetLine(sqlstr);

            if (i > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Example #6
0
 //修改
 public static bool AgreeMent6(Entity.AgreeMent AgreeMent6)
 {
     return(DAL.AgreeMentDAL.AgreeMent6(AgreeMent6));
 }
Example #7
0
 //查询合同状态
 public static DataTable AgreeMent5(Entity.AgreeMent AgreeMent5)
 {
     return(DAL.AgreeMentDAL.AgreeMent5(AgreeMent5));
 }
Example #8
0
 //查询乙方
 public static DataTable AgreeMent4(Entity.AgreeMent AgreeMent4)
 {
     return(DAL.AgreeMentDAL.AgreeMent4(AgreeMent4));
 }
Example #9
0
 //查询合同表名
 public static DataTable AgreeMent3(Entity.AgreeMent AgreeMent3)
 {
     return(DAL.AgreeMentDAL.AgreeMent3(AgreeMent3));
 }
Example #10
0
 //查询表
 public static DataTable AgreeMent2(Entity.AgreeMent AgreeMent2)
 {
     return(DAL.AgreeMentDAL.AgreeMent2(AgreeMent2));
 }
Example #11
0
 //添加合同信息
 public static bool AgreeMent1(Entity.AgreeMent AgreeMent1)
 {
     return(DAL.AgreeMentDAL.AgreeMent(AgreeMent1));
 }