Пример #1
0
        public static int UpdateInformation(A2ZLPURPOSEDTO dto)
        {
            dto.LPurposeDescription = (dto.LPurposeDescription != null) ? dto.LPurposeDescription.Trim().Replace("'", "''") : "";
            int    rowEffect = 0;
            string strQuery  = "UPDATE A2ZLPURPOSE set LPurposeCode='" + dto.LPurposeCode + "',LPurposeDescription='" + dto.LPurposeDescription + "' where LPurposeCode='" + dto.LPurposeCode + "'";

            rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSCUBS"));
            if (rowEffect == 0)
            {
                return(0);
            }
            else
            {
                return(1);
            }
        }
Пример #2
0
        public static A2ZLPURPOSEDTO GetInformation(Int16 Purposecode)
        {
            DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZLPURPOSE WHERE LPurposeCode = " + Purposecode, "A2ZCSCUBS");


            var p = new A2ZLPURPOSEDTO();

            if (dt.Rows.Count > 0)
            {
                p.LPurposeCode        = Converter.GetSmallInteger(dt.Rows[0]["LPurposeCode"]);
                p.LPurposeDescription = Converter.GetString(dt.Rows[0]["LPurposeDescription"]);
                return(p);
            }
            p.LPurposeCode = 0;

            return(p);
        }
Пример #3
0
        public static int InsertInformation(A2ZLPURPOSEDTO dto)
        {
            dto.LPurposeDescription = (dto.LPurposeDescription != null) ? dto.LPurposeDescription.Trim().Replace("'", "''") : "";
            int    rowEffect = 0;
            string strQuery  = @"INSERT into A2ZLPURPOSE(LPurposeCode,LPurposeDescription)values('" + dto.LPurposeCode + "','" + dto.LPurposeDescription + "')";

            rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSCUBS"));

            if (rowEffect == 0)
            {
                return(0);
            }
            else
            {
                return(1);
            }
        }