示例#1
0
        public void InsertMemberLeaseInfo(MemberLeasesInfo memberLeasesInfo)
        {
            SQLConn sQLConn = new SQLConn();
            string  query   = @"insert into MemberlesesInfo(MPhone , MName , SEngineNo , LAdvance ,LDate ) 
                             values(@MPhone , @MName , @SEngineNo , @LAdvance , @LDate)";

            SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());

            SqlParameter sqlParameter = new SqlParameter
            {
                ParameterName = "MPhone",
                SqlDbType     = System.Data.SqlDbType.NVarChar,
                Value         = memberLeasesInfo.MPhone
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlParameter = new SqlParameter
            {
                ParameterName = "MName",
                SqlDbType     = System.Data.SqlDbType.NVarChar,
                Value         = memberLeasesInfo.MName
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlParameter = new SqlParameter
            {
                ParameterName = "SEngineNo",
                SqlDbType     = System.Data.SqlDbType.NVarChar,
                Value         = memberLeasesInfo.SEngineNo
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlParameter = new SqlParameter
            {
                ParameterName = "LAdvance",
                SqlDbType     = System.Data.SqlDbType.Int,
                Value         = memberLeasesInfo.MLAdvance
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlParameter = new SqlParameter
            {
                ParameterName = "LDate",
                SqlDbType     = System.Data.SqlDbType.Date,
                Value         = memberLeasesInfo.MLDate
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlCommand.ExecuteNonQuery();
        }
示例#2
0
        public MemberLeasesInfo GetMemberleasesInfo(string CSEngine, string CMPhone)
        {
            SQLConn sQLConn = new SQLConn();

            string query = @"select * from memberlesesinfo where MPhone = @CMPhone and SEngineNo = @CSEngineNo";

            SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());

            SqlParameter sqlParameter = new SqlParameter
            {
                ParameterName = "CMPhone",
                SqlDbType     = System.Data.SqlDbType.NVarChar,
                Value         = CMPhone
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlParameter = new SqlParameter
            {
                ParameterName = "CSEngineNo",
                SqlDbType     = System.Data.SqlDbType.NVarChar,
                Value         = CSEngine
            };

            sqlCommand.Parameters.Add(sqlParameter);

            SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

            if (sqlDataReader.Read())
            {
                MemberLeasesInfo memberLeasesInfo = new MemberLeasesInfo
                {
                    MName     = sqlDataReader[0].ToString(),
                    MPhone    = sqlDataReader[1].ToString(),
                    SEngineNo = sqlDataReader[2].ToString(),
                    MLAdvance = Int32.Parse(sqlDataReader[3].ToString()),
                    MLDate    = DateTime.Parse(sqlDataReader[4].ToString())
                };
                return(memberLeasesInfo);
            }
            return(null);
        }
示例#3
0
        public void UpdateMemberLeasesInfo(MemberLeasesInfo memberLeasesInfo, string CSEngine, string CMPhone)
        {
            SQLConn sQLConn = new SQLConn();
            string  query   = @"Update  MemberlesesInfo set
                            MPhone = @MPhone , MName = @MName , SEngineNo = @SEngineNo
                            , LAdvance = @LAdvance ,LDate = @LDate 
                             where Mphone = @CMPhone and SEngineNo = @CSEngine";

            SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());

            SqlParameter sqlParameter = new SqlParameter
            {
                ParameterName = "MPhone",
                SqlDbType     = System.Data.SqlDbType.NVarChar,
                Value         = memberLeasesInfo.MPhone
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlParameter = new SqlParameter
            {
                ParameterName = "MName",
                SqlDbType     = System.Data.SqlDbType.NVarChar,
                Value         = memberLeasesInfo.MName
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlParameter = new SqlParameter
            {
                ParameterName = "SEngineNo",
                SqlDbType     = System.Data.SqlDbType.NVarChar,
                Value         = memberLeasesInfo.SEngineNo
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlParameter = new SqlParameter
            {
                ParameterName = "LAdvance",
                SqlDbType     = System.Data.SqlDbType.Int,
                Value         = memberLeasesInfo.MLAdvance
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlParameter = new SqlParameter
            {
                ParameterName = "LDate",
                SqlDbType     = System.Data.SqlDbType.Date,
                Value         = memberLeasesInfo.MLDate
            };

            sqlCommand.Parameters.Add(sqlParameter);


            sqlParameter = new SqlParameter
            {
                ParameterName = "CSEngine",
                SqlDbType     = System.Data.SqlDbType.NVarChar,
                Value         = CSEngine
            };

            sqlCommand.Parameters.Add(sqlParameter);

            sqlParameter = new SqlParameter
            {
                ParameterName = "CMPhone",
                SqlDbType     = System.Data.SqlDbType.NVarChar,
                Value         = CMPhone
            };

            sqlCommand.Parameters.Add(sqlParameter);


            sqlCommand.ExecuteNonQuery();
        }