public List <LogisticsEnterprise> LoadLogisticsEnterprisesByMobile(string mobile) { string sql = @"SELECT [EnterpriseID] , [EnterpriseName] , [Address] , [LinkMan] , [Mobile] , [Tel] , [Created] , [CreatedBy] , [Modified] , [ModifiedBy] FROM [BE_LogisticsEnterprise] WHERE [Mobile]=@Mobile" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pMobile = new SqlParameter("Mobile", mobile); pMobile.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pMobile); List <LogisticsEnterprise> ret = new List <LogisticsEnterprise>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { LogisticsEnterprise iret = new LogisticsEnterprise(); if (!Convert.IsDBNull(dr["EnterpriseID"])) { iret.EnterpriseID = (Guid)dr["EnterpriseID"]; } iret.EnterpriseName = dr["EnterpriseName"].ToString(); iret.Address = dr["Address"].ToString(); iret.LinkMan = dr["LinkMan"].ToString(); iret.Mobile = dr["Mobile"].ToString(); iret.Tel = dr["Tel"].ToString(); if (!Convert.IsDBNull(dr["Created"])) { iret.Created = (DateTime)dr["Created"]; } iret.CreatedBy = dr["CreatedBy"].ToString(); if (!Convert.IsDBNull(dr["Modified"])) { iret.Modified = (DateTime)dr["Modified"]; } iret.ModifiedBy = dr["ModifiedBy"].ToString(); ret.Add(iret); } } finally { dr.Close(); } return(ret); }
public int LoadLogisticsEnterpriseByEnterpriseID(LogisticsEnterprise obj) { string sql = @"SELECT [EnterpriseID] , [EnterpriseName] , [Address] , [LinkMan] , [Mobile] , [Tel] , [Created] , [CreatedBy] , [Modified] , [ModifiedBy] FROM [BE_LogisticsEnterprise] WITH(NOLOCK) WHERE [EnterpriseID]=@EnterpriseID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pEnterpriseID = new SqlParameter("EnterpriseID", Convert2DBnull(obj.EnterpriseID)); pEnterpriseID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pEnterpriseID); int ret = 0; SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { if (!Convert.IsDBNull(dr["EnterpriseID"])) { obj.EnterpriseID = (Guid)dr["EnterpriseID"]; } obj.EnterpriseName = dr["EnterpriseName"].ToString(); obj.Address = dr["Address"].ToString(); obj.LinkMan = dr["LinkMan"].ToString(); obj.Mobile = dr["Mobile"].ToString(); obj.Tel = dr["Tel"].ToString(); if (!Convert.IsDBNull(dr["Created"])) { obj.Created = (DateTime)dr["Created"]; } obj.CreatedBy = dr["CreatedBy"].ToString(); if (!Convert.IsDBNull(dr["Modified"])) { obj.Modified = (DateTime)dr["Modified"]; } obj.ModifiedBy = dr["ModifiedBy"].ToString(); ret += 1; } } finally { dr.Close(); } return(ret); }
public int UpdateLogisticsEnterpriseByEnterpriseID(LogisticsEnterprise obj) { string sql = @"UPDATE [BE_LogisticsEnterprise] SET [EnterpriseName]=@EnterpriseName , [Address]=@Address , [LinkMan]=@LinkMan , [Mobile]=@Mobile , [Tel]=@Tel , [Created]=@Created , [CreatedBy]=@CreatedBy , [Modified]=@Modified , [ModifiedBy]=@ModifiedBy WHERE [EnterpriseID]=@EnterpriseID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pEnterpriseName = new SqlParameter("EnterpriseName", Convert2DBnull(obj.EnterpriseName)); pEnterpriseName.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pEnterpriseName); SqlParameter pAddress = new SqlParameter("Address", Convert2DBnull(obj.Address)); pAddress.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pAddress); SqlParameter pLinkMan = new SqlParameter("LinkMan", Convert2DBnull(obj.LinkMan)); pLinkMan.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pLinkMan); SqlParameter pMobile = new SqlParameter("Mobile", Convert2DBnull(obj.Mobile)); pMobile.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pMobile); SqlParameter pTel = new SqlParameter("Tel", Convert2DBnull(obj.Tel)); pTel.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pTel); SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created)); pCreated.SqlDbType = SqlDbType.DateTime; cmd.Parameters.Add(pCreated); SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy)); pCreatedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pCreatedBy); SqlParameter pModified = new SqlParameter("Modified", Convert2DBnull(obj.Modified)); pModified.SqlDbType = SqlDbType.DateTime; cmd.Parameters.Add(pModified); SqlParameter pModifiedBy = new SqlParameter("ModifiedBy", Convert2DBnull(obj.ModifiedBy)); pModifiedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pModifiedBy); SqlParameter pEnterpriseID = new SqlParameter("EnterpriseID", Convert2DBnull(obj.EnterpriseID)); pEnterpriseID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pEnterpriseID); return(cmd.ExecuteNonQuery()); }
public int InsertLogisticsEnterprise(LogisticsEnterprise obj) { string sql = @"INSERT INTO[BE_LogisticsEnterprise]([EnterpriseID] , [EnterpriseName] , [Address] , [LinkMan] , [Mobile] , [Tel] , [Created] , [CreatedBy] , [Modified] , [ModifiedBy] ) VALUES(@EnterpriseID , @EnterpriseName , @Address , @LinkMan , @Mobile , @Tel , @Created , @CreatedBy , @Modified , @ModifiedBy )" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pEnterpriseID = new SqlParameter("EnterpriseID", Convert2DBnull(obj.EnterpriseID)); pEnterpriseID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pEnterpriseID); SqlParameter pEnterpriseName = new SqlParameter("EnterpriseName", Convert2DBnull(obj.EnterpriseName)); pEnterpriseName.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pEnterpriseName); SqlParameter pAddress = new SqlParameter("Address", Convert2DBnull(obj.Address)); pAddress.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pAddress); SqlParameter pLinkMan = new SqlParameter("LinkMan", Convert2DBnull(obj.LinkMan)); pLinkMan.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pLinkMan); SqlParameter pMobile = new SqlParameter("Mobile", Convert2DBnull(obj.Mobile)); pMobile.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pMobile); SqlParameter pTel = new SqlParameter("Tel", Convert2DBnull(obj.Tel)); pTel.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pTel); SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created)); pCreated.SqlDbType = SqlDbType.DateTime; cmd.Parameters.Add(pCreated); SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy)); pCreatedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pCreatedBy); SqlParameter pModified = new SqlParameter("Modified", Convert2DBnull(obj.Modified)); pModified.SqlDbType = SqlDbType.DateTime; cmd.Parameters.Add(pModified); SqlParameter pModifiedBy = new SqlParameter("ModifiedBy", Convert2DBnull(obj.ModifiedBy)); pModifiedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pModifiedBy); return(cmd.ExecuteNonQuery()); }